DD12L

Transparent Table System Table (transport)
32 Fields 2 CDS Views

R/3 S_SECINDEX: secondary indexes, header;

DD12L is an SAP database table in S/4HANA. R/3 S_SECINDEX: secondary indexes, header;. It contains 32 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
DD_LANG_VRS_OBJ_ACTIVE_XINX view_entity from ABAP Language Version for XINX Objects
DD_LANG_VRS_OBJ_EDIT_XINX view_entity from ABAP Language Version for XINX Objects

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY sqltab TABNAME Table Name
KEY indexname INDEXID Index ID
KEY as4local AS4LOCAL Activation State
KEY as4vers AS4VERS Version
authclass AUTHCLASS_ Activation type
uniqueflag UNIQUEFLAG Unique
as4user AS4USER Last Changed By
as4date AS4DATE Date
as4time AS4TIME Time
actflag ACTFLAG Activation flag
dbindex DBINDEX_D DB Index Name
dbstate DDIXDBSTAT DB status
dbinclexcl DDIXINCEX Incl/Excl
dbsyssel1 DDIXDBSEL Database System
dbsyssel2 DDIXDBSEL Database System
dbsyssel3 DDIXDBSEL Database System
dbsyssel4 DDIXDBSEL Database System
isextind DDISEXTIND Extension Index
full_text DDFULLTEXT Index Type
langu_column DD_FTI_LANGU_COLUMN Language Column
mime_type_col DD_FTI_MIME_TYPE_COL Column for MIME Type
mime_type DD_FTI_MIME_TYPE MIME Type
langu_detection DD_FTI_LANGU_DETECTION Languages
fast_preprocess DD_FTI_FAST_PREPROCESS Fast Preprocessing
fuzzy_search_indx DD_FTI_FUZZY_SEARCH_INDX Fuzzy Search Index
search_only DD_FTI_SEARCH_ONLY Remove original formatting
update_mode DD_FTI_UPDATE_MODE Update Mode
configuration DD_FTI_CONFIGURATION Text Analysis Method
phrase_indx_ratio DD_FTI_PHRASE_INDX_RATIO DD: Ratio Phrase Index to Full-Text Index
text_analysis DD_FTI_TEXT_ANALYSIS Analysis
token_separators DD_TFI_TOKEN_SEP Separator
abap_language_version ABAP_LANGUAGE_VERSION Language Version

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- R/3 S_SECINDEX: secondary indexes, header;
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD12L (
    SQLTAB,                 -- Table Name [TABNAME]
    INDEXNAME,              -- Index ID [INDEXID]
    AS4LOCAL,               -- Activation State [AS4LOCAL]
    AS4VERS,                -- Version [AS4VERS]
    AUTHCLASS,              -- Activation type [AUTHCLASS_]
    UNIQUEFLAG,             -- Unique [UNIQUEFLAG]
    AS4USER,                -- Last Changed By [AS4USER]
    AS4DATE,                -- Date [AS4DATE]
    AS4TIME,                -- Time [AS4TIME]
    ACTFLAG,                -- Activation flag [ACTFLAG]
    DBINDEX,                -- DB Index Name [DBINDEX_D]
    DBSTATE,                -- DB status [DDIXDBSTAT]
    DBINCLEXCL,             -- Incl/Excl [DDIXINCEX]
    DBSYSSEL1,              -- Database System [DDIXDBSEL]
    DBSYSSEL2,              -- Database System [DDIXDBSEL]
    DBSYSSEL3,              -- Database System [DDIXDBSEL]
    DBSYSSEL4,              -- Database System [DDIXDBSEL]
    ISEXTIND,               -- Extension Index [DDISEXTIND]
    FULL_TEXT,              -- Index Type [DDFULLTEXT]
    LANGU_COLUMN,           -- Language Column [DD_FTI_LANGU_COLUMN]
    MIME_TYPE_COL,          -- Column for MIME Type [DD_FTI_MIME_TYPE_COL]
    MIME_TYPE,              -- MIME Type [DD_FTI_MIME_TYPE]
    LANGU_DETECTION,        -- Languages [DD_FTI_LANGU_DETECTION]
    FAST_PREPROCESS,        -- Fast Preprocessing [DD_FTI_FAST_PREPROCESS]
    FUZZY_SEARCH_INDX,      -- Fuzzy Search Index [DD_FTI_FUZZY_SEARCH_INDX]
    SEARCH_ONLY,            -- Remove original formatting [DD_FTI_SEARCH_ONLY]
    UPDATE_MODE,            -- Update Mode [DD_FTI_UPDATE_MODE]
    CONFIGURATION,          -- Text Analysis Method [DD_FTI_CONFIGURATION]
    PHRASE_INDX_RATIO,      -- DD: Ratio Phrase Index to Full-Text Index [DD_FTI_PHRASE_INDX_RATIO]
    TEXT_ANALYSIS,          -- Analysis [DD_FTI_TEXT_ANALYSIS]
    TOKEN_SEPARATORS,       -- Separator [DD_TFI_TOKEN_SEP]
    ABAP_LANGUAGE_VERSION,  -- Language Version [ABAP_LANGUAGE_VERSION]
    PRIMARY KEY (SQLTAB, INDEXNAME, AS4LOCAL, AS4VERS)
);

Learn More