SAP ABAP Table SGN_INDEX (Index structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW-GEN (Application Component) Generation
     ⤷ SMWGEN (Package) Middleware Generation

Basic Data

Table Category	INTTAB	Structure
Structure	SGN_INDEX	Table Relationship Diagram
Short Description	Index structure

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	HEADER	☐	TGN_DD12V		STRU	0	0
2	.INCLUDE	☐				0	0	Generated Table for View
3	SQLTAB	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name
4	INDEXNAME	☐	INDEXID	INDEXID	CHAR	3	0	Unique Index ID in a Table
5	AS4LOCAL	☐	AS4LOCAL	AS4LOCAL	CHAR	1	0	Activation Status of a Repository Object
6	AS4VERS	☐	AS4VERS	AS4VERS	NUMC	4	0	Version of the entry (not used)
7	DDLANGUAGE	☐	DDLANGUAGE	SPRAS	LANG	1	0	Language Key
8	AUTHCLASS	☐	AUTHCLASS_	AUTHCLASS	NUMC	2	0	Activation type
9	UNIQUEFLAG	☐	UNIQUEFLAG	AS4FLAG	CHAR	1	0	Flag for UNIQUE indexes
10	AS4USER	☐	AS4USER	AS4USER	CHAR	12	0	Last Changed By
11	AS4DATE	☐	AS4DATE	AS4DATE	DATS	8	0	Date of Last Change
12	AS4TIME	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
13	ACTFLAG	☐	ACTFLAG	ACTFLAG	CHAR	1	0	Activation flag
14	DBINDEX	☐	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
15	DBSTATE	☐	DDIXDBSTAT	DDIXDBSTAT	CHAR	1	0	Status of index on the database
16	DBINCLEXCL	☐	DDIXINCEX	DDIXINCEX	CHAR	1	0	List of DB systems used as list of inclusions/exclusions
17	DBSYSSEL1	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
18	DBSYSSEL2	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
19	DBSYSSEL3	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
20	DBSYSSEL4	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
21	DDTEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
22	ISEXTIND	☐	DDISEXTIND	DDISEXTIND	CHAR	1	0	DD: Flag if index is extension index
23	FULL_TEXT	☐	DDFULLTEXT	DDFULLTEXT	CHAR	1	0	DD: Full Text Index
24	LANGU_COLUMN	☐	DD_FTI_LANGU_COLUMN	FDNAME	CHAR	30	0	DD: Language Column for Full-Text Index
25	MIME_TYPE_COL	☐	DD_FTI_MIME_TYPE_COL	FDNAME	CHAR	30	0	DD: Column for Mime Type
26	MIME_TYPE	☐	DD_FTI_MIME_TYPE	DD_FTI_MIME_TYPE	CHAR	127	0	DD: Mime Type for Full-Text Index
27	LANGU_DETECTION	☐	DD_FTI_LANGU_DETECTION	DD_FTI_LANGU_DETECTION	CHAR	200	0	DD: Languages for Automatic Language Detection
28	FAST_PREPROCESS	☐	DD_FTI_FAST_PREPROCESS	DD_FTI_FAST_PREPROCESS	CHAR	1	0	DD: Fast Preprocessing On/Off
29	FUZZY_SEARCH_INDX	☐	DD_FTI_FUZZY_SEARCH_INDX	DD_FTI_FUZZY_SEARCH_INDX	CHAR	1	0	DD: Additional Index for Fuzzy Search
30	SEARCH_ONLY	☐	DD_FTI_SEARCH_ONLY	DD_FTI_SEARCH_ONLY	CHAR	1	0	DD: Original formatting will be removed
31	UPDATE_MODE	☐	DD_FTI_UPDATE_MODE	DD_FTI_UPDATE_MODE	CHAR	10	0	DD: Update Mode of Full-Text Index
32	CONFIGURATION	☐	DD_FTI_CONFIGURATION	DD_FTI_CONFIGURATION	CHAR	1	0	DD: Type of Text Analysis
33	PHRASE_INDX_RATIO	☐	DD_FTI_PHRASE_INDX_RATIO	DD_FTI_PHRASE_INDX_RATIO	NUMC	3	0	DD: Ratio Phrase Index to Full-Text Index
34	TEXT_ANALYSIS	☐	DD_FTI_TEXT_ANALYSIS	DD_FTI_TEXT_ANALYSIS	CHAR	1	0	DD: Switches on the text analysis
35	TOKEN_SEPARATORS	☐	DD_TFI_TOKEN_SEP	DD_TFI_TOKEN_SEP	CHAR	50	0	DD: Token Delimiters
36	ACTION	☐	TGN_IDXACT	GN_IDXACT	CHAR	1	0	Index operation
37	NUM	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
38	FIELDS	☐	TGN_IDXFLDS		CHAR	255	0	Index fields seperated by '+'
39	USE	☐	TGN_IDX_DESCR	TEXT80	CHAR	80	0	Description
40	FIELDS	☐	TGN_DD17VTTYP		TTYP	0	0

History

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