SAP table T5PS1 (HR-PT: professional categories assignment (IRC code))

SAP table T5PS1 has 7 primary key fields being MANDT,TRFAR,TRFGB,TRFKZ,TRFGR,TRFST,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
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
TRFST Pay Scale Level CHAR 2 0 T510 TRFST
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PRCAT Professional category CHAR 6 0 T5PS2 PPT_PRCTP
PRCOD Professional category IRC code NUMC 5 0 T5PS4 PPT_PRCOD
PRDGR Grade NUMC 2 0 PPT_PRDGR
01 Degree I
02 Degree II
03 Degree III
04 Degree IV

T5PS1 foreign key relationships

Table Field Check Table Check Field
0 T5PS1 PRCAT T5PS2 HR-PT: Professional categories MANDT
0 T5PS1 PRCAT T5PS2 HR-PT: Professional categories PRCAT
1 T5PS1 PRCOD T5PS4 HR-PT: Professional Category designation MANDT
1 T5PS1 PRCOD T5PS4 HR-PT: Professional Category designation ENDDA
0 T5PS1 TRFAR T510A Pay Scale Types MANDT
0 T5PS1 TRFAR T510A Pay Scale Types MOLGA
0 T5PS1 TRFAR T510A Pay Scale Types TRFAR
1 T5PS1 TRFGB T510G Pay Scale Areas MANDT
1 T5PS1 TRFGB T510G Pay Scale Areas MOLGA
1 T5PS1 TRFGB T510G Pay Scale Areas TRFGB
0 T5PS1 TRFST T510 Pay Scale Groups MANDT
0 T5PS1 TRFST T510 Pay Scale Groups MOLGA
0 T5PS1 TRFST T510 Pay Scale Groups TRFKZ
0 T5PS1 TRFST T510 Pay Scale Groups TRFGR
0 T5PS1 TRFST T510 Pay Scale Groups TRFST
0 T5PS1 TRFST T510 Pay Scale Groups LGART
0 T5PS1 TRFST T510 Pay Scale Groups ENDDA