SAP table T5E01 (Personnel areas and subareas)

SAP table T5E01 has 3 primary key fields being MANDT,WERKS,BTRTL.

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
WERKS Personnel Area CHAR 4 0 T001P PERSA
BTRTL Personnel Subarea CHAR 4 0 * BTRTL_001P
NISSE Company CA code NUMC 11 0 T5E08 NISS1
NISSC Center identifier NUMC 3 0 NISSC
NIECO Calculation of contributions CHAR 3 0 PES_CALCOT
M01 Marine employee category (group I)
FINNR Company NIF CHAR 9 0 FINNR
LDKNZ Tax modifier NUMC 2 0 LDKNZ
COPSS Local Social Insurance office CHAR 6 0 T5E05 COPSS
COSOC Healthcare company for IA/ID and NID CHAR 3 0 T5E03 COSOC
MOCAT Categories modifier NUMC 2 0 T5E8T MOCAT
NISS2 CA code for training contracts NUMC 11 0 NISS2
NISS3 CA code for foreigners NUMC 11 0 NISS3
NISS4 CA code for consultants and administrators NUMC 11 0 PES_NISS4
GROUP_ID Company group/grouping indentifier CHAR 4 0 T5E11 PES_GRPID
PROVN Province CHAR 3 0 T5E20 PES_PROVN

T5E01 foreign key relationships

Table Field Check Table Check Field
0 T5E01 COPSS T5E05 Social Insurance branch offices MANDT
0 T5E01 COPSS T5E05 Social Insurance branch offices COPSS
1 T5E01 COSOC T5E03 IA/ID and NID healthcare companies MANDT
1 T5E01 COSOC T5E03 IA/ID and NID healthcare companies INDIC
0 T5E01 GROUP_ID T5E11 Assignation of head office to corporate group MANDT
0 T5E01 GROUP_ID T5E11 Assignation of head office to corporate group GROUP_ID
1 T5E01 MOCAT T5E8T Modifiers for professional categories MANDT
1 T5E01 MOCAT T5E8T Modifiers for professional categories MOCAT
0 T5E01 NISSE T5E08 Time-dependent characteristics of CACs MANDT
0 T5E01 NISSE T5E08 Time-dependent characteristics of CACs ENDDA
1 T5E01 PROVN T5E20 Provinces MANDT
1 T5E01 PROVN T5E20 Provinces PROVN
1 T5E01 PROVN T5E20 Provinces ENDDA
0 T5E01 WERKS T001P Personnel Area/Subarea MANDT
0 T5E01 WERKS T001P Personnel Area/Subarea WERKS
0 T5E01 WERKS T001P Personnel Area/Subarea BTRTL