SAP Table PA0109

HR Master Record: Infotype 0109 (Contract Elements B)

PA0109 (HR Master Record: Infotype 0109 (Contract Elements B)) 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 PA0109 to other SAP tables.

PA0109 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
BEANC Seniority BEANC DATS 8 0
BEAAN Contract time amount BEAAN DEC 3 0
BETIM Contract period BETIM CHAR 3 0
BEGWU Unemployment payment BEGWU CURR 9 2
WAERS Currency Key WAERS TCURC CUKY 5 0
BEUWG Contractual Mean Working Hours per week BEUWG DEC 5 2
BECAO Collective agreement BECAO T5B6B CHAR 4 0
BEGPC Joint Commission (00046) BEGPC T5B6C CHAR 7 0
BECNR Contract number BECNR CHAR 15 0
BEMCH Meal voucher BEMCH CHAR 1 0
BEGFB Early retirement with fixed compensation BEGFB CHAR 1 0
X Yes
NULL No
BEGGH Entitled family member BEGGH CHAR 1 0
X Yes
NULL No
BREGM Regulation contract months per year BREGM CHAR 2 0
WOAHO Working at home indication P12_WOAHO CHAR 1 0
WPADR Working place adress code P12_WPADR CHAR 4 0
DIMNR DIMONA number P12_DIMNR NUMC 12 0
DIC3C C3.2A Card for Current Month (00663) P12_DIC3C NUMC 12 0
DIC3F C3.2A Card for Following Month (00664) P12_DIC3F NUMC 12 0
WPADD External working place address code P12_WPADD CHAR 4 0
LOCUN Local Unit ID (00042) P12_LOCUN T5BD1 NUMC 10 0
WRKPB Workplace address key P12_WRKPLACE CHAR 8 0
PDNY1 Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEAR NUMC 4 0
2012 2012
2013 2013
2015 2015
2016 2016
2017 2017
2018 2018
2019 2019
2020 2020
PDNQ1 Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTER NUMC 1 0
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV1 Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBR NUMC 3 0
PDNY2 Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEAR NUMC 4 0
2012 2012
2013 2013
2015 2015
2016 2016
2017 2017
2018 2018
2019 2019
2020 2020
PDNQ2 Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTER NUMC 1 0
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV2 Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBR NUMC 3 0
PDNY3 Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEAR NUMC 4 0
2012 2012
2013 2013
2015 2015
2016 2016
2017 2017
2018 2018
2019 2019
2020 2020
PDNQ3 Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTER NUMC 1 0
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV3 Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBR NUMC 3 0
PDNY4 Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEAR NUMC 4 0
2012 2012
2013 2013
2015 2015
2016 2016
2017 2017
2018 2018
2019 2019
2020 2020
PDNQ4 Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTER NUMC 1 0
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV4 Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBR NUMC 3 0
PDNY5 Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEAR NUMC 4 0
2012 2012
2013 2013
2015 2015
2016 2016
2017 2017
2018 2018
2019 2019
2020 2020
PDNQ5 Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTER NUMC 1 0
1 Quarter 1
2 Quarter 2
3 Quarter 3
4 Quarter 4
PDNV5 Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBR NUMC 3 0
DISPD Dismissal period P12_DISPD CHAR 1 0
X Yes
NULL No
DISND Dismissal notification date P12_DISND DATS 8 0
BPSNS Checkbox Old/New Personnel Statute P12P_BPSNS CHAR 1 0
NULL Blank
. Radio button
X Selection
ONSSAPLPSTFBI Previous EE's statute - FBI (AR/KB 491) (ONSSAPL/RSZPPO 246) P12P_ONSSAPLPSTFBI CHAR 1 0
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) P12P_ONSSAPLSTF T5BPBS07 CHAR 1 0
ONSSAPLSTPI Code Article 29 - AR 25/11/91 (ONSSAPL / RSZPPO 271) P12P_ONSSAPLSTPI T5BPBS08 CHAR 1 0
CA_SIT Situation of the right-having P12P_CA_SIT NUMC 1 0
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) P12P_ONSSAPLCODE76 T5BPBS27XC NUMC 5 0

PA0109 foreign key relationships

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