Consistency Checks 

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

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

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

Displays database tables without a unique index.

To perform the consistency checks:

  1. From the R/3 main screen, choose Tools ® Administration ® Computing Center ® Management System ® Control ® Performance Menu ® Database ® Tables / Indexes.

    2. 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:

Table: 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

Missing Indexes

Database - ABAP Dictionary Consistency

Database Tables without a Unique Index

Creating Objects in the Database

Displaying Object Definitions

Naming Conventions for Indexes