SAP table PA0041 (HR Master Record: Infotype 0041 (Date Specifications))

SAP table PA0041 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
DAR01 Date type CHAR 2 0 T548Y DATAR
DAT01 Date for date type DATS 8 0 DARDT
DAR02 Date type CHAR 2 0 T548Y DATAR
DAT02 Date for date type DATS 8 0 DARDT
DAR03 Date type CHAR 2 0 T548Y DATAR
DAT03 Date for date type DATS 8 0 DARDT
DAR04 Date type CHAR 2 0 T548Y DATAR
DAT04 Date for date type DATS 8 0 DARDT
DAR05 Date type CHAR 2 0 T548Y DATAR
DAT05 Date for date type DATS 8 0 DARDT
DAR06 Date type CHAR 2 0 T548Y DATAR
DAT06 Date for date type DATS 8 0 DARDT
DAR07 Date type CHAR 2 0 T548Y DATAR
DAT07 Date for date type DATS 8 0 DARDT
DAR08 Date type CHAR 2 0 T548Y DATAR
DAT08 Date for date type DATS 8 0 DARDT
DAR09 Date type CHAR 2 0 T548Y DATAR
DAT09 Date for date type DATS 8 0 DARDT
DAR10 Date type CHAR 2 0 T548Y DATAR
DAT10 Date for date type DATS 8 0 DARDT
DAR11 Date type CHAR 2 0 T548Y DATAR
DAT11 Date for date type DATS 8 0 DARDT
DAR12 Date type CHAR 2 0 T548Y DATAR
DAT12 Date for date type DATS 8 0 DARDT
DAR13 Date type CHAR 2 0 T548Y DATAR
DAT13 Date for date type DATS 8 0 DARDT
DAR14 Date type CHAR 2 0 T548Y DATAR
DAT14 Date for date type DATS 8 0 DARDT
DAR15 Date type CHAR 2 0 T548Y DATAR
DAT15 Date for date type DATS 8 0 DARDT
DAR16 Date type CHAR 2 0 T548Y DATAR
DAT16 Date for date type DATS 8 0 DARDT
DAR17 Date type CHAR 2 0 T548Y DATAR
DAT17 Date for date type DATS 8 0 DARDT
DAR18 Date type CHAR 2 0 T548Y DATAR
DAT18 Date for date type DATS 8 0 DARDT
DAR19 Date type CHAR 2 0 T548Y DATAR
DAT19 Date for date type DATS 8 0 DARDT
DAR20 Date type CHAR 2 0 T548Y DATAR
DAT20 Date for date type DATS 8 0 DARDT
DAR21 Date type CHAR 2 0 T548Y DATAR
DAT21 Date for date type DATS 8 0 DARDT
DAR22 Date type CHAR 2 0 T548Y DATAR
DAT22 Date for date type DATS 8 0 DARDT
DAR23 Date type CHAR 2 0 T548Y DATAR
DAT23 Date for date type DATS 8 0 DARDT
DAR24 Date type CHAR 2 0 T548Y DATAR
DAT24 Date for date type DATS 8 0 DARDT

PA0041 foreign key relationships

Table Field Check Table Check Field
0 PA0041 DAR01 T548Y Date Types MANDT
0 PA0041 DAR01 T548Y Date Types DATAR
1 PA0041 DAR02 T548Y Date Types MANDT
1 PA0041 DAR02 T548Y Date Types DATAR
0 PA0041 DAR03 T548Y Date Types MANDT
0 PA0041 DAR03 T548Y Date Types DATAR
1 PA0041 DAR04 T548Y Date Types MANDT
1 PA0041 DAR04 T548Y Date Types DATAR
0 PA0041 DAR05 T548Y Date Types MANDT
0 PA0041 DAR05 T548Y Date Types DATAR
1 PA0041 DAR06 T548Y Date Types MANDT
1 PA0041 DAR06 T548Y Date Types DATAR
0 PA0041 DAR07 T548Y Date Types MANDT
0 PA0041 DAR07 T548Y Date Types DATAR
1 PA0041 DAR08 T548Y Date Types MANDT
1 PA0041 DAR08 T548Y Date Types DATAR
0 PA0041 DAR09 T548Y Date Types MANDT
0 PA0041 DAR09 T548Y Date Types DATAR
1 PA0041 DAR10 T548Y Date Types MANDT
1 PA0041 DAR10 T548Y Date Types DATAR
0 PA0041 DAR11 T548Y Date Types MANDT
0 PA0041 DAR11 T548Y Date Types DATAR
1 PA0041 DAR12 T548Y Date Types MANDT
1 PA0041 DAR12 T548Y Date Types DATAR
0 PA0041 DAR13 T548Y Date Types MANDT
0 PA0041 DAR13 T548Y Date Types DATAR
1 PA0041 DAR14 T548Y Date Types MANDT
1 PA0041 DAR14 T548Y Date Types DATAR
0 PA0041 DAR15 T548Y Date Types MANDT
0 PA0041 DAR15 T548Y Date Types DATAR
1 PA0041 DAR16 T548Y Date Types MANDT
1 PA0041 DAR16 T548Y Date Types DATAR
0 PA0041 DAR17 T548Y Date Types MANDT
0 PA0041 DAR17 T548Y Date Types DATAR
1 PA0041 DAR18 T548Y Date Types MANDT
1 PA0041 DAR18 T548Y Date Types DATAR
0 PA0041 DAR19 T548Y Date Types MANDT
0 PA0041 DAR19 T548Y Date Types DATAR
1 PA0041 DAR20 T548Y Date Types MANDT
1 PA0041 DAR20 T548Y Date Types DATAR
0 PA0041 DAR21 T548Y Date Types MANDT
0 PA0041 DAR21 T548Y Date Types DATAR
1 PA0041 DAR22 T548Y Date Types MANDT
1 PA0041 DAR22 T548Y Date Types DATAR
0 PA0041 DAR23 T548Y Date Types MANDT
0 PA0041 DAR23 T548Y Date Types DATAR
1 PA0041 DAR24 T548Y Date Types MANDT
1 PA0041 DAR24 T548Y Date Types DATAR
0 PA0041 MANDT T000 Clients MANDT
1 PA0041 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0041 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0041 PREAS T530E Reasons for Changes MANDT
0 PA0041 PREAS T530E Reasons for Changes INFTY
0 PA0041 PREAS T530E Reasons for Changes PREAS