SAP table T5PS2 (HR-PT: Professional categories)

SAP table T5PS2 has 2 primary key fields being MANDT,PRCAT.

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
PRCAT Professional category CHAR 6 0 PPT_PRCTP
PRCNP Professional classification (CNP or CPP) CHAR 6 0 T5PP3 PPT_PRCNP
PRPAR Professional partitioning NUMC 1 0 PPT_PRPAR
1 Trainees/apprentices
2 Non-qualified professionals
3 Semi-qualified professionals
4 Qualified professionals
5 Intermediate management (inc.team leaders)
6 Middle management
7 Top management
8 Leaders
9 Highly qualified professionals
PRSIT Professional situation NUMC 1 0 PPT_PRSIT
1 Employer
2 Non-remunerated family member
3 Employed
4 Active member in Coop.(Production of Goods or Services)
8 Other
9 Other (obsolete value)
PRGRP Professional group NUMC 1 0 PPT_PRGRP
0 Others
1 Administrative, commercial and services personnel
2 Workers (industrial production, machine operator, etc.)
PRFUN Functional structure NUMC 1 0 T5PP5 PPT_PRFUN

T5PS2 foreign key relationships

Table Field Check Table Check Field
0 T5PS2 PRCNP T5PP3 HR-PT: Professional classification (CNP or CPP) PRCNP
1 T5PS2 PRFUN T5PP5 HR-PT: Functional Structure designation MANDT