SAP Table T5K0P
Personnel Area/Sub Area (Canada)
T5K0P (Personnel Area/Sub Area (Canada)) 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 T5K0P to other SAP tables.
Source: T5K0P (Personnel Area/Sub Area (Canada))
T5K0P 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 | T001P | CHAR | 4 | 0 | ||
| ORREG | Region | ORREG | CHAR | 3 | 0 | |||
| ORDIS | District | ORDIS | CHAR | 3 | 0 | |||
| EINUM | Employer identification | EINUM | CHAR | 11 | 0 | |||
| STCAN | STATS Canada number | STCAN | CHAR | 9 | 0 | |||
| DANDB | Dunn & Bradstreet Number | DANDB | CHAR | 9 | 0 | |||
| INDSC | Industry sector | INDSC | T5K0Q | CHAR | 2 | 0 | ||
| WCCLS | Workers' compensation class | WCCLS | CHAR | 4 | 0 | |||
| WCRGR | Workers' compensation contribution group | WCRGR | CHAR | 4 | 0 | |||
| WCERA | Workers' compensation account number | WCERA | CHAR | 9 | 0 | |||
| WCERF | Workers' compensation company number | WCERF | CHAR | 10 | 0 | |||
| MOBEN | Benefits Modifier | MOBEN | NUMC | 2 | 0 | |||
| MORET | Plan Modifier | MORET | NUMC | 2 | 0 | |||
| TXCMP | Tax area - Canada | CACMP | T5KTL | CHAR | 4 | 0 | ||
| SICNO | SIC_code - Standard industry sector code for EECRS only | PCA_SICNO | CHAR | 5 | 0 | |||
| NAICS | NAICS code | NAICS | T5UNC | CHAR | 10 | 0 | ||
| KNAICS | NAICS codes for Canada | KNAICS | T5KNC | CHAR | 4 | 0 | ||
T5K0P foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5K0P | BTRTL | T5K0P | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| T5K0P | BTRTL | T5K0P | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5K0P | BTRTL | T5K0P | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5K0P | INDSC | T5K0P | INDSC | T5K0Q | Industry Sector Texts | INDSC |
| T5K0P | INDSC | SYST | LANGU | T5K0Q | Industry Sector Texts | SPRSL |
| T5K0P | INDSC | T5K0P | MANDT | T5K0Q | Industry Sector Texts | MANDT |
| T5K0P | KNAICS | * | T5KNC | EECRS: North American Ind Classification Syst(NAICS) Codes | MOLGA | |
| T5K0P | KNAICS | T5K0P | KNAICS | T5KNC | EECRS: North American Ind Classification Syst(NAICS) Codes | NAICS |
| T5K0P | KNAICS | T5K0P | MANDT | T5KNC | EECRS: North American Ind Classification Syst(NAICS) Codes | MANDT |
| T5K0P | MANDT | T5K0P | MANDT | T000 | Clients | MANDT |
| T5K0P | NAICS | T5K0P | NAICS | T5UNC | North American Industry Classification System(NAICS) Codes | NAICS |
| T5K0P | NAICS | * | T5UNC | North American Industry Classification System(NAICS) Codes | MOLGA | |
| T5K0P | NAICS | T5K0P | MANDT | T5UNC | North American Industry Classification System(NAICS) Codes | MANDT |
| T5K0P | TXCMP | T5K0P | TXCMP | T5KTL | Tax area - Canada | TXCMP |
| T5K0P | TXCMP | T5K0P | MANDT | T5KTL | Tax area - Canada | MANDT |
| T5K0P | WERKS | T5K0P | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5K0P | WERKS | T5K0P | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5K0P | WERKS | T5K0P | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
