SAP table PA0109 (HR Master Record: Infotype 0109 (Contract Elements B))

SAP table PA0109 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
BEANC Seniority DATS 8 0 BEANC
BEAAN Contract time amount DEC 3 0 BEAAN
BETIM Contract period CHAR 3 0 BETIM
BEGWU Unemployment payment CURR 9 2 BEGWU
WAERS Currency Key CUKY 5 0 TCURC WAERS
BEUWG Contractual Mean Working Hours per week DEC 5 2 BEUWG
BECAO Collective Agreement CHAR 4 0 T5B6B BECAO
BEGPC Joint Commission (00046) CHAR 7 0 T5B6C BEGPC
BECNR Contract Number CHAR 15 0 BECNR
BEMCH Meal voucher CHAR 1 0 BEMCH
BEGFB Early Retirement with Fixed Compensation CHAR 1 0 BEGFB
BEGGH Entitled Family Member CHAR 1 0 BEGGH
BREGM Regulation contract months per year CHAR 2 0 BREGM
WOAHO Working at home indication CHAR 1 0 P12_WOAHO
WPADR Workplace Address Code CHAR 4 0 P12_WPADR
DIMNR Dimona Number NUMC 12 0 P12_DIMNR
DIC3C C3.2A Card for Current Month (00663) NUMC 12 0 P12_DIC3C
DIC3F C3.2A Card for Following Month (00664) NUMC 12 0 P12_DIC3F
WPADD External Workplace Address Code CHAR 4 0 P12_WPADD
LOCUN Local Unit ID (00042) NUMC 10 0 T5BD1 P12_LOCUN
WRKPB Workplace Address Key CHAR 8 0 P12_WRKPLACE
PDNY1 Planned Social Insurance (SI) Declaration Year NUMC 4 0 P12_EGOV_PLANNED_YEAR
PDNQ1 Planned Social Insurance (SI) Declaration Quarter NUMC 1 0 P12_EGOV_PLANNED_QUARTER
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV1 Planned Work for the Year/Quarter (01017) NUMC 3 0 P12_EGOV_PLANNED_DAY_NBR
PDNY2 Planned Social Insurance (SI) Declaration Year NUMC 4 0 P12_EGOV_PLANNED_YEAR
PDNQ2 Planned Social Insurance (SI) Declaration Quarter NUMC 1 0 P12_EGOV_PLANNED_QUARTER
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV2 Planned Work for the Year/Quarter (01017) NUMC 3 0 P12_EGOV_PLANNED_DAY_NBR
PDNY3 Planned Social Insurance (SI) Declaration Year NUMC 4 0 P12_EGOV_PLANNED_YEAR
PDNQ3 Planned Social Insurance (SI) Declaration Quarter NUMC 1 0 P12_EGOV_PLANNED_QUARTER
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV3 Planned Work for the Year/Quarter (01017) NUMC 3 0 P12_EGOV_PLANNED_DAY_NBR
PDNY4 Planned Social Insurance (SI) Declaration Year NUMC 4 0 P12_EGOV_PLANNED_YEAR
PDNQ4 Planned Social Insurance (SI) Declaration Quarter NUMC 1 0 P12_EGOV_PLANNED_QUARTER
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV4 Planned Work for the Year/Quarter (01017) NUMC 3 0 P12_EGOV_PLANNED_DAY_NBR
PDNY5 Planned Social Insurance (SI) Declaration Year NUMC 4 0 P12_EGOV_PLANNED_YEAR
PDNQ5 Planned Social Insurance (SI) Declaration Quarter NUMC 1 0 P12_EGOV_PLANNED_QUARTER
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV5 Planned Work for the Year/Quarter (01017) NUMC 3 0 P12_EGOV_PLANNED_DAY_NBR
DISPD Dismissal Period CHAR 1 0 P12_DISPD
DISND Dismissal Notification Date DATS 8 0 P12_DISND
DISHW Historical Dismissal Weeks DEC 5 2 P12_DISHW
BPSNS Checkbox Old/New Personnel Statute CHAR 1 0 P12P_BPSNS
ONSSAPLPSTFBI Previous EE's statute - FBI (AR/KB 491) (ONSSAPL/RSZPPO 246) CHAR 1 0 P12P_ONSSAPLPSTFBI
0 No value
1 Special temporary cadre (BTK/CST)
2 Third employment circuit (DAC/TCT)
3 Unemployed put to work (TWW/CMT)
4 Others
ONSSAPLSTF Employee's function status (ONSSAPL / RSZPPO 197) CHAR 1 0 T5BPBS07 P12P_ONSSAPLSTF
ONSSAPLSTPI Code Article 29 - AR 25/11/91 (ONSSAPL / RSZPPO 271) CHAR 1 0 T5BPBS08 P12P_ONSSAPLSTPI
CA_SIT Situation of the right-having NUMC 1 0 P12P_CA_SIT
0 No right
1 Normal
2 Handicapped or more than 6 months incapacitated
3 More than 6 months unemployed
4 Retired
NACEC Employee Activity Code (NACE) (00228) NUMC 5 0 T5BPBS27XC P12P_ONSSAPLCODE76

PA0109 foreign key relationships

Table Field Check Table Check Field
0 PA0109 BECAO T5B6B Pay Scale Agreements (B) MANDT
0 PA0109 BECAO T5B6B Pay Scale Agreements (B) ENDDA
1 PA0109 BEGPC T5B6C Joint Commissions (B) MANDT
0 PA0109 LOCUN T5BD1 Local Unit ID entities table MANDT
1 PA0109 MANDT T000 Clients MANDT
0 PA0109 NACEC T5BPBS27XC Employee's activity Code (ONSSAPL / RSZPPO 076) MANDT
1 PA0109 ONSSAPLSTF T5BPBS07 Employee's function status (ONSSAPL / RSZPPO 197) MANDT
1 PA0109 ONSSAPLSTF T5BPBS07 Employee's function status (ONSSAPL / RSZPPO 197) ONSSAPLSTF
0 PA0109 ONSSAPLSTPI T5BPBS08 Code Article 29 - AR 25/11/91 (ONSSAPL / RSZPPO 271) MANDT
0 PA0109 ONSSAPLSTPI T5BPBS08 Code Article 29 - AR 25/11/91 (ONSSAPL / RSZPPO 271) ONSSAPLSTPI
1 PA0109 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0109 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0109 PREAS T530E Reasons for Changes MANDT
0 PA0109 PREAS T530E Reasons for Changes INFTY
0 PA0109 PREAS T530E Reasons for Changes PREAS
1 PA0109 WAERS TCURC Currency Codes MANDT
1 PA0109 WAERS TCURC Currency Codes WAERS