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.
- Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.
Alternatively, use transaction code DB02.
- 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