T811F

Transparent Table Customizing Table
18 Fields 2 CDS Views

Allocations: Element Table

T811F is an SAP database table in S/4HANA. Allocations: Element Table. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocationElement view from BASIC Allocation Element
I_UniversalAllocationElement view_entity from BASIC Universal Allocation Element

Fields (18)

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 srflag CHAR1 Single-Character Flag
KEY fpos KALC_LFDNR Sequence Number
element1 ELEMENT Element
element2 ELEMENT Element
element3 ELEMENT Element
element4 ELEMENT Element
element5 ELEMENT Element
element6 ELEMENT Element
element7 ELEMENT Element
element8 ELEMENT Element
element9 ELEMENT Element
element10 ELEMENT Element
value VALUE_FICO 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.

-- Allocations: Element Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811F (
    MANDT,      -- Client [MANDT]
    TAB,        -- Table [DBNAM]
    CYCLE,      -- Cycle [CYCLE]
    SDATE,      -- Valid From [SDATE]
    SEQNR,      -- Segment number [SQNR]
    SRFLAG,     -- Single-Character Flag [CHAR1]
    FPOS,       -- Sequence Number [KALC_LFDNR]
    ELEMENT1,   -- Element [ELEMENT]
    ELEMENT2,   -- Element [ELEMENT]
    ELEMENT3,   -- Element [ELEMENT]
    ELEMENT4,   -- Element [ELEMENT]
    ELEMENT5,   -- Element [ELEMENT]
    ELEMENT6,   -- Element [ELEMENT]
    ELEMENT7,   -- Element [ELEMENT]
    ELEMENT8,   -- Element [ELEMENT]
    ELEMENT9,   -- Element [ELEMENT]
    ELEMENT10,  -- Element [ELEMENT]
    VALUE,      -- Value [VALUE_FICO]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE, SEQNR, SRFLAG, FPOS)
);

Learn More