SAP Table KGALS

Record layout for alloc. segments

KGALS (Record layout for alloc. segments) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KGALS to other SAP tables.

KGALS table fields

Field Data element Checktable Datatype Length Decimals
SEQNR Segment number within a cycle SQNR T811S NUMC 4 0
NAME Name of a segment in assessment/distribution SEQNAME CHAR 10 0
SEQPOS Item of segment in cycle SEQPOS NUMC 4 0
TXT Text for a segment (assessment/distribution) SEQTXT CHAR 30 0
SRULE Assessment/distribution rule sender SRULE CHAR 1 0
1 Posted amounts
2 Fixed amounts
3 Fixed rates
RRULE Assessment/Distribution Rule Receiver RRULE CHAR 1 0
1 Variable portions
2 Fixed amounts
3 Fixed percentages
4 Fixed portions
ACTIVE Indicator: Segment Locked SEQBLK CHAR 1 0
X Yes
NULL No
NEGTEST Indicator: Scale Negative Tracing Factors NEGTEST NUMC 1 0
1 No scaling
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 SETNR CHAR 12 0
SSET Set ID SETNR CHAR 12 0
RSET Set ID SETNR CHAR 12 0
RCSET Set ID SETNR CHAR 12 0
SPERCENT Sender percentage SNDPERCENT DEC 5 2
00000
FACURR Currency Key RTCUR TCURC CUKY 5 0
SCIP Origin plan/actual SCFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RCDATA Field group FIELDGROUP CHAR 30 0
ASACC Assessment Cost Element ASACC CHAR 10 0
PAFLDF Value field name for fixed cost center costs RKE_FELDF CHAR 30 0
PAFLDG Value field for variable cost-center costs RKE_FELDG CHAR 30 0
PATXTF Medium Field Label SCRTEXT_M CHAR 20 0
PATXTG Medium Field Label SCRTEXT_M CHAR 20 0
SCIST Sender Value Origin: Actual Values KALC_SCIST CHAR 1 0
X true
- false
NULL unknown
SCPLAN Sender Value Origin: Plan Values KALC_SCPLN CHAR 1 0
X true
- false
NULL unknown
SRULE_RLV Sender rule for indirect activity allocation SRULE_RLV CHAR 1 0
1 Posted quantities
2 Fixed quantities
3 Quantities calculated inversely
RRULE_RLV Receiver rule for indirect activity allocation RRULE_RLV CHAR 1 0
1 Variable portions
2 Fixed quantities
3 Fixed percentages
4 Fixed portions
SDVAL_DET Boolean Variable (X=True, -=False, Space=Unknown) BOOLEAN CHAR 1 0
X true
- false
NULL unknown
SORTFIELD Segment Sort Field KALC_SORTF CHAR 10 0
SENDER_NOT Exclude Sender as Receiver KALC_SNOR CHAR 1 0
X true
- false
NULL unknown
MRULE Allocation: Manipulation Rule for Cyclical Maintenance KALC_MRULE CHAR 4 0
ABSCH Allocation Structure for Settlement/Assessment BRGABSCH TKB5A CHAR 2 0
ERSCH PA transfer structure ERSCH TKB9A CHAR 2 0
SWEIGHT_FACT Decimal Places Factor for Sender Weighting Factors KALC_SWEIGHTF NUMC 7 0
0000001 No decimal places
0000010 One decimal place
0000100 Two decimal places
0001000 Three decimal places
0010000 Four decimal places
0100000 Five decimal places
1000000 Six decimal places
RWEIGHT_FACT Decimal Places Factor of the Receiver Weighting Factors KALC_RWEIGHTF NUMC 7 0
0000001 No decimal places
0000010 One decimal place
0000100 Two decimal places
0001000 Three decimal places
0010000 Four decimal places
0100000 Five decimal places
1000000 Six decimal places

KGALS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KGALS ABSCH KGALS ABSCH TKB5A Allocation structure ABSCH
KGALS ABSCH * TKB5A Allocation structure MANDT
KGALS ERSCH * TKB9A Assignment Structure for Settlement to Profitability Anysis MANDT
KGALS ERSCH KGALS ERSCH TKB9A Assignment Structure for Settlement to Profitability Anysis ERSCH
KGALS FACURR SY MANDT TCURC Currency Codes MANDT
KGALS FACURR KGALS FACURR TCURC Currency Codes WAERS
KGALS SEQNR T811C SDATE T811S Allocations: Segments SDATE
KGALS SEQNR KGALS SEQNR T811S Allocations: Segments SEQNR
KGALS SEQNR SYST MANDT T811S Allocations: Segments MANDT
KGALS SEQNR T811C TAB T811S Allocations: Segments TAB
KGALS SEQNR T811C CYCLE T811S Allocations: Segments CYCLE