PA0600 SAP (HR Master Data Record Infotype 0600) Table details

Dictionary Type: Table
Description: HR Master Data Record Infotype 0600




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




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

PA0600 is a standard SAP Table which is used to store HR Master Data Record Infotype 0600 data and is available within R/3 SAP systems depending on the version and release level.

The PA0600 table consists of various fields, each holding specific information or linking keys about HR Master Data Record Infotype 0600 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 PA0600 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
CONTRACT_TYPEEmployment Relationship P02_CONTRACT_TYPECHAR1P02_CONTRACT_TYPE
FULLTIMEFull-Time Employment P02_FULLTIMECHAR1XFELD
PARTTIMEPart-Time Employment P02_PARTTIMECHAR1XFELD
HOMEOFFICEHome Work Station Agreement P02_HOMEOFFICECHAR1XFELD
HELPWORKERTemporary Position P02_HELPWORKERCHAR1XFELD
SEASONALSeasonal Position P02_SEASONALCHAR1XFELD
APPRENTICEApprenticeship P02_APPRENTICECHAR1XFELD
WORKONCALLOn Call Work P02_WORKONCALLCHAR1XFELD
SHORTRUNTemporary Employment Relationship P02_SHORTRUNCHAR1XFELD
HIRE_DATEEntry Date P02_HIRE_DATEDATS8DATUM
FIRE_DATELeaving Date P02_FIRE_DATEDATS8DATUM
FUNUMSalary Comparison: Function number P02_FUNUMNUMC8T5C30P02_FUNUM
FUTXTSalary Comparison: Function Description P02_FUTXTCHAR40TEXT40
INVESTMENTAward P02_INVESTMENTCHAR1XFELD
WOSTDContract. Norm. Working Time P02_WOSTDDEC5(2) STDAZ
WRITTEN_CONTRACTWritten Employment Contract P02_WRITTEN_CONTRACTCHAR1XFELD
TERMINAT_BYNotice Given By P02_TERMINAT_BYCHAR1P02_TERMINAT_BY
TERMINAT_WHENNotice Date P02_TERMINAT_WHENDATS8DATUM
TERMINAT_ONNotice date P02_TERMINAT_ONDATS8DATUM
WRITTEN_TERMINATWritten Notice P02_WRITTEN_TERMINATCHAR1XFELD
NOTICE_PERIOD_EEDismissals notice period for employee P02_NOTICE_PERIOD_EECHAR2Assigned to domainKDGFR
NOTICE_PERIOD_ERDismissals notice period for employer P02_NOTICE_PERIOD_ERCHAR2Assigned to domainKDGFR
PREVENTIONPrevention P02_PREVENTIONCHAR1P02_PREVENTION
PREVENTED_FROMPrevented From P02_PREVENTED_FROMDATS8DATUM
PREVENTED_TOPrevented Until P02_PREVENTED_TODATS8DATUM
TERMINAT_REASON1Notice Reason P02_TERMINAT_REASON1CHAR60TEXT60
TERMINAT_REASON2Notice Reason P02_TERMINAT_REASON2CHAR80TEXT80
TERMINAT_REASON3Notice Reason P02_TERMINAT_REASON3CHAR80TEXT80
TERMINAT_REASON4Notice Reason P02_TERMINAT_REASON4CHAR80TEXT80
LAST_WORKED_DAYLast Working Day P02_LAST_WORKED_DAYDATS8DATUM
PAID_UNTILPaid Until P02_PAID_UNTILDATS8DATUM
PERIOD_FROM01Employment Period (From) P02_PERIOD_FROMDATS8DATS
PERIOD_TO01Employment Period (Until) P02_PERIOD_TODATS8DATS
PERIOD_WAGE01Wages Subject to AHV P02_AHV_WAGECURR15(2) PRBETRG
PERIOD_FROM02Employment Period (From) P02_PERIOD_FROMDATS8DATS
PERIOD_TO02Employment Period (Until) P02_PERIOD_TODATS8DATS
PERIOD_WAGE02Wages Subject to AHV P02_AHV_WAGECURR15(2) PRBETRG
PERIOD_FROM03Employment Period (From) P02_PERIOD_FROMDATS8DATS
PERIOD_TO03Employment Period (Until) P02_PERIOD_TODATS8DATS
PERIOD_WAGE03Wages Subject to AHV P02_AHV_WAGECURR15(2) PRBETRG
PERIOD_FROM04Employment Period (From) P02_PERIOD_FROMDATS8DATS
PERIOD_TO04Employment Period (Until) P02_PERIOD_TODATS8DATS
PERIOD_WAGE04Wages Subject to AHV P02_AHV_WAGECURR15(2) PRBETRG
MONTHLY_SALARYMonthly wage P02_MONTHLY_SALARYCURR15(2) PRBETRG
DATE_LAST_13SALDate of Last 13th Monthly Wage P02_DATE_LAST_13SALDATS8DATUM
LAST_13SALAmount of the Last 13th Monthly Wage P02_LAST_13SALCURR15(2) PRBETRG
DATE_LAST_BONUSDate of Last Gratuity P02_DATE_LAST_BONUSDATS8DATUM
LAST_BONUSLast Gratuity P02_LAST_BONUSCURR15(2) PRBETRG
HOURLY_SAL_BASISHourly Wage P02_HOURLY_SAL_BASISCURR15(2) PRBETRG
VACATIONHoliday Pay P02_VACATIONDEC5(2) P02_PERCENT
PUBLIC_HOLIDAYPublic Holiday Compensation P02_PUBLIC_HOLIDAYDEC5(2) P02_PERCENT
BONUS13 month's salary / gratuity P02_BONUS_PERCDEC5(2) P02_PERCENT
HOURLY_SAL_TOTALHourly Wage (Total) P02_HOURLY_SAL_TOTALCURR15(2) PRBETRG
ABSENCE_FROM_A01Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_A01Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_B01Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_B01Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_C01Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_C01Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_A02Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_A02Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_B02Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_B02Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_C02Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_C02Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_A03Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_A03Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_B03Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_B03Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_C03Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_C03Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_A04Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_A04Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_B04Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_B04Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_C04Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_C04Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_A05Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_A05Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_B05Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_B05Absence to P02_ABSENCE_TODATS8DATUM
ABSENCE_FROM_C05Absence from P02_ABSENCE_FROMDATS8DATUM
ABSENCE_TO_C05Absence to P02_ABSENCE_TODATS8DATUM
PENSIONPension P02_PENSIONCURR15(2) PRBETRG
ADDITIONAL_PAYMTAdditional Payments P02_ADDITIONAL_PAYMTCURR15(2) PRBETRG
CHILD_ALLWNCNumber Child Benefits P02_CHILD_ALLWNCNUMC2NUMC2
EDUCATION_ALLWNCNumber Training Bonuses P02_EDUCATION_ALLWNCNUMC2NUMC2
ALLWNC_PAID_BYBonuses paid out by P02_ALLWNC_PAID_BYCHAR1P02_ALLWNC_PAID_BY
COPY_TERMINATIONCopy of Notice Letter P02_COPY_TERMINATIONCHAR1XFELD
COPY_PAYSLIPCopy Payroll Accounting P02_COPY_PAYSLIPCHAR1XFELD
COPY_PENSIONCopy Additional Documents P02_COPY_PENSIONCHAR1XFELD
CURRENCYPayment Currency PAD_WAERSCUKY5Assigned to domainWAERSFWS
NO_PENSION_FUNDNot insured with a pension fund P02_NO_PENSION_FUNDCHAR1XFELD
PENSION_FUNDName of a Pension Fund P02_PENSION_FUND_NAMECHAR60TEXT60

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0600
INTO CORRESPONDING FIELDS OF WA_PA0600
WHERE...

How to access SAP table PA0600

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