Missing Tables and Indexes 

Use

You can find out whether tables or indexes are missing from either the database or the ABAP Dictionary by calling the DBA Cockpit and choosing Diagnostics ® Missing Tables and Indexes in the navigation frame of the DBA Cockpit.

This function is only available for RFC-monitored systems

The results of the last consistency check are displayed in a tree structure that is grouped into the following sections:

Section	Description
Objects missing from the database	Objects that are defined in the ABAP Dictionary, but not found in the database
Unknown objects in the ABAP Dictionary	Objects that are found in the database, but not defined in the ABAP Dictionary
Inconsistent objects	Displays the results of the detailed comparison of the ABAP Dictionary and the database
Other checks	Performs different checks: ·        Checks whether the primary index of tables defined in the ABAP Dictionary was created uniquely on the database. ·        Checks objects in the SAP system table, which cannot be described at all or which cannot be completely described in the ABAP Dictionary for technical reasons. Displays also if inconsistencies for these objects are detected. Additional information on the type of inconsistency is provided
Optional indexes	Mismatch between ABAP Dictionary and database regarding secondary indexes

If the database structure has been changed since the last consistency check, choose Refresh.

You can:

·        Create objects that are defined in the ABAP Dictionary, but not found in the database, by selecting the object and choosing Create on DB.

·        Display the definition of an object by double-clicking the object.

To ensure consistency between ABAP Dictionary and database, the consistency check should be performed once a month or when database structure changes have happened: