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

Dictionary Type: Table
Description: HR Master Record: Infotype 0109 (Contract Elements B)




ABAP Code to SELECT data from PA0109
Related tables to PA0109
Access table PA0109




Table field list including key, data, relationships and ABAP select examples

PA0109 is a standard SAP Table which is used to store HR Master Record: Infotype 0109 (Contract Elements B) data and is available within R/3 SAP systems depending on the version and release level.

The PA0109 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0109 (Contract Elements B) data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PA0109 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
BEANCSeniority BEANCDATS8DATUM
BEAANContract time amount BEAANDEC3DEC3
BETIMContract period BETIMCHAR3CHAR3
BEGWUUnemployment payment BEGWUCURR9(2) BETRG
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BEUWGContractual Mean Working Hours per week BEUWGDEC5(2) DEC3_2
BECAOCollective agreement BECAOCHAR4T5B6BBECAO
BEGPCJoint Commission (00046) BEGPCCHAR7T5B6CBEGPC
BECNRContract number BECNRCHAR15CHAR15
BEMCHMeal voucher BEMCHCHAR1CHAR1
BEGFBEarly retirement with fixed compensation BEGFBCHAR1XFELD
BEGGHEntitled family member BEGGHCHAR1XFELD
BREGMRegulation contract months per year BREGMCHAR2CHAR2
WOAHOWorking at home indication P12_WOAHOCHAR1CHAR1
WPADRWorking place adress code P12_WPADRCHAR4CHAR4
DIMNRDIMONA number P12_DIMNRNUMC12NUMC12
DIC3CC3.2A Card for Current Month (00663) P12_DIC3CNUMC12NUMC12
DIC3FC3.2A Card for Following Month (00664) P12_DIC3FNUMC12NUMC12
WPADDExternal working place address code P12_WPADDCHAR4CHAR4
LOCUNLocal Unit ID (00042) P12_LOCUNNUMC10T5BD1NUM10
WRKPBWorkplace address key P12_WRKPLACECHAR8ANSSL
PDNY1Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEARNUMC4P12_EGOV_PLANNED_YEAR
PDNQ1Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTERNUMC1P12_EGOV_PLANNED_QUARTER
PDNV1Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBRNUMC3NUMC3
PDNY2Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEARNUMC4P12_EGOV_PLANNED_YEAR
PDNQ2Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTERNUMC1P12_EGOV_PLANNED_QUARTER
PDNV2Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBRNUMC3NUMC3
PDNY3Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEARNUMC4P12_EGOV_PLANNED_YEAR
PDNQ3Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTERNUMC1P12_EGOV_PLANNED_QUARTER
PDNV3Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBRNUMC3NUMC3
PDNY4Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEARNUMC4P12_EGOV_PLANNED_YEAR
PDNQ4Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTERNUMC1P12_EGOV_PLANNED_QUARTER
PDNV4Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBRNUMC3NUMC3
PDNY5Planned Social Insurance (SI) Declaration Year P12_EGOV_PLANNED_YEARNUMC4P12_EGOV_PLANNED_YEAR
PDNQ5Planned Social Insurance (SI) Declaration Quarter P12_EGOV_PLANNED_QUARTERNUMC1P12_EGOV_PLANNED_QUARTER
PDNV5Planned Days for the Year/ Quarter (EGOV field 01017) P12_EGOV_PLANNED_DAY_NBRNUMC3NUMC3
DISPDDismissal period P12_DISPDCHAR1XFELD
DISNDDismissal notification date P12_DISNDDATS8DATS
.INCLU--AP 0
BPSNSCheckbox Old/New Personnel Statute P12P_BPSNSCHAR1XFLAG
ONSSAPLPSTFBIPrevious EE's statute - FBI (AR/KB 491) (ONSSAPL/RSZPPO 246) P12P_ONSSAPLPSTFBICHAR1P12P_ONSSAPLPSTFBI
ONSSAPLSTFEmployee's function status (ONSSAPL / RSZPPO 197) P12P_ONSSAPLSTFCHAR1T5BPBS07P12P_ONSSAPLSTF
ONSSAPLSTPICode Article 29 - AR 25/11/91 (ONSSAPL / RSZPPO 271) P12P_ONSSAPLSTPICHAR1T5BPBS08P12P_ONSSAPLSTPI
CA_SITSituation of the right-having P12P_CA_SITNUMC1P12P_CA_SIT
NACECEmployee Activity Code (NACE) (00228) P12P_ONSSAPLCODE76NUMC5T5BPBS27XCP12P_ONSSAPLCODE76

Key field Non-key field



How do I retrieve data from SAP table PA0109 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PA0109 to SELECT all data from the table
DATA: WA_PA0109 TYPE PA0109.

SELECT SINGLE *
FROM PA0109
INTO CORRESPONDING FIELDS OF WA_PA0109
WHERE...

How to access SAP table PA0109

Within an ECC or HANA version of SAP you can also view further information about PA0109 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!