T811DERIVE

Transparent Table Application Table
7 Fields 2 CDS Views

Univ Alloc: Control Derivation Behavior for Field Value

T811DERIVE is an SAP database table in S/4HANA. Univ Alloc: Control Derivation Behavior for Field Value. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationFieldDerivation view from BASIC Allocation Field Derivation
I_UnivAllocFieldDerivation view_entity from BASIC Allocation Field Derivation

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
KEY setkind SETKIND Type of Set
KEY field FDNAM Field
derive DERIVE Derive 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.

-- Univ Alloc: Control Derivation Behavior for Field Value
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811DERIVE (
    MANDT,    -- Client [MANDT]
    TAB,      -- Table [DBNAM]
    CYCLE,    -- Cycle [CYCLE]
    SDATE,    -- Valid From [SDATE]
    SETKIND,  -- Type of Set [SETKIND]
    FIELD,    -- Field [FDNAM]
    DERIVE,   -- Derive Value [DERIVE]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE, SETKIND, FIELD)
);

Learn More