SAP table T5BPBS01 (Description of pay scale rules)

SAP table T5BPBS01 has 7 primary key fields being MANDT,MOLGA,TRFAR,TRFGB,TRFKZ,TRFGR,ENDDA.

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
MOLGA HCM Localization CHAR 2 0 T500L MOLGA
TRFAR Pay scale type CHAR 2 0 T510A TRFAR
TRFGB Pay Scale Area CHAR 2 0 T510G TRFGB
TRFKZ ES grouping for collective agreement provision CHAR 1 0 TRFKZ
TRFGR Pay Scale Group CHAR 8 0 * TRFGR
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PSLEV Level of Belgian Public Sector pay scale CHAR 2 0 P12P_LEVEL
A Level A / Level 1
B Level B / Level 2+
C Level C / Level 2
D Level D / Level 3
E Level E / Level 4
RANK Rank of Belgian Public Sector Payscale CHAR 4 0 T5BPBS03 P12P_RANK
MINAG Minimum age to start seniority computing NUMC 2 0 P12P_MINAG
BETRG Wage Type Amount for Payments CURR 13 2 PAD_AMT7S
BASIS Index Basis DEC 6 3 P12P_BASIS

T5BPBS01 foreign key relationships

Table Field Check Table Check Field
0 T5BPBS01 MOLGA T500L Personnel Country Grouping MOLGA
1 T5BPBS01 RANK T5BPBS03 Check-table for Domain P12P_RANK MANDT
1 T5BPBS01 RANK T5BPBS03 Check-table for Domain P12P_RANK RANK
0 T5BPBS01 TRFAR T510A Pay Scale Types MANDT
0 T5BPBS01 TRFAR T510A Pay Scale Types MOLGA
0 T5BPBS01 TRFAR T510A Pay Scale Types TRFAR
1 T5BPBS01 TRFGB T510G Pay Scale Areas MANDT
1 T5BPBS01 TRFGB T510G Pay Scale Areas MOLGA
1 T5BPBS01 TRFGB T510G Pay Scale Areas TRFGB