SAP ABAP Table DBINDEX (DB index name and unique flag)

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	INTTAB	Structure
Structure	DBINDEX	Table Relationship Diagram
Short Description	DB index name and unique flag

Delivery and Maintenance

Pool/cluster
Delivery Class
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	NAME	☐	DBOBJECT_D	CHAR30	CHAR	30	0	Table or index name
2	UNIQUE	☐	UNIQUEFLAG	AS4FLAG	CHAR	1	0	Flag for UNIQUE indexes
3	.INCLUDE	☐				0	0	DD: Secondary Indexes, Full Text Index Information
4	FULL_TEXT	☐	DDFULLTEXT	DDFULLTEXT	CHAR	1	0	DD: Full Text Index
5	LANGU_COLUMN	☐	DD_FTI_LANGU_COLUMN	FDNAME	CHAR	30	0	DD: Language Column for Full-Text Index	*
6	MIME_TYPE_COL	☐	DD_FTI_MIME_TYPE_COL	FDNAME	CHAR	30	0	DD: Column for Mime Type	*
7	MIME_TYPE	☐	DD_FTI_MIME_TYPE	DD_FTI_MIME_TYPE	CHAR	127	0	DD: Mime Type for Full-Text Index	DDMIMETYPES
8	LANGU_DETECTION	☐	DD_FTI_LANGU_DETECTION	DD_FTI_LANGU_DETECTION	CHAR	200	0	DD: Languages for Automatic Language Detection
9	FAST_PREPROCESS	☐	DD_FTI_FAST_PREPROCESS	DD_FTI_FAST_PREPROCESS	CHAR	1	0	DD: Fast Preprocessing On/Off
10	FUZZY_SEARCH_INDX	☐	DD_FTI_FUZZY_SEARCH_INDX	DD_FTI_FUZZY_SEARCH_INDX	CHAR	1	0	DD: Additional Index for Fuzzy Search
11	SEARCH_ONLY	☐	DD_FTI_SEARCH_ONLY	DD_FTI_SEARCH_ONLY	CHAR	1	0	DD: Original formatting will be removed
12	UPDATE_MODE	☐	DD_FTI_UPDATE_MODE	DD_FTI_UPDATE_MODE	CHAR	10	0	DD: Update Mode of Full-Text Index
13	CONFIGURATION	☐	DD_FTI_CONFIGURATION	DD_FTI_CONFIGURATION	CHAR	1	0	DD: Type of Text Analysis
14	PHRASE_INDX_RATIO	☐	DD_FTI_PHRASE_INDX_RATIO	DD_FTI_PHRASE_INDX_RATIO	NUMC	3	0	DD: Ratio Phrase Index to Full-Text Index
15	TEXT_ANALYSIS	☐	DD_FTI_TEXT_ANALYSIS	DD_FTI_TEXT_ANALYSIS	CHAR	1	0	DD: Switches on the text analysis
16	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	DBINDEX	MIME_TYPE	DDMIMETYPES	MIME_TYPE

History

Last changed by/on	SAP	20141013
SAP Release Created in	740