DD09L

Transparent Table System Table (transport)
21 Fields 1 CDS Views

DD: Technical settings of tables

DD09L is an SAP database table in S/4HANA. DD: Technical settings of tables. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
dhamb_base_dp_table view_entity left_outer DI meta data browser: list of DDIC tables

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY tabname TABNAME Table Name
KEY as4local AS4LOCAL Activation State
KEY as4vers AS4VERS Version
tabkat TABKAT Size category
tabart TABART Data Class
pufferung PUFFERUNG Buffering type
schfeldanz SCHFELDANZ NoKeyFields
protokoll DDPROTOCOL Log
speichpuff SPEICHPUFF StorTypeBuffr
as4user AS4USER Last Changed By
as4date AS4DATE Date
as4time AS4TIME Time
transpflag DDTRANSP Transparency
reserve DDRESERVE Reserved Field in ABAP Dictionary
uebersetz UEBERSETZ Rel. for trans.
actflag ACTFLAG Activation flag
bufallow BUFALLOW Buff. allowed
javaonly DDJAVAONLY JavaOnly
roworcolst DDROWORCOLST Storage Type
sharingtype DDSHARINGTYPE Sharing Type
load_unit HDB_LOAD_UNIT Load Unit

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.

-- DD: Technical settings of tables
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD09L (
    TABNAME,      -- Table Name [TABNAME]
    AS4LOCAL,     -- Activation State [AS4LOCAL]
    AS4VERS,      -- Version [AS4VERS]
    TABKAT,       -- Size category [TABKAT]
    TABART,       -- Data Class [TABART]
    PUFFERUNG,    -- Buffering type [PUFFERUNG]
    SCHFELDANZ,   -- NoKeyFields [SCHFELDANZ]
    PROTOKOLL,    -- Log [DDPROTOCOL]
    SPEICHPUFF,   -- StorTypeBuffr [SPEICHPUFF]
    AS4USER,      -- Last Changed By [AS4USER]
    AS4DATE,      -- Date [AS4DATE]
    AS4TIME,      -- Time [AS4TIME]
    TRANSPFLAG,   -- Transparency [DDTRANSP]
    RESERVE,      -- Reserved Field in ABAP Dictionary [DDRESERVE]
    UEBERSETZ,    -- Rel. for trans. [UEBERSETZ]
    ACTFLAG,      -- Activation flag [ACTFLAG]
    BUFALLOW,     -- Buff. allowed [BUFALLOW]
    JAVAONLY,     -- JavaOnly [DDJAVAONLY]
    ROWORCOLST,   -- Storage Type [DDROWORCOLST]
    SHARINGTYPE,  -- Sharing Type [DDSHARINGTYPE]
    LOAD_UNIT,    -- Load Unit [HDB_LOAD_UNIT]
    PRIMARY KEY (TABNAME, AS4LOCAL, AS4VERS)
);

Learn More