T811D

Transparent Table Application Table

Allocation Belegnummern

T811D is an SAP database table in S/4HANA. Allocation Belegnummern. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationDocument view from BASIC Allocation Document

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tab dbnam Table
KEY cycle cycle Cycle
KEY sdate sdate Valid From
KEY gjahr gjahr Fiscal Year
KEY perio poper Posting Period
KEY dpos dpos Seq. Number
docnr docnr Doc. Number
adate adate Date Performed
rdoc rdocal Reversal Doc.
rdate rdate Reversal Date
reversed reversed Reversal Indic.
etab etab Actual Database
bispe poper Posting Period
nkrobj nrobj Object name
nkrsub nrsobj Subobject value
nkrnnr nrnr No. Range No.
corrpe poper Posting Period
execnum exec_num Execution Index
id schedman_id 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.

-- Allocation Belegnummern
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811D (
    MANDT,     -- Client [mandt]
    TAB,       -- Table [dbnam]
    CYCLE,     -- Cycle [cycle]
    SDATE,     -- Valid From [sdate]
    GJAHR,     -- Fiscal Year [gjahr]
    PERIO,     -- Posting Period [poper]
    DPOS,      -- Seq. Number [dpos]
    DOCNR,     -- Doc. Number [docnr]
    ADATE,     -- Date Performed [adate]
    RDOC,      -- Reversal Doc. [rdocal]
    RDATE,     -- Reversal Date [rdate]
    REVERSED,  -- Reversal Indic. [reversed]
    ETAB,      -- Actual Database [etab]
    BISPE,     -- Posting Period [poper]
    NKROBJ,    -- Object name [nrobj]
    NKRSUB,    -- Subobject value [nrsobj]
    NKRNNR,    -- No. Range No. [nrnr]
    CORRPE,    -- Posting Period [poper]
    EXECNUM,   -- Execution Index [exec_num]
    ID,        -- ID [schedman_id]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE, GJAHR, PERIO, DPOS)
);