SAP ABAP Table DD12L (R/3 S_SECINDEX: secondary indexes, header;)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SDIC (Package) ABAP Dictionary

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DD12L	Table Relationship Diagram
Short Description	R/3 S_SECINDEX: secondary indexes, header;

Delivery and Maintenance

Pool/cluster
Delivery Class	W	System table, contents transportable via separate TR objects
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SQLTAB	☑	TABNAME	AS4TAB	CHAR	30	0	Table Name	DD02L
2	INDEXNAME	☑	INDEXID	INDEXID	CHAR	3	0	Unique Index ID in a Table
3	AS4LOCAL	☑	AS4LOCAL	AS4LOCAL	CHAR	1	0	Activation Status of a Repository Object
4	AS4VERS	☑	AS4VERS	AS4VERS	NUMC	4	0	Version of the entry (not used)
5	AUTHCLASS	☐	AUTHCLASS_	AUTHCLASS	NUMC	2	0	Activation type
6	UNIQUEFLAG	☐	UNIQUEFLAG	AS4FLAG	CHAR	1	0	Flag for UNIQUE indexes
7	AS4USER	☐	AS4USER	AS4USER	CHAR	12	0	Last Changed By
8	AS4DATE	☐	AS4DATE	AS4DATE	DATS	8	0	Date of Last Change
9	AS4TIME	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
10	ACTFLAG	☐	ACTFLAG	ACTFLAG	CHAR	1	0	Activation flag
11	DBINDEX	☐	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
12	DBSTATE	☐	DDIXDBSTAT	DDIXDBSTAT	CHAR	1	0	Status of index on the database
13	DBINCLEXCL	☐	DDIXINCEX	DDIXINCEX	CHAR	1	0	List of DB systems used as list of inclusions/exclusions
14	DBSYSSEL1	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
15	DBSYSSEL2	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
16	DBSYSSEL3	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
17	DBSYSSEL4	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
18	ISEXTIND	☐	DDISEXTIND	DDISEXTIND	CHAR	1	0	DD: Flag if index is extension index
19	.INCLUDE	☐				0	0	DD: Secondary Indexes, Full Text Index Information
20	FULL_TEXT	☐	DDFULLTEXT	DDFULLTEXT	CHAR	1	0	DD: Full Text Index
21	LANGU_COLUMN	☐	DD_FTI_LANGU_COLUMN	FDNAME	CHAR	30	0	DD: Language Column for Full-Text Index	*
22	MIME_TYPE_COL	☐	DD_FTI_MIME_TYPE_COL	FDNAME	CHAR	30	0	DD: Column for Mime Type	*
23	MIME_TYPE	☐	DD_FTI_MIME_TYPE	DD_FTI_MIME_TYPE	CHAR	127	0	DD: Mime Type for Full-Text Index	DDMIMETYPES
24	LANGU_DETECTION	☐	DD_FTI_LANGU_DETECTION	DD_FTI_LANGU_DETECTION	CHAR	200	0	DD: Languages for Automatic Language Detection
25	FAST_PREPROCESS	☐	DD_FTI_FAST_PREPROCESS	DD_FTI_FAST_PREPROCESS	CHAR	1	0	DD: Fast Preprocessing On/Off
26	FUZZY_SEARCH_INDX	☐	DD_FTI_FUZZY_SEARCH_INDX	DD_FTI_FUZZY_SEARCH_INDX	CHAR	1	0	DD: Additional Index for Fuzzy Search
27	SEARCH_ONLY	☐	DD_FTI_SEARCH_ONLY	DD_FTI_SEARCH_ONLY	CHAR	1	0	DD: Original formatting will be removed
28	UPDATE_MODE	☐	DD_FTI_UPDATE_MODE	DD_FTI_UPDATE_MODE	CHAR	10	0	DD: Update Mode of Full-Text Index
29	CONFIGURATION	☐	DD_FTI_CONFIGURATION	DD_FTI_CONFIGURATION	CHAR	1	0	DD: Type of Text Analysis
30	PHRASE_INDX_RATIO	☐	DD_FTI_PHRASE_INDX_RATIO	DD_FTI_PHRASE_INDX_RATIO	NUMC	3	0	DD: Ratio Phrase Index to Full-Text Index
31	TEXT_ANALYSIS	☐	DD_FTI_TEXT_ANALYSIS	DD_FTI_TEXT_ANALYSIS	CHAR	1	0	DD: Switches on the text analysis
32	TOKEN_SEPARATORS	☐	DD_TFI_TOKEN_SEP	DD_TFI_TOKEN_SEP	CHAR	50	0	DD: Token Delimiters

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DD12L	MIME_TYPE	DDMIMETYPES	MIME_TYPE
2	DD12L	SQLTAB	DD02L	TABNAME	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in