PA0859 SAP (HR Master data for infotype 0859) Table details

Dictionary Type: Table
Description: HR Master data for infotype 0859




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




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

PA0859 is a standard SAP Table which is used to store HR Master data for infotype 0859 data and is available within R/3 SAP systems depending on the version and release level.

The PA0859 table consists of various fields, each holding specific information or linking keys about HR Master data for infotype 0859 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: Not classified


SAP PA0859 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 MANDTCLNT3Assigned to domainMANDT
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
CNTTYContract type PPL_CNTTYCHAR4T591ASUBTY_591A
VBELNSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
POSNRSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
KOKRS_CUSTControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTL_CUSTProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
KOKRS_INTControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTL_INTCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
ADM_ORDEROrder adminstrator PPL_ADMORDERCHAR12CHAR12
FIRE_REASONFire reason PPL_FIRE_REASCHAR2T7PLT0MASSG
CUSTNRSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
CUST_NAME1Name 1 AD_NAME1CHAR40TEXT40
CUST_NAME2Name 2 AD_NAME2CHAR40TEXT40
CUST_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
CUST_STREETStreet and House Number PAD_STRASCHAR60PAD_STRAS
CUST_HOUSEHouse Number AD_HSNM1CHAR10TEXT10
CUST_ROOMRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
CUST_POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
CUST_POSTPost office PPL_POST_OFFICECHAR40TEXT40CITY_NAME
CUST_COUNTRYCountry Key LAND1CHAR3T005LAND1LND
WRK_NAME1Name 1 AD_NAME1CHAR40TEXT40
WRK_NAME2Name 2 AD_NAME2CHAR40TEXT40
WRK_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
WRK_STREETStreet and House Number PAD_STRASCHAR60PAD_STRAS
WRK_HOUSEHouse Number AD_HSNM1CHAR10TEXT10
WRK_ROOMRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
WRK_POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
WRK_POSTPost office PPL_POST_OFFICECHAR40TEXT40CITY_NAME
WRK_COUNTRYCountry Key LAND1CHAR3T005LAND1LND
WRK_BEGStart Time BEGUZTIMS6UZEIT
WRK_ENDEnd Time ENDUZTIMS6UZEIT
JOB_POSJob position PPL_JOBCHAR40TEXT40
EMPCTEmployment percentage EMPCTDEC5(2) BSGRD
BREAK_TIMEUnpaid Break Period PDUNBDEC4(2) DEC2_2
BREAK_BEGStart of Break PDBEGTIMS6UZEIT
BREAK_ENDEnd of Break PDENDTIMS6UZEIT
CURR_CODECurrency Key WAERSCUKY5TCURCWAERSFWS
LGA01Wage Type LGARTCHAR4T512ZLGART
BET01Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ01Number ANZHLDEC7(2) ANZHL
EIN01Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK01Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA02Wage Type LGARTCHAR4T512ZLGART
BET02Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ02Number ANZHLDEC7(2) ANZHL
EIN02Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK02Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA03Wage Type LGARTCHAR4T512ZLGART
BET03Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ03Number ANZHLDEC7(2) ANZHL
EIN03Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK03Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA04Wage Type LGARTCHAR4T512ZLGART
BET04Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ04Number ANZHLDEC7(2) ANZHL
EIN04Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK04Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA05Wage Type LGARTCHAR4T512ZLGART
BET05Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ05Number ANZHLDEC7(2) ANZHL
EIN05Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK05Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA06Wage Type LGARTCHAR4T512ZLGART
BET06Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ06Number ANZHLDEC7(2) ANZHL
EIN06Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK06Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA07Wage Type LGARTCHAR4T512ZLGART
BET07Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ07Number ANZHLDEC7(2) ANZHL
EIN07Time/Measurement Unit PT_ZEINHCHAR3T538ARPMSH
OPK07Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA08Wage Type LGARTCHAR4T512ZLGART
BET08Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ08Number ANZHLDEC7(2) ANZHL
EIN08Time/Measurement Unit PT_ZEINHCHAR3Assigned to domainRPMSH
OPK08Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA09Wage Type LGARTCHAR4T512ZLGART
BET09Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ09Number ANZHLDEC7(2) ANZHL
EIN09Time/Measurement Unit PT_ZEINHCHAR3Assigned to domainRPMSH
OPK09Operation Indicator for Wage Types OPKENCHAR1OPKEN
LGA10Wage Type LGARTCHAR4T512ZLGART
BET10Wage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
ANZ10Number ANZHLDEC7(2) ANZHL
EIN10Time/Measurement Unit PT_ZEINHCHAR3Assigned to domainRPMSH
OPK10Operation Indicator for Wage Types OPKENCHAR1OPKEN
CNTDTDate of contract PPL_CNTDTDATS8DATS
CNANNDate of contract annexe PPL_CNANNDATS8DATS

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0859
INTO CORRESPONDING FIELDS OF WA_PA0859
WHERE...

How to access SAP table PA0859

Within an ECC or HANA version of SAP you can also view further information about PA0859 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!