T811SV

Transparent Table Customizing Table

Versioning Allocation Segments

T811SV is an SAP database table in S/4HANA. Versioning Allocation Segments. It contains 51 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationSegmentVersion view_entity from BASIC Allocation Cycle Segment Version

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY id SCHEDMAN_ID ID
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
KEY seqnr SQNR Segment number
name SEQNAME Segment
seqpos SEQPOS Item
srule SRULE Sender Rule
rrule RRULE Receiver Rule
active SEQBLK Lock indicator
negtest NEGTEST Scale Neg. Factors
scset SETNR Set ID
sset SETNR Set ID
rset SETNR Set ID
rcset SETNR Set ID
spercent SNDPERCENT Share in %
sffeld1 FIX_AMOUNT Fixed Amount
sffeld2 FIX_AMOUNT Fixed Amount
sffeld3 FIX_AMOUNT Fixed Amount
sffeld4 FIX_AMOUNT Fixed Amount
sffeld5 FIX_AMOUNT Fixed Amount
sffeld6 FIX_AMOUNT Fixed Amount
sffeld7 FIX_AMOUNT Fixed Amount
sffeld8 FIX_AMOUNT Fixed Amount
sffeld9 FIX_AMOUNT Fixed Amount
sffeld10 FIX_AMOUNT Fixed Amount
facurr FACUR Currency
rffeld1 FIX_AMOUNT Fixed Amount
rffeld2 FIX_AMOUNT Fixed Amount
rffeld3 FIX_AMOUNT Fixed Amount
rffeld4 FIX_AMOUNT Fixed Amount
rffeld5 FIX_AMOUNT Fixed Amount
rffeld6 FIX_AMOUNT Fixed Amount
rffeld7 FIX_AMOUNT Fixed Amount
rffeld8 FIX_AMOUNT Fixed Amount
rffeld9 FIX_AMOUNT Fixed Amount
rffeld10 FIX_AMOUNT Fixed Amount
scip SCFLAG Orig Plan/Act.
rcdata FIELDGROUP Field group
asacc ASACC Assess. CElem
pafldf RKE_FELDF Fixed value fld
pafldg RKE_FELDG Val.fld vbl cst
rrfeld1 KALC_RRFLD AcctAsgmntField
sortfield KALC_SORTF Sort Field
sender_not KALC_SNOR Exclude Sender
mrule KALC_MRULE MRULE
absch BRGABSCH Alloc.Structure
ersch ERSCH PA Trans. Str.
sweight_fact KALC_SWEIGHTF Factor Per
rweight_fact KALC_RWEIGHTF Factor Per

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.

-- Versioning Allocation Segments
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811SV (
    MANDT,         -- Client [MANDT]
    ID,            -- ID [SCHEDMAN_ID]
    TAB,           -- Table [DBNAM]
    CYCLE,         -- Cycle [CYCLE]
    SDATE,         -- Valid From [SDATE]
    SEQNR,         -- Segment number [SQNR]
    NAME,          -- Segment [SEQNAME]
    SEQPOS,        -- Item [SEQPOS]
    SRULE,         -- Sender Rule [SRULE]
    RRULE,         -- Receiver Rule [RRULE]
    ACTIVE,        -- Lock indicator [SEQBLK]
    NEGTEST,       -- Scale Neg. Factors [NEGTEST]
    SCSET,         -- Set ID [SETNR]
    SSET,          -- Set ID [SETNR]
    RSET,          -- Set ID [SETNR]
    RCSET,         -- Set ID [SETNR]
    SPERCENT,      -- Share in % [SNDPERCENT]
    SFFELD1,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD2,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD3,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD4,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD5,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD6,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD7,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD8,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD9,       -- Fixed Amount [FIX_AMOUNT]
    SFFELD10,      -- Fixed Amount [FIX_AMOUNT]
    FACURR,        -- Currency [FACUR]
    RFFELD1,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD2,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD3,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD4,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD5,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD6,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD7,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD8,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD9,       -- Fixed Amount [FIX_AMOUNT]
    RFFELD10,      -- Fixed Amount [FIX_AMOUNT]
    SCIP,          -- Orig Plan/Act. [SCFLAG]
    RCDATA,        -- Field group [FIELDGROUP]
    ASACC,         -- Assess. CElem [ASACC]
    PAFLDF,        -- Fixed value fld [RKE_FELDF]
    PAFLDG,        -- Val.fld vbl cst [RKE_FELDG]
    RRFELD1,       -- AcctAsgmntField [KALC_RRFLD]
    SORTFIELD,     -- Sort Field [KALC_SORTF]
    SENDER_NOT,    -- Exclude Sender [KALC_SNOR]
    MRULE,         -- MRULE [KALC_MRULE]
    ABSCH,         -- Alloc.Structure [BRGABSCH]
    ERSCH,         -- PA Trans. Str. [ERSCH]
    SWEIGHT_FACT,  -- Factor Per [KALC_SWEIGHTF]
    RWEIGHT_FACT,  -- Factor Per [KALC_RWEIGHTF]
    PRIMARY KEY (MANDT, ID, TAB, CYCLE, SDATE, SEQNR)
);