1. Home
  2. Resources
  3. SAP Tables
  4. DD12L - R/3 S_SECINDEX: secondary indexes, header;

SAP Table DD12L

R/3 S_SECINDEX: secondary indexes, header;

DD12L (R/3 S_SECINDEX: secondary indexes, header;) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DD12L to other SAP tables.

DD12L table fields

Field Data element Checktable Datatype Length Decimals
SQLTAB Table Name TABNAME DD02L CHAR 30 0
INDEXNAME Unique Index ID in a Table INDEXID CHAR 3 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
AS4VERS Version of the entry (not used) AS4VERS NUMC 4 0
AUTHCLASS Activation type AUTHCLASS_ NUMC 2 0
01 Nametab generation not in online (only via C program)
02 C structures must be adapted when tables are changed
10 Initial table required before R3TRANS runs
00 No classification
UNIQUEFLAG Flag for UNIQUE indexes UNIQUEFLAG CHAR 1 0
NULL Do not set flag
X Set flag
AS4USER Last Changed by AS4USER CHAR 12 0
AS4DATE Date of Last Change AS4DATE DATS 8 0
AS4TIME Last changed at AS4TIME TIMS 6 0
ACTFLAG Activation flag ACTFLAG CHAR 1 0
NULL Start of activation or activation successful
I Internal checks successful
U External checks for object OK or table as dependent faulty
DBINDEX Database index DBINDEX_D CHAR 18 0
DBSTATE Status of index on the database DDIXDBSTAT CHAR 1 0
NULL Create on database
O Do not create on database
D Create on database depending on DB system
DBINCLEXCL List of DB systems used as list of inclusions/exclusions DDIXINCEX CHAR 1 0
I List of inclusions: Create index on these DB systems
E List of exclusions: Do not create index on these DB systems
DBSYSSEL1 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL2 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL3 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL4 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
ISEXTIND DD: Flag if index is extension index DDISEXTIND CHAR 1 0
FULL_TEXT DD: Full Text Index DDFULLTEXT CHAR 1 0

DD12L foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DD12L SQLTAB DD12L SQLTAB DD02L SAP Tables TABNAME
DD12L SQLTAB * DD02L SAP Tables AS4LOCAL
DD12L SQLTAB * DD02L SAP Tables AS4VERS