SAP Table BAPIP0002JP

HR Master Record: Infotype 0002 (Personal Data) Japan

BAPIP0002JP (HR Master Record: Infotype 0002 (Personal Data) Japan) 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 BAPIP0002JP to other SAP tables.

BAPIP0002JP table fields

Field Data element Checktable Datatype Length Decimals
EMPLOYEENO Personnel Number PERNR_D NUMC 8 0
SUBTYPE Subtype SUBTY CHAR 4 0
OBJECTID Object Identification OBJPS CHAR 2 0
LOCKINDIC Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
VALIDEND End Date ENDDA DATS 8 0
VALIDBEGIN Start Date BEGDA DATS 8 0
RECORDNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
FIRSTNAME First Name PAD_VORNA CHAR 40 0
LASTNAME Last Name PAD_NACHN CHAR 40 0
FIRSTNAMEKATAKANA First name (Katakana) P22J_PFNMK CHAR 40 0
LASTNAMEKATAKANA Last name (Katakana) P22J_PLNMK CHAR 40 0
FIRSTNAMEROMAJI First Name (Romaji) P22J_PFNMR CHAR 40 0
LASTNAMEROMAJI Last Name (Romaji) P22J_PLNMR CHAR 40 0
NAMEATBIRTH Name at Birth PAD_NAME2 CHAR 40 0
NAMEATBIRTHKATAKANA Name of Birth (Katakana) P22J_PNBIK CHAR 40 0
NAMEATBIRTHROMAJI Name of Birth (Romaji) P22J_PNBIR CHAR 40 0
KOSEKINAME Nickname PAD_RUFNM CHAR 40 0
KOSEKINAMEKATAKANA Koseki (Katakana) P22J_PNCKK CHAR 40 0
KOSEKINAMEROMAJI Koseki (Romaji) P22J_PNCKR CHAR 40 0
ACADEMICGRADE Title TITEL T535N CHAR 15 0
SECONDACADGRADE Second Title TITL2 T535N CHAR 15 0
GENDER Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
DATEOFBIRTH Date of Birth GBDAT DATS 8 0
BIRTHPLACE Birthplace PAD_GBORT CHAR 40 0
STATEOFBIRTH State GBDEP T005S CHAR 3 0
COUNTRYOFBIRTH Country of Birth GBLND T005 CHAR 3 0
MARITALSTATUS Marital Status Key FAMST T502T CHAR 1 0
MARITALSTATUSSINCE Valid From Date of Current Marital Status FAMDT DATS 8 0
LANGUAGE Language Key SPRSL T002 LANG 1 0
LANGUAGE_ISO 2-Character SAP Language Code LAISO CHAR 2 0
NATIONALITY Nationality NATSL T005 CHAR 3 0
NAMEFORMAT Name Format Indicator for Employee in a List KNZNM NUMC 2 0
NAMEOFGENDER Short Description of Repository Objects AS4TEXT CHAR 60 0
NAMEOFSTATEOFBIRTH Description BEZEI20 CHAR 20 0
NAMEOFCOUNTRYOFBIRTH Country Name LANDX CHAR 15 0
NAMEOFMARITALSTATUS Marital Status FATXT CHAR 6 0
NAMEOFLANGUAGE Name of Language SPTXT CHAR 16 0
NAMEOFNATIONALITY Nationality NATIO CHAR 15 0
NAMEOFNAMEFORM Short Description of Repository Objects AS4TEXT CHAR 60 0
FORMATTEDNAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0

BAPIP0002JP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIP0002JP ACADEMICGRADE 'T' T535N Name affixes ART
BAPIP0002JP ACADEMICGRADE BAPIP0002JP ACADEMICGRADE T535N Name affixes TITEL
BAPIP0002JP ACADEMICGRADE SYST MANDT T535N Name affixes MANDT
BAPIP0002JP COUNTRYOFBIRTH SYST MANDT T005 Countries MANDT
BAPIP0002JP COUNTRYOFBIRTH BAPIP0002JP COUNTRYOFBIRTH T005 Countries LAND1
BAPIP0002JP LANGUAGE BAPIP0002JP LANGUAGE T002 Language Keys (Component BC-I18) SPRAS
BAPIP0002JP MARITALSTATUS SYST MANDT T502T Marital Status Designators MANDT
BAPIP0002JP MARITALSTATUS SYST LANGU T502T Marital Status Designators SPRSL
BAPIP0002JP MARITALSTATUS BAPIP0002JP MARITALSTATUS T502T Marital Status Designators FAMST
BAPIP0002JP NATIONALITY SYST MANDT T005 Countries MANDT
BAPIP0002JP NATIONALITY BAPIP0002JP NATIONALITY T005 Countries LAND1
BAPIP0002JP SECONDACADGRADE SYST MANDT T535N Name affixes MANDT
BAPIP0002JP SECONDACADGRADE 'T' T535N Name affixes ART
BAPIP0002JP SECONDACADGRADE BAPIP0002JP SECONDACADGRADE T535N Name affixes TITEL
BAPIP0002JP STATEOFBIRTH BAPIP0002JP COUNTRYOFBIRTH T005S Taxes: Region (Province) Key LAND1
BAPIP0002JP STATEOFBIRTH BAPIP0002JP STATEOFBIRTH T005S Taxes: Region (Province) Key BLAND
BAPIP0002JP STATEOFBIRTH SYST MANDT T005S Taxes: Region (Province) Key MANDT