Show TOC Start of Content Area

Procedure documentation Consistency Checks  Locate the document in its SAP Library structure

Use

Three different functions are provided for checking consistency between the ABAP Dictionary and the database:

·        Missing indexes

Displays indexes that are not known in the database or ABAP Dictionary.

·        Database - ABAP Dictionary consistency

The existence of all database objects defined in the ABAP Dictionary is checked.

·        Database tables without a unique index

Displays database tables without a unique index.

Procedure

...

       1.      Choose Tools Administration Computing Center Management System Control Performance Menu Database Tables / Indexes.

Alternatively, use transaction code DB02.

       2.      Display missing indexes with Missing indexes.
Use the Checks function to perform the consistency checks described above.

The results are displayed in a hierarchy:

Results in the Hierarchy

Hierarchy Level

Result

top

distinction between the objects defined in the ABAP Dictionary and the objects defined in the database

middle

subdivision by object type, for example by table, view or index, and the number of missing objects is displayed in each case

lowest

displaying the names of the individual objects

 

See also:

Missing Indexes

Database - ABAP Dictionary Consistency

Database Tables without a Unique Index

Creating Objects in the Database

Displaying Object Definitions

Naming Conventions for Indexes

 

End of Content Area