Answer / tanmoy

The database utility is the interface between the ABAP
Dictionary and the relational database underlying the R/3
System.

You can use the database utility to edit all the database
objects that are generated from objects of the ABAP
Dictionary. These are database tables that are generated
from transparent tables or physical table pools or table
clusters, indexes, database views.

It is mainly used when a table is changed in the ABAP
Dictionary.At that time,we must ensure that the database
structure of the table is adjusted to the change in the ABAP
Dictionary during activation.

You can call the database utility from the initial screen of
the ABAP/4 Dictionary(SE11) with Utilities -> Database
utility or using T-code SE14.

The database structure of a table can be adjusted to its
changed ABAP Dictionary definition in three ways:

* By deleting and recreating the database table The
table is deleted in the database. The revised version of the
table is then activated in the ABAP Dictionary and created
again in the database. Data in the table is lost during this
process.
* By changing the database catalog (ALTER TABLE) Only
the definition of the table is changed in the database. Data
in the table is retained. The indexes on the table might
have to be rebuilt.
* By converting the table . The database table is
renamed and serves as a temporary buffer for the data. The
revised version of the table is activated in the ABAP
Dictionary and created in the database. The data is reloaded
from the temporary buffer to the new database table (with
MOVE-CORRESPONDING) and the indexes on the table are built.

The database utility provides a number of options for
administering and monitoring requests for database
modifications. You can perform these functions directly in
the initial screen of the database utility.

What is the difference between Collect statement and Append Statement?

2 Answers   Accenture, Deloitte, Maventic, TCS,

---

what is the purpose of RDBMOIND RPOGRAM?

2 Answers  

---

What is runtime analysis? Have you used this?

2 Answers   IBM,

---

Where do you find info on new developments in SAP?

0 Answers  

---

What are the various types of the Internal tables used?

4 Answers   TCS,

---

What is an update type with reference to a match code id? : abap data dictionary

0 Answers  

---

What is SAPscript and layout set?

1 Answers  

---

please any one can tell me modifytable keyword used in DDIC? what is a basic diffrence between modify table and update key word?

4 Answers   KPIT,

---

What is the Process to transfer IDOC from Outbound System to Inbound system.

0 Answers  

---

I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/

0 Answers   Accenture,

---

What is the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary

0 Answers  

---

what are system Variables?

1 Answers   Atos Origin,

---