SAP Table BAPIHR0002
HR: HR Master Record Infotype 0002 (Personal Data)
BAPIHR0002 (HR: HR Master Record Infotype 0002 (Personal Data)) 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 BAPIHR0002 to other SAP tables.
BAPIHR0002 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OBJ_ID | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||
| INFOTYPE | Infotype | INFTY | T582A | CHAR | 4 | 0 | ||||||||
| SUBTYPE | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||
| OBJECT_IDENTIFICATION | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||
| LOCKINDIC | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||
| TO_DATE | End Date | ENDDA | DATS | 8 | 0 | |||||||||
| FROM_DATE | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
| IT_REC_NO | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
| CHANGED_ON | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
| CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| HIST_FLAG | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
| INFOTYPE_TEXT_EXISTS | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| REFERENCE_FILEDS_EXIST | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| CONFIRMATION_FIELDS_EXIST | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| INFOTYPE_SCREEN_CONTROL | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||
| REASON_TO_CHANGE_MASTER_DATA | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||
| FLAG_1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG_2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG_3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG_4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| RESERVED_FIELD_1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| RESERVED_FIELD_2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| EMPLOYEE_INITIALS | Initials | INITS | CHAR | 10 | 0 | |||||||||
| LAST_NAME | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||
| NAME_AT_BIRTH | Name at Birth | PAD_NAME2 | CHAR | 40 | 0 | |||||||||
| SECOND_NAME | Second Name | PAD_NACH2 | CHAR | 40 | 0 | |||||||||
| FIRST_NAME | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||
| FULL_EMPLOYEE_NAME | Complete Name | PAD_CNAME | CHAR | 80 | 0 | |||||||||
| TITLE | Title | TITEL | T535N | CHAR | 15 | 0 | ||||||||
| SECOND_TITLE | Second Title | TITL2 | T535N | CHAR | 15 | 0 | ||||||||
| ARISTOCRATIC_TITLE | Other Title | NAMZU | T535N | CHAR | 15 | 0 | ||||||||
| NAME_AFFIX | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
| SECOND_NAME_PREFIX | Second Name Prefix | VORS2 | T535N | CHAR | 15 | 0 | ||||||||
| KNOWN_AS | Nickname | PAD_RUFNM | CHAR | 40 | 0 | |||||||||
| MIDDLE_NAME | Middle Name | PAD_MIDNM | CHAR | 40 | 0 | |||||||||
| NAME_FORMAT_INDICATOR | Name Format Indicator for Employee in a List | KNZNM | NUMC | 2 | 0 | |||||||||
| FORM_OF_ADDRESS_KEY | Form-of-Address Key | ANRDE | T522G | CHAR | 1 | 0 | ||||||||
| GENDER_KEY | Gender Key | GESCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| DATE_BIRTH | Date of Birth | GBDAT | DATS | 8 | 0 | |||||||||
| COUNTRY_OF_BIRTH | Country of Birth | GBLND | T005 | CHAR | 3 | 0 | ||||||||
| COUNTRY_OF_BIRTH_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| STATE | State | GBDEP | T005S | CHAR | 3 | 0 | ||||||||
| BIRTHPLACE | Birthplace | PAD_GBORT | CHAR | 40 | 0 | |||||||||
| NATIONALITY | Nationality | NATSL | T005 | CHAR | 3 | 0 | ||||||||
| NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| SECOND_NATIONALITY | Second Nationality | NATS2 | T005 | CHAR | 3 | 0 | ||||||||
| SECOND_NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| THIRD_NATIONALITY | Third Nationality | NATS3 | T005 | CHAR | 3 | 0 | ||||||||
| THIRD_NATIONALITY_ISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | 0 | |||||||||
| RELIGIOUS_DENOMINATION | Religious Denomination Key | KONFE | T516T | CHAR | 2 | 0 | ||||||||
| MARITAL_STATUS | Marital Status Key | FAMST | T502T | CHAR | 1 | 0 | ||||||||
| START_DATE_OF_MARITAL_STATUS | Valid From Date of Current Marital Status | FAMDT | DATS | 8 | 0 | |||||||||
| NUMBER_OF_CHILDREN | Number of Children | ANZKD | DEC | 3 | 0 | |||||||||
| NAME_CONNECTION | Name Connection | NACON | CHAR | 1 | 0 | |||||||||
| MODIFIER_FOR_PERSONNEL_ID | Modifier for Personnel Identifier | PIDMO | CHAR | 2 | 0 | |||||||||
| PERSIDNO | Personnel ID Number | PRDNI | CHAR | 20 | 0 | |||||||||
| PASSPORT_DATE_OF_BIRTH | Date of Birth According to Passport | GBPAS | DATS | 8 | 0 | |||||||||
| FIRST_NAME_KATAKANA | First name (Katakana) | P22J_PFNMK | CHAR | 40 | 0 | |||||||||
| LAST_NAME_KATAKANA | Last name (Katakana) | P22J_PLNMK | CHAR | 40 | 0 | |||||||||
| FIRST_NAME_ROMAJI | First Name (Romaji) | P22J_PFNMR | CHAR | 40 | 0 | |||||||||
| LAST_NAME_ROMAJI | Last Name (Romaji) | P22J_PLNMR | CHAR | 40 | 0 | |||||||||
| NAME_OF_BIRTH_KATAKANA | Name of Birth (Katakana) | P22J_PNBIK | CHAR | 40 | 0 | |||||||||
| NAME_OF_BIRTH_ROMAJI | Name of Birth (Romaji) | P22J_PNBIR | CHAR | 40 | 0 | |||||||||
| NICKNAME_KATAKANA | Koseki (Katakana) | P22J_PNCKK | CHAR | 40 | 0 | |||||||||
| NICKNAME_ROMAJI | Koseki (Romaji) | P22J_PNCKR | CHAR | 40 | 0 | |||||||||
| YEAR_OF_BIRTH | Year of Birth | GBJHR | NUMC | 4 | 0 | |||||||||
| MONTH_OF_BIRTH | Month of Birth | GBMON | NUMC | 2 | 0 | |||||||||
| DAY_OF_BIRTH | Birth Date (to Month/Year) | GBTAG | NUMC | 2 | 0 | |||||||||
| LAST_NAME_MATCHCODE | Last Name (Field for Search Help) | NACHNMC | CHAR | 25 | 0 | |||||||||
| FIRST_NAME_MATCHCODE | First Name (Field for Search Help) | VORNAMC | CHAR | 25 | 0 | |||||||||
BAPIHR0002 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPIHR0002 | ARISTOCRATIC_TITLE | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPIHR0002 | ARISTOCRATIC_TITLE | PABCD | LIT_Z | T535N | Name affixes | ART |
| BAPIHR0002 | ARISTOCRATIC_TITLE | BAPIHR0002 | ARISTOCRATIC_TITLE | T535N | Name affixes | TITEL |
| BAPIHR0002 | COUNTRY_OF_BIRTH | SYST | MANDT | T005 | Countries | MANDT |
| BAPIHR0002 | COUNTRY_OF_BIRTH | BAPIHR0002 | COUNTRY_OF_BIRTH | T005 | Countries | LAND1 |
| BAPIHR0002 | FORM_OF_ADDRESS_KEY | SYST | MANDT | T522G | Title Keys | MANDT |
| BAPIHR0002 | FORM_OF_ADDRESS_KEY | BAPIHR0002 | FORM_OF_ADDRESS_KEY | T522G | Title Keys | ANRED |
| BAPIHR0002 | INFOTYPE | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| BAPIHR0002 | INFOTYPE | BAPIHR0002 | INFOTYPE | T582A | Infotypes: Customer-Specific Settings | INFTY |
| BAPIHR0002 | LANGU | BAPIHR0002 | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| BAPIHR0002 | MARITAL_STATUS | SYST | MANDT | T502T | Marital Status Designators | MANDT |
| BAPIHR0002 | MARITAL_STATUS | BAPIHR0002 | LANGU | T502T | Marital Status Designators | SPRSL |
| BAPIHR0002 | MARITAL_STATUS | BAPIHR0002 | MARITAL_STATUS | T502T | Marital Status Designators | FAMST |
| BAPIHR0002 | NAME_AFFIX | PABCD | LIT_V | T535N | Name affixes | ART |
| BAPIHR0002 | NAME_AFFIX | BAPIHR0002 | NAME_AFFIX | T535N | Name affixes | TITEL |
| BAPIHR0002 | NAME_AFFIX | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPIHR0002 | NATIONALITY | SYST | MANDT | T005 | Countries | MANDT |
| BAPIHR0002 | NATIONALITY | BAPIHR0002 | NATIONALITY | T005 | Countries | LAND1 |
| BAPIHR0002 | REASON_TO_CHANGE_MASTER_DATA | BAPIHR0002 | REASON_TO_CHANGE_MASTER_DATA | T530E | Reasons for Changes | PREAS |
| BAPIHR0002 | REASON_TO_CHANGE_MASTER_DATA | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| BAPIHR0002 | REASON_TO_CHANGE_MASTER_DATA | HRINFKEYEMP | INFOTYPE | T530E | Reasons for Changes | INFTY |
| BAPIHR0002 | RELIGIOUS_DENOMINATION | SYST | SPRAS | T516T | Religious Denomination Texts | SPRSL |
| BAPIHR0002 | RELIGIOUS_DENOMINATION | BAPIHR0002 | RELIGIOUS_DENOMINATION | T516T | Religious Denomination Texts | KONFE |
| BAPIHR0002 | RELIGIOUS_DENOMINATION | SYST | MANDT | T516T | Religious Denomination Texts | MANDT |
| BAPIHR0002 | SECOND_NAME_PREFIX | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPIHR0002 | SECOND_NAME_PREFIX | PABCD | LIT_V | T535N | Name affixes | ART |
| BAPIHR0002 | SECOND_NAME_PREFIX | BAPIHR0002 | SECOND_NAME_PREFIX | T535N | Name affixes | TITEL |
| BAPIHR0002 | SECOND_NATIONALITY | BAPIHR0002 | SECOND_NATIONALITY | T005 | Countries | LAND1 |
| BAPIHR0002 | SECOND_NATIONALITY | SYST | MANDT | T005 | Countries | MANDT |
| BAPIHR0002 | SECOND_TITLE | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPIHR0002 | SECOND_TITLE | PABCD | LIT_S | T535N | Name affixes | ART |
| BAPIHR0002 | SECOND_TITLE | BAPIHR0002 | SECOND_TITLE | T535N | Name affixes | TITEL |
| BAPIHR0002 | STATE | BAPIHR0002 | STATE | T005S | Taxes: Region (Province) Key | BLAND |
| BAPIHR0002 | STATE | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| BAPIHR0002 | STATE | BAPIHR0002 | COUNTRY_OF_BIRTH | T005S | Taxes: Region (Province) Key | LAND1 |
| BAPIHR0002 | THIRD_NATIONALITY | SYST | MANDT | T005 | Countries | MANDT |
| BAPIHR0002 | THIRD_NATIONALITY | BAPIHR0002 | THIRD_NATIONALITY | T005 | Countries | LAND1 |
| BAPIHR0002 | TITLE | SYST | MANDT | T535N | Name affixes | MANDT |
| BAPIHR0002 | TITLE | PABCD | LIT_T | T535N | Name affixes | ART |
| BAPIHR0002 | TITLE | BAPIHR0002 | TITLE | T535N | Name affixes | TITEL |
