SAP table T811S (Allocations: Segments)

SAP table T811S has 5 primary key fields being MANDT,TAB,CYCLE,SDATE,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TAB Table Name CHAR 30 0 DBNAM
CYCLE Allocation/cycle CHAR 10 0 CYCLE
SDATE Start Date DATS 8 0 T811C SDATE
SEQNR Segment number within a cycle NUMC 4 0 SQNR
NAME Name of a Segment in Assessment/Distribution CHAR 10 0 SEQNAME
SEQPOS Item of Segment in Cycle NUMC 4 0 SEQPOS
SRULE Assessment/Distribution Rule Sender CHAR 1 0 SRULE
1 Posted amounts
2 Fixed amounts
3 Fixed rates
RRULE Assessment/Distribution Rule Receiver CHAR 1 0 RRULE
1 Variable portions
2 Fixed amounts
3 Fixed percentages
4 Fixed portions
ACTIVE Indicator: Segment Locked CHAR 1 0 SEQBLK
NEGTEST Indicator: Scale Negative Tracing Factors NUMC 1 0 NEGTEST
1 No Normalization
2 Standard scaling
3 Absolute Value (Negative to Positive)
4 Negative Tracing Factors to Zero
5 Smallest negative tracing factor to zero
6 Smallest negative tracing factor to zero, but zero = zero
SCSET Set ID CHAR 12 0 SETNR
SSET Set ID CHAR 12 0 SETNR
RSET Set ID CHAR 12 0 SETNR
RCSET Set ID CHAR 12 0 SETNR
SPERCENT Sender Percentage DEC 5 2 SNDPERCENT
SFFELD1 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD2 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD3 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD4 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD5 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD6 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD7 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD8 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD9 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SFFELD10 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
FACURR Currency Key Allocations CUKY 5 0 TCURC FACUR
RFFELD1 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD2 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD3 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD4 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD5 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD6 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD7 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD8 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD9 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
RFFELD10 Fixed Amount Field CHAR 30 0 FIX_AMOUNT
SCIP Origin Plan/Actual CHAR 1 0 SCFLAG
RCDATA Data Field Definition CHAR 30 0 FVALUEAL30C
ASACC Assessment Cost Element CHAR 10 0 ASACC
PAFLDF Value field name for fixed cost center costs CHAR 30 0 RKE_FELDF
PAFLDG Value field for variable cost-center costs CHAR 30 0 RKE_FELDG
RRFELD1 Account Assignment Field CHAR 30 0 KALC_RRFLD
SORTFIELD Segment Sort Field CHAR 10 0 KALC_SORTF
SENDER_NOT Exclude Sender as Receiver CHAR 1 0 KALC_SNOR
MRULE Allocation: Manipulation Rule for Cyclical Maintenance CHAR 4 0 KALC_MRULE
ABSCH Allocation Structure for Settlement/Assessment CHAR 6 0 BRGABSCH
ERSCH PA Transfer Structure CHAR 2 0 ERSCH
SWEIGHT_FACT Decimal Places Factor for Sender Weighting Factors NUMC 7 0 KALC_SWEIGHTF
RWEIGHT_FACT Decimal Places Factor of the Receiver Weighting Factors NUMC 7 0 KALC_RWEIGHTF

T811S foreign key relationships

Table Field Check Table Check Field
0 T811S FACURR TCURC Currency Codes MANDT
0 T811S FACURR TCURC Currency Codes WAERS
1 T811S SDATE T811C Allocations: Cycles MANDT
1 T811S SDATE T811C Allocations: Cycles TAB
1 T811S SDATE T811C Allocations: Cycles CYCLE