DD30L

Transparent Table System Table (transport)
19 Fields 11 CDS Views

Search helps

DD30L is an SAP database table in S/4HANA. Search helps. It contains 19 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
E_TBFD_SHLP view inner DD: SHLP for given TABNAME/FIELDNAME
E_TBFD_SHLP view union DD: SHLP for given TABNAME/FIELDNAME
e_tbfd_shlp_u view inner DD: SHLP for given TABNAME/FIELDNAME
e_tbfd_shlp_u view union DD: SHLP for given TABNAME/FIELDNAME
P_MDQltyModelTblFldSrchHelps view inner BASIC
P_MDQltyModelTblFldSrchHelps view union BASIC
sdsh_cds_assigned_search_helps view_entity inner Search helps of a collective search help
sdsh_cds_field_type_ahead view_entity inner Dictionary Search Helps: Table fields with type-ahead
sdsh_cds_field_type_ahead view_entity union Dictionary Search Helps: Table fields with type-ahead
sdsh_cds_tables_with_ta view inner Dictionary Search Helps: Tables with type-ahead
subshlp_cds view left_outer

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY shlpname SHLPNAME Search Help Name
KEY as4local AS4LOCAL Activation State
issimple DDSHSIMPLE elementary
elemexi ELEMEXI Incl. search helps
nofields DDSHNOFLD Flag if a search help has fields
attachexi DDSHATTEXI Flag if search help field assignment exists for search help
selmethod SELMETHOD Select. Method
selmtype SELMTYPE Selection Type
texttab SELMETHTXT Text table
selmexit DDSHSELEXT Srch. help exit
hotkey DDSHHOTKEY Hot key
dialogtype DDSHDIATYP Dialog type
actflag ACTFLAG Activation flag
as4user AS4USER Last Changed By
as4date AS4DATE Date
as4time AS4TIME Time
autosuggest DDAUTOSUGGEST Autosuggest
fuzzy_search DDFUZZY_SEARCH Error-Toler. Search
fuzzy_similarity DDFUZZY_SIMILARITY Similarity Value

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.

-- Search helps
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD30L (
    SHLPNAME,          -- Search Help Name [SHLPNAME]
    AS4LOCAL,          -- Activation State [AS4LOCAL]
    ISSIMPLE,          -- elementary [DDSHSIMPLE]
    ELEMEXI,           -- Incl. search helps [ELEMEXI]
    NOFIELDS,          -- Flag if a search help has fields [DDSHNOFLD]
    ATTACHEXI,         -- Flag if search help field assignment exists for search help [DDSHATTEXI]
    SELMETHOD,         -- Select. Method [SELMETHOD]
    SELMTYPE,          -- Selection Type [SELMTYPE]
    TEXTTAB,           -- Text table [SELMETHTXT]
    SELMEXIT,          -- Srch. help exit [DDSHSELEXT]
    HOTKEY,            -- Hot key [DDSHHOTKEY]
    DIALOGTYPE,        -- Dialog type [DDSHDIATYP]
    ACTFLAG,           -- Activation flag [ACTFLAG]
    AS4USER,           -- Last Changed By [AS4USER]
    AS4DATE,           -- Date [AS4DATE]
    AS4TIME,           -- Time [AS4TIME]
    AUTOSUGGEST,       -- Autosuggest [DDAUTOSUGGEST]
    FUZZY_SEARCH,      -- Error-Toler. Search [DDFUZZY_SEARCH]
    FUZZY_SIMILARITY,  -- Similarity Value [DDFUZZY_SIMILARITY]
    PRIMARY KEY (SHLPNAME, AS4LOCAL)
);

Learn More