T811SV
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AllocationSegmentVersion | view_entity | from | BASIC | Allocation Cycle Segment Version |
Fields (51)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA