SAP ABAP Table DD12V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	DD12V	Table Relationship Diagram
Short Description	Generated Table for View

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	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	DDLANGUAGE	☑	DDLANGUAGE	SPRAS	LANG	1	0	Language Key
6	AUTHCLASS	☐	AUTHCLASS_	AUTHCLASS	NUMC	2	0	Activation type
7	UNIQUEFLAG	☐	UNIQUEFLAG	AS4FLAG	CHAR	1	0	Flag for UNIQUE indexes
8	AS4USER	☐	AS4USER	AS4USER	CHAR	12	0	Last Changed By
9	AS4DATE	☐	AS4DATE	AS4DATE	DATS	8	0	Date of Last Change
10	AS4TIME	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
11	ACTFLAG	☐	ACTFLAG	ACTFLAG	CHAR	1	0	Activation flag
12	DBINDEX	☐	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
13	DBSTATE	☐	DDIXDBSTAT	DDIXDBSTAT	CHAR	1	0	Status of index on the database
14	DBINCLEXCL	☐	DDIXINCEX	DDIXINCEX	CHAR	1	0	List of DB systems used as list of inclusions/exclusions
15	DBSYSSEL1	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
16	DBSYSSEL2	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
17	DBSYSSEL3	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
18	DBSYSSEL4	☐	DDIXDBSEL	DDIXDBSEL	CHAR	3	0	Choose a database system for DB-specific indexes
19	DDTEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
20	ISEXTIND	☐	DDISEXTIND	DDISEXTIND	CHAR	1	0	DD: Flag if index is extension index
21	FULL_TEXT	☐	DDFULLTEXT	DDFULLTEXT	CHAR	1	0	DD: Full Text Index
22	LANGU_COLUMN	☐	DD_FTI_LANGU_COLUMN	FDNAME	CHAR	30	0	DD: Language Column for Full-Text Index
23	MIME_TYPE_COL	☐	DD_FTI_MIME_TYPE_COL	FDNAME	CHAR	30	0	DD: Column for Mime Type
24	MIME_TYPE	☐	DD_FTI_MIME_TYPE	DD_FTI_MIME_TYPE	CHAR	127	0	DD: Mime Type for Full-Text Index	DDMIMETYPES
25	LANGU_DETECTION	☐	DD_FTI_LANGU_DETECTION	DD_FTI_LANGU_DETECTION	CHAR	200	0	DD: Languages for Automatic Language Detection
26	FAST_PREPROCESS	☐	DD_FTI_FAST_PREPROCESS	DD_FTI_FAST_PREPROCESS	CHAR	1	0	DD: Fast Preprocessing On/Off
27	FUZZY_SEARCH_INDX	☐	DD_FTI_FUZZY_SEARCH_INDX	DD_FTI_FUZZY_SEARCH_INDX	CHAR	1	0	DD: Additional Index for Fuzzy Search
28	SEARCH_ONLY	☐	DD_FTI_SEARCH_ONLY	DD_FTI_SEARCH_ONLY	CHAR	1	0	DD: Original formatting will be removed
29	UPDATE_MODE	☐	DD_FTI_UPDATE_MODE	DD_FTI_UPDATE_MODE	CHAR	10	0	DD: Update Mode of Full-Text Index
30	CONFIGURATION	☐	DD_FTI_CONFIGURATION	DD_FTI_CONFIGURATION	CHAR	1	0	DD: Type of Text Analysis
31	PHRASE_INDX_RATIO	☐	DD_FTI_PHRASE_INDX_RATIO	DD_FTI_PHRASE_INDX_RATIO	NUMC	3	0	DD: Ratio Phrase Index to Full-Text Index
32	TEXT_ANALYSIS	☐	DD_FTI_TEXT_ANALYSIS	DD_FTI_TEXT_ANALYSIS	CHAR	1	0	DD: Switches on the text analysis
33	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	DD12V	MIME_TYPE	DDMIMETYPES	MIME_TYPE
2	DD12V	SQLTAB	DD02L	TABNAME	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in