SAP Table T5F1P
Personnel Area/Subarea (FR)
T5F1P (Personnel Area/Subarea (FR)) 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 T5F1P to other SAP tables.
T5F1P 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 | |||||||||
| SIREN | SIREN number | SIREN | CHAR | 9 | 0 | |||||||||
| NUMIC | NIC | NUMIC | CHAR | 5 | 0 | |||||||||
| CDAPE | APE indicator (France) | CDAPE | CHAR | 4 | 0 | |||||||||
| URSNA | URSSAF - name of agency responsible | URSNA | CHAR | 25 | 0 | |||||||||
| URSSA | Number for URSSAF (France) | URSSA | CHAR | 18 | 0 | |||||||||
| ASSED | ASSEDIC Number | ASSED | CHAR | 15 | 0 | |||||||||
| MODSV | CC/PA Modifier for Social Insurance (France) | MODSV | NUMC | 2 | 0 | |||||||||
| TPART | Part-time activity code | TPART_D | CHAR | 1 | 0 |
Possible values
|
||||||||
| MOTDS | DADS-U Data Transfer (TDS) Modifier | P06_MOTDS | T5F1S | CHAR | 4 | 0 | ||||||||
| MOPAR | Profit sharing modifier | P06_MOPAR | T5F3B | CHAR | 2 | 0 | ||||||||
| MOMAL | Continued pay modifier - personnel area/subarea | P06_MOMAL | NUMC | 2 | 0 | |||||||||
| MOCRC | CRC modifier (supplementary pension fund) | P06_MOCRC | CHAR | 2 | 0 | |||||||||
| ASSNA | ASSEDIC - name of agency responsible | P06_ASSNA | CHAR | 25 | 0 | |||||||||
| IASSE | ASSEDIC Number | ASSED | CHAR | 15 | 0 | |||||||||
| DDTEF | Identification code for DDTEFP | P06_DDTEFP | T5F4E | CHAR | 4 | 0 | ||||||||
| MOCWB | EGroup modifier per area/subarea | P06_MOCWB | CHAR | 2 | 0 | |||||||||
| MOGAR | Garnishment modifier | P06_MOGAR | CHAR | 2 | 0 | |||||||||
| DOMDP | Electoral domain (PD elections) | P06_DOMDP | T5F4F | CHAR | 2 | 0 | ||||||||
| DOMCE | Electoral domain (WC elections) | P06_DOMCE | T5F4F | CHAR | 2 | 0 | ||||||||
| DOMPH | Domain for labor court elections | P06_DOMPH | T5F4F | CHAR | 2 | 0 | ||||||||
| CNACE | NACE Code (European Union) | P_99S_CNACE | CHAR | 5 | 0 | |||||||||
| REGIO | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
T5F1P foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5F1P | DDTEF | T5F1P | MANDT | T5F4E | DDTEFP | MANDT |
| T5F1P | DDTEF | T5F1P | DDTEF | T5F4E | DDTEFP | DDTEF |
| T5F1P | DOMCE | T5F1P | MANDT | T5F4F | Electoral domains | MANDT |
| T5F1P | DOMCE | 'CE' | T5F4F | Electoral domains | ELCTN | |
| T5F1P | DOMCE | T5F1P | DOMCE | T5F4F | Electoral domains | DOMEL |
| T5F1P | DOMCE | * | T5F4F | Electoral domains | ENDDA | |
| T5F1P | DOMDP | 'DP' | T5F4F | Electoral domains | ELCTN | |
| T5F1P | DOMDP | T5F1P | DOMDP | T5F4F | Electoral domains | DOMEL |
| T5F1P | DOMDP | * | T5F4F | Electoral domains | ENDDA | |
| T5F1P | DOMDP | T5F1P | MANDT | T5F4F | Electoral domains | MANDT |
| T5F1P | DOMPH | T5F1P | DOMPH | T5F4F | Electoral domains | DOMEL |
| T5F1P | DOMPH | * | T5F4F | Electoral domains | ENDDA | |
| T5F1P | DOMPH | T5F1P | MANDT | T5F4F | Electoral domains | MANDT |
| T5F1P | DOMPH | 'PH' | T5F4F | Electoral domains | ELCTN | |
| T5F1P | MANDT | T5F1P | MANDT | T000 | Clients | MANDT |
| T5F1P | MOPAR | T5F1P | MANDT | T5F3B | Calculation Bases for Profit Sharing | MANDT |
| T5F1P | MOPAR | T5F1P | MOPAR | T5F3B | Calculation Bases for Profit Sharing | MOPAR |
| T5F1P | MOPAR | * | T5F3B | Calculation Bases for Profit Sharing | AATTR | |
| T5F1P | MOPAR | * | T5F3B | Calculation Bases for Profit Sharing | ENDDA | |
| T5F1P | MOTDS | T5F1P | MANDT | T5F1S | HR-F: Social insurance data transfer information | MANDT |
| T5F1P | MOTDS | T5F1P | MOTDS | T5F1S | HR-F: Social insurance data transfer information | MOTDS |
| T5F1P | MOTDS | * | T5F1S | HR-F: Social insurance data transfer information | ENDDA | |
| T5F1P | REGIO | 'FR' | T005S | Taxes: Region (Province) Key | LAND1 | |
| T5F1P | REGIO | T5F1P | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| T5F1P | REGIO | T5F1P | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T5F1P | WERKS | T5F1P | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5F1P | WERKS | T5F1P | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5F1P | WERKS | T5F1P | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
