Secondary indexes, header — the registry of every secondary (non-primary) database index defined on a table, including uniqueness and per-database-system inclusion/exclusion. This matters to the sovereign mirror because a crosswalk's claim that a field or field combination is uniquely identifying, or that a lookup is index-supported, is checkable against DD12L rather than inferred from query behavior — the mirror can confirm the customer's own system actually defines that index instead of trusting a performance assumption. Table carried complete.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| TBL_NOM key | tabula nomen | Table Name | TABNAME | CHAR 30 | DD02L |
| IDX_TBL key | index tabula | Unique Index ID in a Table | INDEXID | CHAR 3 | — |
| STA_OBI key | status obiectum | Activation Status of a Repository Object | AS4LOCAL | CHAR 1 | — |
| VRS | versio | Version of the entry (not used) | AS4VERS | NUMC 4 | — |
| GEN | genus | Activation type | AUTHCLASS_ | NUMC 2 | — |
| SGN | signum | Flag for UNIQUE indexes | UNIQUEFLAG | CHAR 1 | — |
| ULT_MUT | ultimus mutatus | Last Changed by | AS4USER | CHAR 12 | — |
| DIE_ULT | dies ultimus | Date of Last Change | AS4DATE | DATS 8 | — |
| ULT_MUT2 | ultimus mutatus | Last changed at | AS4TIME | TIMS 6 | — |
| SGN2 | signum | Activation flag | ACTFLAG | CHAR 1 | — |
| IDX | index | Database index | DBINDEX_D | CHAR 18 | — |
| STA_IDX | status index | Status of index on the database | DDIXDBSTAT | CHAR 1 | — |
| DBINCLEXCL | List of DB systems used as list of inclusions/exclusions | DDIXINCEX | CHAR 1 | — | |
| DBSYSSEL1 | Choose a database system for DB-specific indexes | DDIXDBSEL | CHAR 3 | — | |
| DBSYSSEL2 | Choose a database system for DB-specific indexes | DDIXDBSEL | CHAR 3 | — | |
| DBSYSSEL3 | Choose a database system for DB-specific indexes | DDIXDBSEL | CHAR 3 | — | |
| DBSYSSEL4 | Choose a database system for DB-specific indexes | DDIXDBSEL | CHAR 3 | — | |
| SGN_IDX | signum index | DD: Flag if index is extension index | DDISEXTIND | CHAR 1 | — |
| TXT_IDX | textus index | DD: Full Text Index | DDFULLTEXT | CHAR 1 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
SQLTAB | DD02L | TABNAME |