SAP Table P0022
HR Master Record: Infotype 0022 (Education)
P0022 (HR Master Record: Infotype 0022 (Education)) 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 P0022 to other SAP tables.
P0022 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
| INFTY | Infotype | INFTY | T582A | CHAR | 4 | 0 | ||||||
| SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||
| PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||
| SLART | Educational establishment | SLART | T517T | CHAR | 2 | 0 | ||||||
| INSTI | Institute/location of training | INSTI | CHAR | 80 | 0 | |||||||
| SLAND | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| AUSBI | Education/training | AUSBI | T518A | NUMC | 8 | 0 | ||||||
| SLABS | Certificate | SLABS | T519T | CHAR | 2 | 0 | ||||||
| ANZKL | Duration of training course | ANZKL | DEC | 3 | 0 | |||||||
| ANZEH | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| SLTP1 | Branch of study | FACH1 | T517Y | NUMC | 5 | 0 | ||||||
| SLTP2 | Branch of study | FACH2 | T517Y | NUMC | 5 | 0 | ||||||
| JBEZ1 | Course fees | KSGEB | CURR | 11 | 2 | |||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| SLPLN | Planned course (unused) | KSPLN | CHAR | 1 | 0 |
Possible values
|
||||||
| SLKTR | Cost object (unused) | SLKTR | CHAR | 2 | 0 | |||||||
| SLRZG | Repayment obligation | SLRZG | CHAR | 1 | 0 |
Possible values
|
||||||
| KSBEZ | Course name | KSBEZ | CHAR | 25 | 0 | |||||||
| TX122 | Course appraisal | KSBUR | CHAR | 40 | 0 | |||||||
| SCHCD | Institute/school code | P22J_SCHCD | NUMC | 10 | 0 | |||||||
| FACCD | Faculty code | P22J_FACCD | NUMC | 3 | 0 | |||||||
| DPTMT | Department | DPTMT | CHAR | 40 | 0 | |||||||
| EMARK | Final Grade | EMARK | CHAR | 4 | 0 | |||||||
P0022 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P0022 | ANZEH | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| P0022 | ANZEH | P0022 | ANZEH | T538A | HR Time/Measurement Units | ZEINH |
| P0022 | AUSBI | SYST | MANDT | T518A | Vocation Check Table | MANDT |
| P0022 | AUSBI | P0022 | AUSBI | T518A | Vocation Check Table | AUSBI |
| P0022 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P0022 | INFTY | P0022 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P0022 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| P0022 | PREAS | P0022 | INFTY | T530E | Reasons for Changes | INFTY |
| P0022 | PREAS | P0022 | PREAS | T530E | Reasons for Changes | PREAS |
| P0022 | SLABS | SYST | MANDT | T519T | Final Certificates | MANDT |
| P0022 | SLABS | SYST | LANGU | T519T | Final Certificates | SPRSL |
| P0022 | SLABS | P0022 | SLABS | T519T | Final Certificates | SLABS |
| P0022 | SLAND | SYST | MANDT | T005 | Countries | MANDT |
| P0022 | SLAND | P0022 | SLAND | T005 | Countries | LAND1 |
| P0022 | SLART | SYST | LANGU | T517T | Educational Establishment Type Designations | SPRSL |
| P0022 | SLART | P0022 | SLART | T517T | Educational Establishment Type Designations | SLART |
| P0022 | SLART | SYST | MANDT | T517T | Educational Establishment Type Designations | MANDT |
| P0022 | SLTP1 | SYST | MANDT | T517Y | Specialty validation table | MANDT |
| P0022 | SLTP1 | P0022 | SLTP1 | T517Y | Specialty validation table | FACHR |
| P0022 | SLTP2 | P0022 | SLTP2 | T517Y | Specialty validation table | FACHR |
| P0022 | SLTP2 | SYST | MANDT | T517Y | Specialty validation table | MANDT |
| P0022 | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
| P0022 | WAERS | P0022 | WAERS | TCURC | Currency Codes | WAERS |
