SAP table PA0809 (HR Master Record: Infotype 0809)

SAP table PA0809 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 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
NAM01 Dependant's name CHAR 20 0 PKR_DNAME
ELV01 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE01 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC01 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM02 Dependant's name CHAR 20 0 PKR_DNAME
ELV02 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE02 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC02 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM03 Dependant's name CHAR 20 0 PKR_DNAME
ELV03 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE03 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC03 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM04 Dependant's name CHAR 20 0 PKR_DNAME
ELV04 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE04 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC04 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM05 Dependant's name CHAR 20 0 PKR_DNAME
ELV05 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE05 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC05 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM06 Dependant's name CHAR 20 0 PKR_DNAME
ELV06 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE06 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC06 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM07 Dependant's name CHAR 20 0 PKR_DNAME
ELV07 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE07 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC07 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC
NAM08 Dependant's name CHAR 20 0 PKR_DNAME
ELV08 Dependant's education level CHAR 1 0 PKR_EDULV
1 Before Elementary
2 Elementary/Middle School/High School
3 University and above
4 Employee Self
5 Special Institution for the Handicapped
EFE08 Dependant's educational expenses CURR 9 2 PKR_DPEDF
DFC08 Dependant's educational expenses currency CUKY 5 0 * PKR_DPEFC

PA0809 foreign key relationships

Table Field Check Table Check Field
0 PA0809 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
0 PA0809 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
1 PA0809 PREAS T530E Reasons for Changes MANDT
1 PA0809 PREAS T530E Reasons for Changes INFTY
1 PA0809 PREAS T530E Reasons for Changes PREAS