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

FieldDescriptionKey
SQLTABTable nameYes
INDEXNAMEIndex IDYes
AS4LOCALActivation status of a repository objectYes
AS4VERSVersion of the entryYes
UNIQUEFLAGUnique index flag—
DBINDEXDatabase index—
DBSTATEStatus of index on the database—
AS4USERLast changed by—
AS4DATELast 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.

Request a custom report