SAP table HRPY_WPBP (HR-PAY: Transparent Table WPBP)
SAP table HRPY_WPBP has 4 primary key fields being MANDT,PERNR,SEQNR,ENDDA.
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 | * | MANDT | |
| PERNR | Personnel Number | NUMC | 8 | 0 | P_PERNR | ||
| SEQNR | Sequence Number | NUMC | 5 | 0 | CDSEQ | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| MASSN | Action Type | CHAR | 2 | 0 | * | MASSN | |
| MASSG | Reason for Action | CHAR | 2 | 0 | * | MASSG | |
| STAT1 | Customer-Specific Status | CHAR | 1 | 0 | STAT1 | ||
| STAT2 | Employment Status | CHAR | 1 | 0 | STAT2 | ||
| STAT3 | Special Payment Status | CHAR | 1 | 0 | STAT3 | ||
| AKTIVJN | Indicator: Active | CHAR | 1 | 0 | AKTIVJN | ||
| BUKRS | Company Code | CHAR | 4 | 0 | * | BUKRS | |
| WERKS | Personnel Area | CHAR | 4 | 0 | * | PERSA | |
| BTRTL | Personnel Subarea | CHAR | 4 | 0 | * | BTRTL | |
| KOSTL | Cost Center | CHAR | 10 | 0 | * | KOSTL | |
| PERSG | Employee Group | CHAR | 1 | 0 | * | PERSG | |
| PERSK | Employee Subgroup | CHAR | 2 | 0 | * | PERSK | |
| ABART | Employee subgroup grouping for personnel calculation rule | CHAR | 1 | 0 | * | ABRAR | |
| PLANS | Position | NUMC | 8 | 0 | * | PLANS | |
| GSBER | Business Area | CHAR | 4 | 0 | * | GSBER | |
| VDSK1 | Organizational Key | CHAR | 14 | 0 | * | VDSK1 | |
| ANSVH | Work Contract | CHAR | 2 | 0 | * | ANSVH | |
| ORGEH | Organizational Unit | NUMC | 8 | 0 | * | ORGEH | |
| STELL | Job | NUMC | 8 | 0 | * | STELL | |
| ZTERF | Employee Time Management Status | NUMC | 1 | 0 | * | PT_ZTERF | |
| SCHKZ | Work Schedule Rule | CHAR | 8 | 0 | * | SCHKN | |
| EMPCT | Employment percentage | DEC | 5 | 2 | EMPCT | ||
| BSGRD | Capacity Utilization Level | DEC | 5 | 2 | BSGRD | ||
| TRFAR | Pay scale type | CHAR | 2 | 0 | * | TRFAR | |
| TRFGB | Pay Scale Area | CHAR | 2 | 0 | * | TRFGB | |
| TRFGR | Pay Scale Group | CHAR | 8 | 0 | * | TRFGR | |
| TRFST | Pay Scale Level | CHAR | 2 | 0 | * | TRFST | |
| KOSTVJN | Cost Distribution | CHAR | 1 | 0 | KOSTVJN | ||
| FISTL | Funds Center | CHAR | 16 | 0 | * | FISTL | |
| GEBER | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| FKBER | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| SGMNT | Segment for Segmental Reporting | CHAR | 10 | 0 | * | FB_SEGMENT | |
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD |