T811K

Transparent Table Customizing Table
12 Fields 2 CDS Views

Allocations: Key Fields

T811K is an SAP database table in S/4HANA. Allocations: Key Fields. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationKeyField view from BASIC Allocation Key Field
I_UniversalAllocationKeyField view_entity from BASIC Universal Allocation Key Field

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
KEY seqnr SQNR Segment number
KEY setkind SETKIND Type of Set
KEY pos DPOS Seq. Number
field FDNAM Field
setname SETNR Set ID
valmin SETVALMIN From Value
valmax SETVALMAX To Value
setid SETID Set ID

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.

-- Allocations: Key Fields
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811K (
    MANDT,    -- Client [MANDT]
    TAB,      -- Table [DBNAM]
    CYCLE,    -- Cycle [CYCLE]
    SDATE,    -- Valid From [SDATE]
    SEQNR,    -- Segment number [SQNR]
    SETKIND,  -- Type of Set [SETKIND]
    POS,      -- Seq. Number [DPOS]
    FIELD,    -- Field [FDNAM]
    SETNAME,  -- Set ID [SETNR]
    VALMIN,   -- From Value [SETVALMIN]
    VALMAX,   -- To Value [SETVALMAX]
    SETID,    -- Set ID [SETID]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE, SEQNR, SETKIND, POS)
);

Learn More