Consistency Checks
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.
...
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:
Database - ABAP Dictionary Consistency
Database Tables without a Unique Index
Creating Objects in the Database
Naming Conventions for Indexes