SAP table V_001P_ALL (Generated Table for View)
SAP table V_001P_ALL 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 | T500P | PERSA | |
| BTRTL | Personnel Subarea | CHAR | 4 | 0 | BTRTL_001P | ||
| NAME1 | Personnel Area Text | CHAR | 30 | 0 | PBTXT | ||
| BTEXT | Personnel Subarea Text | CHAR | 15 | 0 | BTRTX | ||
| MODIF | HCM Localization | CHAR | 2 | 0 | T500L | MOLGA | |
| MOURA | Personnel Subarea Grouping for Leave Types | NUMC | 2 | 0 | MOURA | ||
| TRFGB | Pay Scale Area | CHAR | 2 | 0 | T510G | TRFGB | |
| TRFAR | Pay scale type | CHAR | 2 | 0 | T510A | TRFAR | |
| MOABW | Personnel subarea grouping for absence and attendance types | NUMC | 2 | 0 | MOABW | ||
| MOABT | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| MOTAT | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| MOVER | Personnel Subarea Grpg for Substitution/Availability Types | NUMC | 2 | 0 | MOVER | ||
| URLKL | PS grouping for attendance and absence counting | CHAR | 2 | 0 | T554X | URLKL | |
| JUPER | Legal Person | CHAR | 4 | 0 | JUPER | ||
| MOBDE | Grouping of Personnel Subareas for Time Recording | NUMC | 2 | 0 | MOBDE | ||
| MOZKO | Grouping of Personnel Subareas for Time Quota Types | NUMC | 2 | 0 | MOZKO | ||
| MOPTB | Personnel subarea grouping for premiums | NUMC | 2 | 0 | MOPTB | ||
| WKTYP | Personnel Subarea for Primary Wage Type and Wage Maintenance | CHAR | 1 | 0 | WKTYP | ||
| MOSTA | Statistics Modifier | NUMC | 2 | 0 | MOSTA | ||
| MOBUR | Personnel Subarea Grouping for Appraisals | NUMC | 2 | 0 | MOBUR | ||
| MOFID | Public Holiday Calendar | CHAR | 2 | 0 | THOCI | HIDENT | |
| MOSID | Personnel Subarea Grouping for Work Schedules | NUMC | 2 | 0 | T508Z | MOSID | |
| MODSZ | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 |
V_001P_ALL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 V_001P_ALL | MANDT | T000 | Clients | MANDT |
| 1 V_001P_ALL | MODIF | T500L | Personnel Country Grouping | MOLGA |
| 0 V_001P_ALL | MOSID | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | MANDT |
| 0 V_001P_ALL | MOSID | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | MOSID |
| 1 V_001P_ALL | TRFAR | T510A | Pay Scale Types | MANDT |
| 1 V_001P_ALL | TRFAR | T510A | Pay Scale Types | MOLGA |
| 1 V_001P_ALL | TRFAR | T510A | Pay Scale Types | TRFAR |
| 0 V_001P_ALL | TRFGB | T510G | Pay Scale Areas | MANDT |
| 0 V_001P_ALL | TRFGB | T510G | Pay Scale Areas | MOLGA |
| 0 V_001P_ALL | TRFGB | T510G | Pay Scale Areas | TRFGB |
| 1 V_001P_ALL | URLKL | T554X | Rules for Attendance/Absence Counting and Leave Deduction | MANDT |
| 1 V_001P_ALL | URLKL | T554X | Rules for Attendance/Absence Counting and Leave Deduction | URLKL |
| 1 V_001P_ALL | URLKL | T554X | Rules for Attendance/Absence Counting and Leave Deduction | ZEITY |
| 1 V_001P_ALL | URLKL | T554X | Rules for Attendance/Absence Counting and Leave Deduction | SEQNO |
| 0 V_001P_ALL | WERKS | T500P | Personnel Areas | MANDT |
| 0 V_001P_ALL | WERKS | T500P | Personnel Areas | PERSA |