Show TOC

 Database - ABAP Dictionary ConsistencyLocate this document in the navigation structure

Use

With this function, you can find all the database objects that are defined in the ABAP Dictionary but have not been created in the database (or were deleted). This function also displays objects that were created directly in the database and are therefore unknown in the ABAP Dictionary.

Procedure
  1. Choose Tools Administration Computing Center Management System Control Performance Menu Database Tables / Indexes Checks  Database <->ABAP Dictionary consistency.

    Alternatively, use transaction code DB02.

  2. Choose Checks Database <-> ABAP Dictionary consistency.

When you choose this function, the date of the last check is displayed in a second window. You can now choose whether you want to see the result of the last check (from the performance database), or whether you want to start a new check online. In the latter case, you can expect a wait time of a few minutes (depending on system load). The online check updates the relevant data in the performance database.

The inconsistencies found are displayed in a hierarchy:

 

Use Display def. to branch directly to the ABAP Dictionary where you can look at the object definitions. With Create in DB, you can create the missing objects directly in the database.

In most cases, you can perform a closer analysis of objects unknown to the ABAP Dictionary using Display def., their database definitions are then displayed.

See also:

Creating Objects in the Database

Displaying Object Definitions

Note

Database <-> ABAP Dictionary consistency  only checks the existence of objects. A precise comparison of the objects would be too expensive.

If the checks show that objects are missing, you should first find out whether they are test objects (these should not be in the database). This is the most likely explanation for an inconsistency.