Database Tables without a Unique Index
This function checks whether the tables defined in the ABAP Dictionary have a primary index and whether it was created with the "unique" option. (The existence of a primary key constraint is sufficient for some databases. This is also taken into account here.)
- Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes →Checks →Database tables without unique indexes.
Alternatively, use transaction code DB02.
- Choose Checks → Database tables without unique indexes.
This online check also displays tables that were created directly in the database and have no unique index. Whether a unique index is required for these tables depends on the purpose of their use.
An unique index ensures that no duplicates are entered in a table. If primary indexes are missing for ABAP Dictionary tables, it is essential that you create them with Create in DB. To correct primary indexes created without the unique option, you should go to the ABAP Dictionary via Display def. From here, you can branch to the Database Utility via Utilities.
If duplicate keys have already been inserted in the table, it is no longer possible to create the index. You must identify the incorrect keys and delete them. In difficult cases, contact SAP regarding the restoration of the index.
Normally, a table should only be defined via the ABAP Dictionary.
See also:
Naming Conventions for Indexes