# 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.

- Modules: BASIS
- Type: Transparent table
- S/4HANA status: Used the same way in S/4HANA

- URL: https://nekuhub.com/en/tables/dd12l/

## 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

SE14

## Reports using this table

