TCLAO

Transparent Table Customizing (protected)

Several Objects in one Class Type

TCLAO is an SAP database table in S/4HANA. Several Objects in one Class Type. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ClfnClassType view union BASIC Class Type of Classification

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY klart KLASSENART Class Type
KEY obtab TABELLE Table
grundbild GRUNDBILD Basic 2-l scrn
dynnr1 DYNPRO100 CL20N Obj. Data
dynnr2 DYNPRO200 CL24N New Obj.
dynnr3 DYNPRO300 CL24N Hdr Line
dynnr4 DYNPRO400 Value Screen No
redun REDUNDANZ Redund. storage
zaehl CLSORTPOS Sort pos.
mfkls MEHRFACHKL Multiple class.
tracl TRANSCL Master record
aeblgzuord CLAEBZUORD Change Docs
aediezuord CLAEDIZUOR ECH (time)
konfiobjid CLKONOBJID Object ID
showobjm CLSHOWOBJM Show ref. chars

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.

-- Several Objects in one Class Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCLAO (
    MANDT,       -- Client [MANDT]
    KLART,       -- Class Type [KLASSENART]
    OBTAB,       -- Table [TABELLE]
    GRUNDBILD,   -- Basic 2-l scrn [GRUNDBILD]
    DYNNR1,      -- CL20N Obj. Data [DYNPRO100]
    DYNNR2,      -- CL24N New Obj. [DYNPRO200]
    DYNNR3,      -- CL24N Hdr Line [DYNPRO300]
    DYNNR4,      -- Value Screen No [DYNPRO400]
    REDUN,       -- Redund. storage [REDUNDANZ]
    ZAEHL,       -- Sort pos. [CLSORTPOS]
    MFKLS,       -- Multiple class. [MEHRFACHKL]
    TRACL,       -- Master record [TRANSCL]
    AEBLGZUORD,  -- Change Docs [CLAEBZUORD]
    AEDIEZUORD,  -- ECH (time) [CLAEDIZUOR]
    KONFIOBJID,  -- Object ID [CLKONOBJID]
    SHOWOBJM,    -- Show ref. chars [CLSHOWOBJM]
    PRIMARY KEY (MANDT, KLART, OBTAB)
);