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