SAP table T5PPBS8A (Index value for pay scale area, group, level)

SAP table T5PPBS8A has 8 primary key fields being MANDT,TRFAR,TRFGB,TRFKZ,TRFGR,TRFST,LGART,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 T510 MANDT
TRFAR Pay scale type CHAR 2 0 T510 TRFAR
TRFGB Pay Scale Area CHAR 2 0 T510 TRFGB
TRFKZ ES grouping for collective agreement provision CHAR 1 0 T510 TRFKZ
TRFGR Pay Scale Group CHAR 8 0 T510 TRFGR
TRFST Pay Scale Level CHAR 2 0 T510 TRFST
LGART Wage Type CHAR 4 0 T510 LGART
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
IDXVALUE Index Value NUMC 8 0 PPTP_IDXVALUE

T5PPBS8A foreign key relationships

Table Field Check Table Check Field
0 T5PPBS8A LGART T510 Pay Scale Groups MANDT
0 T5PPBS8A LGART T510 Pay Scale Groups MOLGA
0 T5PPBS8A LGART T510 Pay Scale Groups TRFKZ
0 T5PPBS8A LGART T510 Pay Scale Groups TRFGR
0 T5PPBS8A LGART T510 Pay Scale Groups TRFST
0 T5PPBS8A LGART T510 Pay Scale Groups LGART
0 T5PPBS8A LGART T510 Pay Scale Groups ENDDA
1 T5PPBS8A MANDT T510 Pay Scale Groups MANDT
1 T5PPBS8A MANDT T510 Pay Scale Groups MOLGA
1 T5PPBS8A MANDT T510 Pay Scale Groups TRFKZ
1 T5PPBS8A MANDT T510 Pay Scale Groups TRFGR
1 T5PPBS8A MANDT T510 Pay Scale Groups TRFST
1 T5PPBS8A MANDT T510 Pay Scale Groups LGART
1 T5PPBS8A MANDT T510 Pay Scale Groups ENDDA
0 T5PPBS8A TRFAR T510 Pay Scale Groups MANDT
0 T5PPBS8A TRFAR T510 Pay Scale Groups MOLGA
0 T5PPBS8A TRFAR T510 Pay Scale Groups TRFKZ
0 T5PPBS8A TRFAR T510 Pay Scale Groups TRFGR
0 T5PPBS8A TRFAR T510 Pay Scale Groups TRFST
0 T5PPBS8A TRFAR T510 Pay Scale Groups LGART
0 T5PPBS8A TRFAR T510 Pay Scale Groups ENDDA
1 T5PPBS8A TRFGB T510 Pay Scale Groups MANDT
1 T5PPBS8A TRFGB T510 Pay Scale Groups MOLGA
1 T5PPBS8A TRFGB T510 Pay Scale Groups TRFKZ
1 T5PPBS8A TRFGB T510 Pay Scale Groups TRFGR
1 T5PPBS8A TRFGB T510 Pay Scale Groups TRFST
1 T5PPBS8A TRFGB T510 Pay Scale Groups LGART
1 T5PPBS8A TRFGB T510 Pay Scale Groups ENDDA
0 T5PPBS8A TRFGR T510 Pay Scale Groups MANDT
0 T5PPBS8A TRFGR T510 Pay Scale Groups MOLGA
0 T5PPBS8A TRFGR T510 Pay Scale Groups TRFKZ
0 T5PPBS8A TRFGR T510 Pay Scale Groups TRFGR
0 T5PPBS8A TRFGR T510 Pay Scale Groups TRFST
0 T5PPBS8A TRFGR T510 Pay Scale Groups LGART
0 T5PPBS8A TRFGR T510 Pay Scale Groups ENDDA
1 T5PPBS8A TRFKZ T510 Pay Scale Groups MANDT
1 T5PPBS8A TRFKZ T510 Pay Scale Groups MOLGA
1 T5PPBS8A TRFKZ T510 Pay Scale Groups TRFKZ
1 T5PPBS8A TRFKZ T510 Pay Scale Groups TRFGR
1 T5PPBS8A TRFKZ T510 Pay Scale Groups TRFST
1 T5PPBS8A TRFKZ T510 Pay Scale Groups LGART
1 T5PPBS8A TRFKZ T510 Pay Scale Groups ENDDA
0 T5PPBS8A TRFST T510 Pay Scale Groups MANDT
0 T5PPBS8A TRFST T510 Pay Scale Groups MOLGA
0 T5PPBS8A TRFST T510 Pay Scale Groups TRFKZ
0 T5PPBS8A TRFST T510 Pay Scale Groups TRFGR
0 T5PPBS8A TRFST T510 Pay Scale Groups TRFST
0 T5PPBS8A TRFST T510 Pay Scale Groups LGART
0 T5PPBS8A TRFST T510 Pay Scale Groups ENDDA