SAP Table P0021
HR Master Record: Infotype 0021 (Family)
P0021 (HR Master Record: Infotype 0021 (Family)) 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 P0021 to other SAP tables.
Source: P0021 (HR Master Record: Infotype 0021 (Family))
P0021 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 | |||||||||
| FAMSA | Type of Family Record | FAMSA | CHAR | 4 | 0 | |||||||||
| FGBDT | Date of Birth | GBDAT | DATS | 8 | 0 | |||||||||
| FGBLD | Country of Birth | GBLND | T005 | CHAR | 3 | 0 | ||||||||
| FANAT | Nationality | NATSL | T005 | CHAR | 3 | 0 | ||||||||
| FASEX | Gender Key | GESCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| FAVOR | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||
| FANAM | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||
| FGBOT | Birthplace | PAD_GBORT | CHAR | 40 | 0 | |||||||||
| FGDEP | State | GBDEP | T005S | CHAR | 3 | 0 | ||||||||
| ERBNR | Reference Personnel Number for Family Member | ERBNR | CHAR | 12 | 0 | |||||||||
| FGBNA | Name at Birth | PAD_NAME2 | CHAR | 40 | 0 | |||||||||
| FNAC2 | Second Name | PAD_NACH2 | CHAR | 40 | 0 | |||||||||
| FCNAM | Complete Name | PAD_CNAME | CHAR | 80 | 0 | |||||||||
| FKNZN | Name Format Indicator for Employee in a List | KNZNM | NUMC | 2 | 0 | |||||||||
| FINIT | Initials | INITS | CHAR | 10 | 0 | |||||||||
| FVRSW | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
| FVRS2 | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
| FNMZU | Other Title | NAMZU | T535N | CHAR | 15 | 0 | ||||||||
| AHVNR | AHV Number | AHVNR | CHAR | 11 | 0 | |||||||||
| KDSVH | Relationship to Child | KDSVH | T577 | CHAR | 2 | 0 | ||||||||
| KDBSL | Allowance Authorization | KDBSL | T577 | CHAR | 2 | 0 | ||||||||
| KDUTB | Address of Child | KDUTB | T577 | CHAR | 2 | 0 | ||||||||
| KDGBR | Child Allowance Entitlement | KDGBR | T577 | CHAR | 2 | 0 | ||||||||
| KDART | Child Type | KDART | T577 | CHAR | 2 | 0 | ||||||||
| KDZUG | Child Bonuses | KDZUG | T577 | CHAR | 2 | 0 | ||||||||
| KDZUL | Child Allowances | KDZUL | T577 | CHAR | 2 | 0 | ||||||||
| KDVBE | Sickness Certificate Authorization | KDVBE | T577 | CHAR | 2 | 0 | ||||||||
| ERMNR | Authority Number | ERMNR | CHAR | 8 | 0 | |||||||||
| AUSVL | 1st Part of SI Number (Sequential Number) | AUSVL | NUMC | 4 | 0 | |||||||||
| AUSVG | 2nd Part of SI Number (Birth Date) | AUSVG | NUMC | 8 | 0 | |||||||||
| FASDT | End of Family Member's Education/Training | FASDT | DATS | 8 | 0 | |||||||||
| FASAR | School Type of Family Member | FASAR | T517T | CHAR | 2 | 0 | ||||||||
| FASIN | Educational Institute | FASIN | CHAR | 20 | 0 | |||||||||
| EGAGA | Employer of Family Member | EGAGA | CHAR | 8 | 0 | |||||||||
| FANA2 | Second Nationality | NATS2 | T005 | CHAR | 3 | 0 | ||||||||
| FANA3 | Third Nationality | NATS3 | T005 | CHAR | 3 | 0 | ||||||||
| BETRG | Amount | BETRG | CURR | 9 | 2 | |||||||||
| TITEL | Title | TITEL | T535N | CHAR | 15 | 0 | ||||||||
| EMRGN | Emergency Contact | PAD_EMRGN | CHAR | 1 | 0 |
Possible values
|
||||||||
P0021 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P0021 | FANA2 | SYST | MANDT | T005 | Countries | MANDT |
| P0021 | FANA2 | P0021 | FANA2 | T005 | Countries | LAND1 |
| P0021 | FANA3 | SYST | MANDT | T005 | Countries | MANDT |
| P0021 | FANA3 | P0021 | FANA3 | T005 | Countries | LAND1 |
| P0021 | FANAT | P0021 | FANAT | T005 | Countries | LAND1 |
| P0021 | FANAT | SYST | MANDT | T005 | Countries | MANDT |
| P0021 | FASAR | P0021 | FASAR | T517T | Educational Establishment Type Designations | SLART |
| P0021 | FASAR | SYST | LANGU | T517T | Educational Establishment Type Designations | SPRSL |
| P0021 | FASAR | SYST | MANDT | T517T | Educational Establishment Type Designations | MANDT |
| P0021 | FGBLD | P0021 | FGBLD | T005 | Countries | LAND1 |
| P0021 | FGBLD | SYST | MANDT | T005 | Countries | MANDT |
| P0021 | FGDEP | P0021 | FGDEP | T005S | Taxes: Region (Province) Key | BLAND |
| P0021 | FGDEP | P0021 | FGBLD | T005S | Taxes: Region (Province) Key | LAND1 |
| P0021 | FGDEP | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| P0021 | FNMZU | 'Z' | T535N | Name affixes | ART | |
| P0021 | FNMZU | SYST | MANDT | T535N | Name affixes | MANDT |
| P0021 | FNMZU | P0021 | FNMZU | T535N | Name affixes | TITEL |
| P0021 | FVRS2 | 'V' | T535N | Name affixes | ART | |
| P0021 | FVRS2 | SYST | MANDT | T535N | Name affixes | MANDT |
| P0021 | FVRS2 | P0021 | FVRS2 | T535N | Name affixes | TITEL |
| P0021 | FVRSW | P0021 | FVRSW | T535N | Name affixes | TITEL |
| P0021 | FVRSW | 'V' | T535N | Name affixes | ART | |
| P0021 | FVRSW | SYST | MANDT | T535N | Name affixes | MANDT |
| P0021 | INFTY | P0021 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P0021 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P0021 | KDART | '1' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDART | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDART | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDART | P0021 | KDART | T577 | Family Characteristics | AUSPR |
| P0021 | KDBSL | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDBSL | P0021 | KDBSL | T577 | Family Characteristics | AUSPR |
| P0021 | KDBSL | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDBSL | '2' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDGBR | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDGBR | P0021 | KDGBR | T577 | Family Characteristics | AUSPR |
| P0021 | KDGBR | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDGBR | '4' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDSVH | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDSVH | P0021 | KDSVH | T577 | Family Characteristics | AUSPR |
| P0021 | KDSVH | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDSVH | '1' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDUTB | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDUTB | P0021 | KDUTB | T577 | Family Characteristics | AUSPR |
| P0021 | KDUTB | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDUTB | '3' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDVBE | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDVBE | P0021 | KDVBE | T577 | Family Characteristics | AUSPR |
| P0021 | KDVBE | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDVBE | '6' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDZUG | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDZUG | P0021 | KDZUG | T577 | Family Characteristics | AUSPR |
| P0021 | KDZUG | '4' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDZUG | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDZUL | SYST | MANDT | T577 | Family Characteristics | MANDT |
| P0021 | KDZUL | T001P | MOLGA | T577 | Family Characteristics | MOLGA |
| P0021 | KDZUL | '5' | T577 | Family Characteristics | EIGSH | |
| P0021 | KDZUL | P0021 | KDZUL | T577 | Family Characteristics | AUSPR |
| P0021 | PREAS | P0021 | PREAS | T530E | Reasons for Changes | PREAS |
| P0021 | PREAS | P0021 | INFTY | T530E | Reasons for Changes | INFTY |
| P0021 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| P0021 | TITEL | P0021 | TITEL | T535N | Name affixes | TITEL |
| P0021 | TITEL | 'T' | T535N | Name affixes | ART | |
| P0021 | TITEL | SYST | MANDT | T535N | Name affixes | MANDT |
