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

SAP table PA0002 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PERNR Personnel Number NUMC 8 0 PA0003 PERSNO
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
INITS Initials CHAR 10 0 INITS
NACHN Last Name CHAR 40 0 PAD_NACHN
NAME2 Name at Birth CHAR 40 0 PAD_NAME2
NACH2 Second Name CHAR 40 0 PAD_NACH2
VORNA First Name CHAR 40 0 PAD_VORNA
CNAME Complete Name CHAR 80 0 PAD_CNAME
TITEL Title CHAR 15 0 T535N TITEL
TITL2 Second Title CHAR 15 0 T535N TITL2
NAMZU Other Title CHAR 15 0 T535N NAMZU
VORSW Name Prefix CHAR 15 0 T535N VORSW
VORS2 Second Name Prefix CHAR 15 0 T535N VORS2
RUFNM Nickname CHAR 40 0 PAD_RUFNM
MIDNM Middle Name CHAR 40 0 PAD_MIDNM
KNZNM Name Format Indicator for Employee in a List NUMC 2 0 KNZNM
ANRED Form-of-Address Key CHAR 1 0 T522G ANRDE
GESCH Gender CHAR 1 0 T77PAD_GENDER HRPAD_GENDER
GBDAT Date of Birth DATS 8 0 GBDAT
GBLND Country/Region of Birth CHAR 3 0 T005 GBLND
GBDEP State CHAR 3 0 T005S GBDEP
GBORT Birthplace CHAR 40 0 PAD_GBORT
NATIO Nationality CHAR 3 0 T005 NATSL
NATI2 Second Nationality CHAR 3 0 T005 NATS2
NATI3 Third Nationality CHAR 3 0 T005 NATS3
SPRSL Communication Language LANG 1 0 T002 PAD_SPRAS
KONFE Religious Denomination Key CHAR 2 0 * KONFE
FAMST Marital Status Key CHAR 1 0 * FAMST
FAMDT Valid From Date of Current Marital Status DATS 8 0 FAMDT
ANZKD Number of Children DEC 3 0 ANZKD
NACON Name Connection CHAR 1 0 NACON
PERMO Modifier for Personnel Identifier CHAR 2 0 PIDMO
PERID Personnel ID Number CHAR 20 0 PRDNI
GBPAS Date of Birth According to Passport DATS 8 0 GBPAS
FNAMK First name (Katakana) CHAR 40 0 P22J_PFNMK
LNAMK Last name (Katakana) CHAR 40 0 P22J_PLNMK
FNAMR First Name (Romaji) CHAR 40 0 P22J_PFNMR
LNAMR Last Name (Romaji) CHAR 40 0 P22J_PLNMR
NABIK Name of Birth (Katakana) CHAR 40 0 P22J_PNBIK
NABIR Name of Birth (Romaji) CHAR 40 0 P22J_PNBIR
NICKK Koseki (Katakana) CHAR 40 0 P22J_PNCKK
NICKR Koseki (Romaji) CHAR 40 0 P22J_PNCKR
GBJHR Year of Birth NUMC 4 0 GBJHR
GBMON Month of Birth NUMC 2 0 GBMON
GBTAG Birth Date (to Month/Year) NUMC 2 0 GBTAG
NCHMC Last Name (Field for Search Help) CHAR 25 0 NACHNMC
VNAMC First Name (Field for Search Help) CHAR 25 0 VORNAMC
NAMZ2 Name Affix for Name at Birth CHAR 15 0 T535N NAMZ2
GENDER_SI Self-Identified Gender CHAR 1 0 * HRPAD_GENDER_SI

PA0002 foreign key relationships

Table Field Check Table Check Field
0 PA0002 ANRED T522G Title Keys MANDT
0 PA0002 ANRED T522G Title Keys ANRED
1 PA0002 GBDEP T005S Taxes: Region (Province) Key LAND1
0 PA0002 GBLND T005 Countries MANDT
0 PA0002 GBLND T005 Countries LAND1
1 PA0002 GESCH T77PAD_GENDER Gender MOLGA
1 PA0002 GESCH T77PAD_GENDER Gender GENDER
0 PA0002 MANDT T000 Clients MANDT
1 PA0002 NAMZ2 T535N Name affixes MANDT
1 PA0002 NAMZ2 T535N Name affixes ART
1 PA0002 NAMZ2 T535N Name affixes TITEL
0 PA0002 NAMZU T535N Name affixes MANDT
0 PA0002 NAMZU T535N Name affixes ART
0 PA0002 NAMZU T535N Name affixes TITEL
1 PA0002 NATI2 T005 Countries MANDT
1 PA0002 NATI2 T005 Countries LAND1
0 PA0002 NATI3 T005 Countries MANDT
0 PA0002 NATI3 T005 Countries LAND1
1 PA0002 NATIO T005 Countries MANDT
1 PA0002 NATIO T005 Countries LAND1
0 PA0002 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
0 PA0002 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
1 PA0002 PREAS T530E Reasons for Changes MANDT
1 PA0002 PREAS T530E Reasons for Changes INFTY
1 PA0002 PREAS T530E Reasons for Changes PREAS
0 PA0002 TITEL T535N Name affixes MANDT
0 PA0002 TITEL T535N Name affixes ART
0 PA0002 TITEL T535N Name affixes TITEL
1 PA0002 TITL2 T535N Name affixes MANDT
1 PA0002 TITL2 T535N Name affixes ART
1 PA0002 TITL2 T535N Name affixes TITEL
0 PA0002 VORS2 T535N Name affixes MANDT
0 PA0002 VORS2 T535N Name affixes ART
0 PA0002 VORS2 T535N Name affixes TITEL
1 PA0002 VORSW T535N Name affixes MANDT
1 PA0002 VORSW T535N Name affixes ART
1 PA0002 VORSW T535N Name affixes TITEL