SAP Table T5E01
Personnel areas and subareas
T5E01 (Personnel areas and subareas) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5E01 to other SAP tables.
T5E01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| WERKS | Personnel Area | PERSA | T001P | CHAR | 4 | 0 | ||||||||||||||||
| BTRTL | Personnel Subarea | BTRTL_001P | CHAR | 4 | 0 | |||||||||||||||||
| NISSE | Company CA code | NISS1 | T5E08 | NUMC | 11 | 0 | ||||||||||||||||
| NISSC | Center identifier | NISSC | NUMC | 3 | 0 | |||||||||||||||||
| NIECO | Calculation of contributions | PES_CALCOT | CHAR | 3 | 0 |
Possible values
|
||||||||||||||||
| FINNR | Company NIF | FINNR | CHAR | 9 | 0 | |||||||||||||||||
| LDKNZ | Tax modifier | LDKNZ | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||
| COPSS | Local Social Insurance office | COPSS | T5E05 | CHAR | 6 | 0 | ||||||||||||||||
| COSOC | Healthcare company for IA/ID and NID | COSOC | T5E03 | CHAR | 3 | 0 | ||||||||||||||||
| MOCAT | Categories modifier | MOCAT | T5E8T | NUMC | 2 | 0 | ||||||||||||||||
| NISS2 | CA code for training contracts | NISS2 | NUMC | 11 | 0 | |||||||||||||||||
| NISS3 | CA code for foreigners | NISS3 | NUMC | 11 | 0 | |||||||||||||||||
| NISS4 | CA code for consultants and administrators | PES_NISS4 | NUMC | 11 | 0 | |||||||||||||||||
| GROUP_ID | Company group/grouping indentifier | PES_GRPID | T5E11 | CHAR | 4 | 0 | ||||||||||||||||
| PROVN | Province | PES_PROVN | T5E20 | CHAR | 3 | 0 | ||||||||||||||||
T5E01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5E01 | COPSS | * | T5E05 | Social Insurance branch offices | TIOSS | |
| T5E01 | COPSS | T5E01 | COPSS | T5E05 | Social Insurance branch offices | COPSS |
| T5E01 | COPSS | T5E01 | MANDT | T5E05 | Social Insurance branch offices | MANDT |
| T5E01 | COSOC | T5E01 | MANDT | T5E03 | IA/ID and NID healthcare companies | MANDT |
| T5E01 | COSOC | '1' | T5E03 | IA/ID and NID healthcare companies | INDIC | |
| T5E01 | COSOC | T5E01 | COSOC | T5E03 | IA/ID and NID healthcare companies | COSOC |
| T5E01 | GROUP_ID | T5E01 | GROUP_ID | T5E11 | Assignation of head office to corporate group | GROUP_ID |
| T5E01 | GROUP_ID | T5E01 | MANDT | T5E11 | Assignation of head office to corporate group | MANDT |
| T5E01 | MANDT | T5E01 | MANDT | T000 | Clients | MANDT |
| T5E01 | MOCAT | T5E01 | MOCAT | T5E8T | Modifiers for professional categories | MOCAT |
| T5E01 | MOCAT | T5E01 | MANDT | T5E8T | Modifiers for professional categories | MANDT |
| T5E01 | NISSE | T5E01 | MANDT | T5E08 | Time-dependent characteristics of CACs | MANDT |
| T5E01 | NISSE | T5E01 | NISSE | T5E08 | Time-dependent characteristics of CACs | NISSE |
| T5E01 | NISSE | * | T5E08 | Time-dependent characteristics of CACs | ENDDA | |
| T5E01 | PROVN | T5E01 | MANDT | T5E20 | Provinces | MANDT |
| T5E01 | PROVN | T5E01 | PROVN | T5E20 | Provinces | PROVN |
| T5E01 | PROVN | * | T5E20 | Provinces | ENDDA | |
| T5E01 | WERKS | T5E01 | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| T5E01 | WERKS | T5E01 | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5E01 | WERKS | T5E01 | WERKS | T001P | Personnel Area/Subarea | WERKS |
