SAP table PA0016 (HR Master Record: Infotype 0016 (Contract Elements))
SAP table PA0016 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.
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 | PA0003 | 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 | ||
| NBTGK | Sideline Job | CHAR | 1 | 0 | NBTGK | ||
| WTTKL | Competition Clause | CHAR | 1 | 0 | WTTKL | ||
| LFZFR | Period of Continued Pay (Number) | DEC | 3 | 0 | LFZFR | ||
| LFZZH | Period of Continued Pay (Unit) | CHAR | 3 | 0 | T538A | LFZZH | |
| LFZSO | Special Rule for Continued Pay | NUMC | 2 | 0 | LFZSR | ||
| KGZFR | Sick Pay Supplement Period (Number) | DEC | 3 | 0 | KGZFR | ||
| KGZZH | Sick Pay Supplement Period (Unit) | CHAR | 3 | 0 | T538A | KGZZH | |
| PRBZT | Probationary Period (Number) | DEC | 3 | 0 | PRBZT | ||
| PRBEH | Probationary Period (Unit) | CHAR | 3 | 0 | T538A | PRBEH | |
| KDGFR | Dismissals Notice Period for Employer | CHAR | 2 | 0 | T547T | KDGFR | |
| KDGF2 | Dismissals Notice Period for Employee | CHAR | 2 | 0 | T547T | KDGF2 | |
| ARBER | Expiration Date of Work Permit | DATS | 8 | 0 | ARBER | ||
| EINDT | Initial Entry | DATS | 8 | 0 | EINTR | ||
| KONDT | Date of Entry into Group | DATS | 8 | 0 | KONDT | ||
| KONSL | Group Key | CHAR | 2 | 0 | T545T | KOSL1 | |
| CTTYP | Contract Type | CHAR | 2 | 0 | T547V | CTTYP | |
| CTEDT | Contract End Date | DATS | 8 | 0 | CTEDT | ||
| PERSG | Employee Group | CHAR | 1 | 0 | T501 | PERSG | |
| PERSK | Employee Subgroup | CHAR | 2 | 0 | T503K | PERSK | |
| WRKPL | Work Location (Contract Elements Infotype) | CHAR | 40 | 0 | WRKPL | ||
| CTBEG | Contract Start | DATS | 8 | 0 | CTBEG | ||
| CTNUM | Contract number | CHAR | 20 | 0 | PCN_CTNUM | ||
| OBJNB | Object Number (France) | CHAR | 12 | 0 | OBJNB |
PA0016 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PA0016 | CTTYP | T547V | Contract Types | MANDT |
| 0 PA0016 | CTTYP | T547V | Contract Types | CTTYP |
| 1 PA0016 | KDGF2 | T547T | Periods of Notice | MANDT |
| 1 PA0016 | KDGF2 | T547T | Periods of Notice | SPRSL |
| 0 PA0016 | KDGFR | T547T | Periods of Notice | MANDT |
| 0 PA0016 | KDGFR | T547T | Periods of Notice | SPRSL |
| 1 PA0016 | KGZZH | T538A | HR Time/Measurement Units | MANDT |
| 1 PA0016 | KGZZH | T538A | HR Time/Measurement Units | ZEINH |
| 0 PA0016 | KONSL | T545T | Corporation Texts | MANDT |
| 0 PA0016 | KONSL | T545T | Corporation Texts | KOSL1 |
| 1 PA0016 | LFZZH | T538A | HR Time/Measurement Units | MANDT |
| 1 PA0016 | LFZZH | T538A | HR Time/Measurement Units | ZEINH |
| 0 PA0016 | MANDT | T000 | Clients | MANDT |
| 1 PA0016 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| 1 PA0016 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| 0 PA0016 | PERSG | T501 | Employee Group | MANDT |
| 0 PA0016 | PERSG | T501 | Employee Group | PERSG |
| 1 PA0016 | PERSK | T503K | Employee subgroup | MANDT |
| 1 PA0016 | PERSK | T503K | Employee subgroup | PERSK |
| 0 PA0016 | PRBEH | T538A | HR Time/Measurement Units | MANDT |
| 0 PA0016 | PRBEH | T538A | HR Time/Measurement Units | ZEINH |
| 1 PA0016 | PREAS | T530E | Reasons for Changes | MANDT |
| 1 PA0016 | PREAS | T530E | Reasons for Changes | INFTY |
| 1 PA0016 | PREAS | T530E | Reasons for Changes | PREAS |