DD02L

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.

-- SAP Tables
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD02L (
    TABNAME,                   -- Table Name [TABNAME]
    AS4LOCAL,                  -- Activation State [AS4LOCAL]
    AS4VERS,                   -- Version [AS4VERS]
    TABCLASS,                  -- Table Category [TABCLASS]
    SQLTAB,                    -- Pool/Cluster [SQLAPPDTAB]
    DATMIN,                    -- Min.no. of entries [DATMIN]
    DATMAX,                    -- Max.no. of entries [DATMAX]
    DATAVG,                    -- Av. no. of entries [DATAVG]
    CLIDEP,                    -- Client-specific [CLIDEP]
    BUFFERED,                  -- Buff. allowed [BUFFERED]
    COMPRFLAG,                 -- Compression [COMPREX]
    LANGDEP,                   -- Lng.Dep [LANGDEP]
    ACTFLAG,                   -- Activation flag [ACTFLAG]
    APPLCLASS,                 -- Application Class [APPLCLASS]
    AUTHCLASS,                 -- Activation type [AUTHCLASS_]
    AS4USER,                   -- Last Changed By [AS4USER]
    AS4DATE,                   -- Date [AS4DATE]
    AS4TIME,                   -- Time [AS4TIME]
    MASTERLANG,                -- Original Lang. [MASTERLANG]
    MAINFLAG,                  -- Table Maintenance [MAINTFLAG]
    CONTFLAG,                  -- Delivery class [CONTFLAG]
    RESERVETAB,                -- SDIC: Reserve for tables [RESERVETAB]
    GLOBALFLAG,                -- Not global [GLOBALFLAG]
    PROZPUFF,                  -- Buff. perc [PROZPUFF]
    VIEWCLASS,                 -- View Type [VIEWCLASS]
    VIEWGRANT,                 -- Maint. status [VIEWGRANT]
    MULTIPLEX,                 -- Multiplex flag [MULTIPLEX]
    SHLPEXI,                   -- Search help binding to table exists [SHLPEXI]
    PROXYTYPE,                 -- PrxyUsage [DDPROXYTY]
    EXCLASS,                   -- DD: Ranking for include and subtype extension [DDRANKING]
    WRONGCL,                   -- Wrong Class [DDWRONGCL]
    ALWAYSTRP,                 -- Transparent [DDALWAYSTRP]
    ALLDATAINCL,               -- DD: DataAging: Handle data as hot and cold if switched on [DDALLDATAINCLU]
    WITH_PARAMETERS,           -- DD: Set whenever a view or base view has parameters [DDWITHPAR]
    EXVIEW_INCLUDED,           -- DD: Contains at least one external view in the hierarchy [DDEXTVIEW_INCLUDED]
    KEYMAX_FEATURE,            -- DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fields [DDDBKEYMAXFEATURE]
    KEYLEN_FEATURE,            -- DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length [DDDBKEYLENFEATURE]
    TABLEN_FEATURE,            -- DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1 [DDDBTABLENFEATURE]
    NONTRP_INCLUDED,           -- Obsolete [DDNONTRANSP_INCLUDED]
    VIEWREF,                   -- View Name [VIEWNAME]
    VIEWREF_ERR,               -- Replacement object cannot be used [DDVIEWREF_ERR]
    VIEWREF_POS_CHG,           -- Replacement object exists in different positions [DDVIEWREF_POSCHG]
    TBFUNC_INCLUDED,           -- Contains info whether a table function exists in hierarchy [DDTBFUNC_INCLUDED]
    IS_GTT,                    -- Flag whether table is a global temporary table [DD_IS_GTT]
    SESSION_VAR_EX,            -- DD: Does a session variable exist? [DDSESSIONVAR_EX]
    FROM_ENTITY,               -- DD: Table is generated from an entity DDL [DDTABGEN_FROM_DDL]
    PK_IS_INVHASH,             -- Create primary key as inverted hash/individual [DDPK_IS_INVHASH]
    USED_SESSION_VARS,         -- DD: Session Variables Used [DDUSEDSESSION_VARS]
    ABAP_LANGUAGE_VERSION,     -- Language Version [ABAP_LANGUAGE_VERSION]
    HDB_ONLY_ENTITY_INCLUDED,  -- HDB entity [DDHDBONLY_ENTITY_INCLUDED]
    FIELD_SUFFIX,              -- Field Suffix [DDFIELDSUFFIX]
    QUOTA_MAX_FIELDS,          -- Quota Fields [DDQUOTAFIELDS]
    QUOTA_MAX_BYTES,           -- Quota Bytes [DDQUOTABYTES]
    QUOTA_SHARE_PARTNER,       -- Quota Share [DDQUOTASHARE]
    QUOTA_SHARE_CUSTOMER,      -- Quota Share [DDQUOTASHARE]
    PRIMARY KEY (TABNAME, AS4LOCAL, AS4VERS)
);