DD12L - R/3 S_SECINDEX: secondary indexes, header;

R/3 S_SECINDEX: secondary indexes, header; information is stored in SAP table DD12L.
It is part of development package SDIC in software component BC-DWB-DIC-AC. This development package consists of objects that can be grouped under "ABAP Dictionary".

Fields for table DD12L

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
SQLTAB	Table Name	X	TABNAME	CHAR	60	DD02L
INDEXNAME	Unique Index ID in a Table	X	INDEXID	CHAR	6
AS4LOCAL	Activation State of Repository Object	X	AS4LOCAL	CHAR	2
AS4VERS	Version of the entry (not used)	X	AS4VERS	NUMC	8
AUTHCLASS	Activation type		AUTHCLASS_	NUMC	4
UNIQUEFLAG	Flag for UNIQUE indexes		UNIQUEFLAG	CHAR	2
AS4USER	Last Changed By		AS4USER	CHAR	24
AS4DATE	Last Changed On		AS4DATE	DATS	16
AS4TIME	Last changed at		AS4TIME	TIMS	12
ACTFLAG	Activation flag		ACTFLAG	CHAR	2
DBINDEX	Database index		DBINDEX_D	CHAR	80
DBSTATE	Status of index on the database		DDIXDBSTAT	CHAR	2
DBINCLEXCL	List of DB systems used as list of inclusions/exclusions		DDIXINCEX	CHAR	2
DBSYSSEL1	Choose a database system for DB-specific indexes		DDIXDBSEL	CHAR	6
DBSYSSEL2	Choose a database system for DB-specific indexes		DDIXDBSEL	CHAR	6
DBSYSSEL3	Choose a database system for DB-specific indexes		DDIXDBSEL	CHAR	6
DBSYSSEL4	Choose a database system for DB-specific indexes		DDIXDBSEL	CHAR	6
ISEXTIND	DD: Flag if index is extension index		DDISEXTIND	CHAR	2
.INCLUDE				DD12FULLTEXTINFO	0
FULL_TEXT	DD: Full Text Index		DDFULLTEXT	CHAR	2
LANGU_COLUMN	DD: Language Column for Full-Text Index		DD_FTI_LANGU_COLUMN	CHAR	60
MIME_TYPE_COL	DD: Column for Mime Type		DD_FTI_MIME_TYPE_COL	CHAR	60
MIME_TYPE	DD: Mime Type for Full-Text Index		DD_FTI_MIME_TYPE	CHAR	254	DDMIMETYPES
LANGU_DETECTION	DD: Languages for Automatic Language Detection		DD_FTI_LANGU_DETECTION	CHAR	400
FAST_PREPROCESS	DD: Fast Preprocessing On/Off		DD_FTI_FAST_PREPROCESS	CHAR	2
FUZZY_SEARCH_INDX	DD: Additional Index for Fuzzy Search		DD_FTI_FUZZY_SEARCH_INDX	CHAR	2
SEARCH_ONLY	DD: Original formatting will be removed		DD_FTI_SEARCH_ONLY	CHAR	2
UPDATE_MODE	DD: Update Mode of Full-Text Index		DD_FTI_UPDATE_MODE	CHAR	20
CONFIGURATION	DD: Type of Text Analysis		DD_FTI_CONFIGURATION	CHAR	2
PHRASE_INDX_RATIO	DD: Ratio Phrase Index to Full-Text Index		DD_FTI_PHRASE_INDX_RATIO	NUMC	6
TEXT_ANALYSIS	DD: Switches on the text analysis		DD_FTI_TEXT_ANALYSIS	CHAR	2
TOKEN_SEPARATORS	DD: Token Delimiters		DD_TFI_TOKEN_SEP	CHAR	100