SAP table PA0003 (HR Master Record: Infotype 0003 (Payroll Status))
SAP table PA0003 has 2 primary key fields being MANDT,PERNR.
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 | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERSNO | ||
| SUBTY | Subtype | CHAR | 4 | 0 | SUBTY | ||
| OBJPS | Object Identification | CHAR | 2 | 0 | OBJPS | ||
| SPRPS | Lock Indicator for HR Master Data Record | CHAR | 1 | 0 | SPRPS | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| SEQNR | Number of Infotype Record With Same Key | NUMC | 3 | 0 | SEQNR | ||
| AEDTM | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| UNAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| HISTO | Historical Record Flag | CHAR | 1 | 0 | HISTO | ||
| ITXEX | Text Exists for Infotype | CHAR | 1 | 0 | ITXEX | ||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | CHAR | 1 | 0 | PRFEX | ||
| ORDEX | Confirmation Fields Exist | CHAR | 1 | 0 | ORDEX | ||
| ITBLD | Infotype Screen Control | CHAR | 2 | 0 | ITBLD | ||
| PREAS | Reason for Changing Master Data | CHAR | 2 | 0 | T530E | PREAS | |
| FLAG1 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG2 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG3 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG4 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| RESE1 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| RESE2 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| GRPVL | Grouping Value for Personnel Assignments | CHAR | 4 | 0 | PCCE_GPVAL | ||
| ABRSP | Indicator: Personnel number locked for payroll | CHAR | 1 | 0 | ABRSP | ||
| ABRDT | Accounted to | DATS | 8 | 0 | LABRD | ||
| RRDAT | Earliest master data change since last payroll run | DATS | 8 | 0 | RRDAT | ||
| RRDAF | not in use | DATS | 8 | 0 | RRDAF | ||
| KOABR | Internal Use | CHAR | 1 | 0 | PAD_INTERN | ||
| PRDAT | Earliest personal retroactive accounting date | DATS | 8 | 0 | PRRDT | ||
| PKGAB | Date as of which personal calendar must be generated | DATS | 8 | 0 | PKGAB | ||
| ABWD1 | End of processing 1 (run payroll for pers.no. up to) | DATS | 8 | 0 | ABWD1 | ||
| ABWD2 | End of processing (do not run payroll for pers.no. after) | DATS | 8 | 0 | ABWD2 | ||
| BDERR | Recalculation date for PDC | DATS | 8 | 0 | BDERR | ||
| BDER1 | Effective recalculation date for PDC | DATS | 8 | 0 | BDER1 | ||
| KOBDE | PDC Error Indicator | CHAR | 1 | 0 | KOBDE | ||
| TIMRC | Date of initial PDC entry | CHAR | 1 | 0 | TIMRC | ||
| DAT00 | Initial input date for a personnel number | DATS | 8 | 0 | DATP0 | ||
| UHR00 | Time of initial input | TIMS | 6 | 0 | UHR00 | ||
| INUMK | Character field, 8 characters long | CHAR | 8 | 0 | CHAR8 | ||
| WERKS | Administrator Group | CHAR | 4 | 0 | SBMOD | ||
| SACHZ | Administrator for Time Recording | CHAR | 3 | 0 | SACHZ | ||
| SFELD | Sort field for infotype 0003 | CHAR | 20 | 0 | SFELD | ||
| ADRUN | HR: Special payroll run | CHAR | 1 | 0 | ADRUN | ||
| VIEKN | Infotype View Indicator | CHAR | 2 | 0 | VIEKN | ||
| TRVFL | Indicator for recorded trips | CHAR | 1 | 0 | TRVFL | ||
| RCBON | Earliest payroll-relevant master data change (bonus) | DATS | 8 | 0 | RCBON | ||
| PRTEV | Earliest personal recalculation date for time evaluation | DATS | 8 | 0 | PRTEV |
PA0003 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PA0003 | MANDT | T000 | Clients | MANDT |
| 1 PA0003 | PREAS | T530E | Reasons for Changes | MANDT |
| 1 PA0003 | PREAS | T530E | Reasons for Changes | INFTY |
| 1 PA0003 | PREAS | T530E | Reasons for Changes | PREAS |