SAP table BAPIHR0002 (HR: HR Master Record Infotype 0002 (Personal Data))

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

BAPIHR0002 foreign key relationships

Table Field Check Table Check Field
0 BAPIHR0002 ARISTOCRATIC_TITLE T535N Name affixes MANDT
0 BAPIHR0002 ARISTOCRATIC_TITLE T535N Name affixes ART
0 BAPIHR0002 ARISTOCRATIC_TITLE T535N Name affixes TITEL
1 BAPIHR0002 COUNTRY_OF_BIRTH T005 Countries MANDT
1 BAPIHR0002 COUNTRY_OF_BIRTH T005 Countries LAND1
0 BAPIHR0002 FORM_OF_ADDRESS_KEY T522G Title Keys MANDT
0 BAPIHR0002 FORM_OF_ADDRESS_KEY T522G Title Keys ANRED
1 BAPIHR0002 INFOTYPE T582A Infotypes: Customer-Specific Settings MANDT
1 BAPIHR0002 INFOTYPE T582A Infotypes: Customer-Specific Settings INFTY
0 BAPIHR0002 MARITAL_STATUS T502T Marital Status Designators MANDT
0 BAPIHR0002 MARITAL_STATUS T502T Marital Status Designators SPRSL
0 BAPIHR0002 MARITAL_STATUS T502T Marital Status Designators FAMST
1 BAPIHR0002 NAME_AFFIX T535N Name affixes MANDT
1 BAPIHR0002 NAME_AFFIX T535N Name affixes ART
1 BAPIHR0002 NAME_AFFIX T535N Name affixes TITEL
0 BAPIHR0002 NATIONALITY T005 Countries MANDT
0 BAPIHR0002 NATIONALITY T005 Countries LAND1
1 BAPIHR0002 REASON_TO_CHANGE_MASTER_DATA T530E Reasons for Changes MANDT
1 BAPIHR0002 REASON_TO_CHANGE_MASTER_DATA T530E Reasons for Changes INFTY
1 BAPIHR0002 REASON_TO_CHANGE_MASTER_DATA T530E Reasons for Changes PREAS
0 BAPIHR0002 RELIGIOUS_DENOMINATION T516T Religious Denomination Texts MANDT
0 BAPIHR0002 RELIGIOUS_DENOMINATION T516T Religious Denomination Texts SPRSL
1 BAPIHR0002 SECOND_NAME_PREFIX T535N Name affixes MANDT
1 BAPIHR0002 SECOND_NAME_PREFIX T535N Name affixes ART
1 BAPIHR0002 SECOND_NAME_PREFIX T535N Name affixes TITEL
0 BAPIHR0002 SECOND_NATIONALITY T005 Countries MANDT
0 BAPIHR0002 SECOND_NATIONALITY T005 Countries LAND1
1 BAPIHR0002 SECOND_TITLE T535N Name affixes MANDT
1 BAPIHR0002 SECOND_TITLE T535N Name affixes ART
1 BAPIHR0002 SECOND_TITLE T535N Name affixes TITEL
0 BAPIHR0002 STATE T005S Taxes: Region (Province) Key LAND1
1 BAPIHR0002 THIRD_NATIONALITY T005 Countries MANDT
1 BAPIHR0002 THIRD_NATIONALITY T005 Countries LAND1
0 BAPIHR0002 TITLE T535N Name affixes MANDT
0 BAPIHR0002 TITLE T535N Name affixes ART
0 BAPIHR0002 TITLE T535N Name affixes TITEL