SAP ABAP View DD12V (Indexes with text)

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

View Type	D	Database View
Database View	DD12V
Short Description	Indexes with text
Root table	DD12L	R/3 S_SECINDEX: secondary indexes, header;

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DD12L	DD12L
2	DD12T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DD12L	SQLTAB	JL	EQ				0	0
2	DD12T	SQLTAB	JR	EQ			AND	0	0
3	DD12L	INDEXNAME	JL	EQ				0	0
4	DD12T	INDEXNAME	JR	EQ			AND	0	0
5	DD12L	AS4LOCAL		EQ	'A'		AND	0	0
6	DD12T	AS4LOCAL		EQ	'A'			0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20141013
SAP Release Created in