BASIS
Transparent table
Used the same way in S/4HANA
DD12L Secondary Indexes (Header)
Holds the header of secondary indexes defined for tables: index ID, unique flag, whether the index is created on the database and the last change. Developers and Basis teams use it to find out whether a slow query has a suitable index. The index fields are stored in DD17S; use DBSTATE to confirm that the index really exists on the database.
Main fields
| Field | Description | Key |
|---|---|---|
| SQLTAB | Table name | Yes |
| INDEXNAME | Index ID | Yes |
| AS4LOCAL | Activation status of a repository object | Yes |
| AS4VERS | Version of the entry | Yes |
| UNIQUEFLAG | Unique index flag | — |
| DBINDEX | Database index | — |
| DBSTATE | Status of index on the database | — |
| AS4USER | Last changed by | — |
| AS4DATE | Last changed on | — |
Transactions working with this table
Reports using this table
No report using this table has been added to the catalog yet.
Can't find the report you need?
We also build anything that is not in the catalog. Describe it briefly and we will suggest the right solution.