PA0508 SAP (HR-AU-PS: Master Data For Prior Service) Table details

Dictionary Type: Table
Description: HR-AU-PS: Master Data For Prior Service




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




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

PA0508 is a standard SAP Table which is used to store HR-AU-PS: Master Data For Prior Service data and is available within R/3 SAP systems depending on the version and release level.

The PA0508 table consists of various fields, each holding specific information or linking keys about HR-AU-PS: Master Data For Prior Service 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 PA0508 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
AGENTName of agent for the last service PAU_AGENTCHAR30CHAR30
DEPTSDepartment PAU_DEPTSCHAR20CHAR20
FPFLGFull or part time flag PAU_FPFLGCHAR1PAU_PFTCT
HRPWKHours work per week PAU_HRPWKDEC5(2) DEC03_2
PERCTEmployment percentage PAU_PERCTDEC5(2) BF_PRZ32
CTLSLCount for LSL PAU_CTLSLCHAR1CHECKBOX
CTSKLCount for Sick Leave PAU_CTSKLCHAR1CHECKBOX
CTTERCount for termination PAU_CTTERCHAR1CHECKBOX
CTAFPCustomer Specific PAU_CTAFPCHAR1CHECKBOX
ACCDTAccrual anniversary date PAU_ACCDTDATS8DATS
ELGDTEligibility Date PAU_ELGDTDATS8DATS
BLVE1Leave type for Prior Service PAU_PSLVECHAR4Assigned to domainPAU_LCODE
BOBL1Leave taken in prior service in months PAU_PSMTHDEC8DEC8
BFLG1Opening balance flag ( Full / Part Time balance ) PAU_OBFLGCHAR1PAU_PFTCT
BLVE2Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BOBL2Leave taken in prior service in months PAU_PSMTHDEC8DEC8
BFLG2Opening balance flag ( Full / Part Time balance ) PAU_OBFLGCHAR1PAU_PFTCT
BLVE3Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BOBL3Leave taken in prior service in months PAU_PSMTHDEC8DEC8
BFLG3Opening balance flag ( Full / Part Time balance ) PAU_OBFLGCHAR1PAU_PFTCT
BLVE4Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BOBL4Leave taken in prior service in months PAU_PSMTHDEC8DEC8
BFLG4Opening balance flag ( Full / Part Time balance ) PAU_OBFLGCHAR1PAU_PFTCT
LVE01Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG01Begin Day of leave taken PAU_LVBEGDATS8DATUM
END01End date of leave taken PAU_LVENDDATS8DATUM
MTH01Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY01Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT01Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY01FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS01Not to count as service PAU_NTCASCHAR1CHAR1
LVE02Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG02Start Date BEGDADATS8DATUM
END02End Date ENDDADATS8DATUM
MTH02Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY02Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT02Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY02FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS02Not to count as service PAU_NTCASCHAR1CHAR1
LVE03Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG03Start Date BEGDADATS8DATUM
END03End Date ENDDADATS8DATUM
MTH03Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY03Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT03Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY03FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS03Not to count as service PAU_NTCASCHAR1CHAR1
LVE04Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG04Start Date BEGDADATS8DATUM
END04End Date ENDDADATS8DATUM
MTH04Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY04Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT04Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY04FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS04Not to count as service PAU_NTCASCHAR1CHAR1
LVE05Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG05Start Date BEGDADATS8DATUM
END05End Date ENDDADATS8DATUM
MTH05Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY05Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT05Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY05FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS05Not to count as service PAU_NTCASCHAR1CHAR1
LVE06Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG06Start Date BEGDADATS8DATUM
END06End Date ENDDADATS8DATUM
MTH06Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY06Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT06Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY06FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS06Not to count as service PAU_NTCASCHAR1CHAR1
LVE07Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG07Start Date BEGDADATS8DATUM
END07End Date ENDDADATS8DATUM
MTH07Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY07Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT07Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY07FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS07Not to count as service PAU_NTCASCHAR1CHAR1
LVE08Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG08Start Date BEGDADATS8DATUM
END08End Date ENDDADATS8DATUM
MTH08Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY08Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT08Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY08FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS08Not to count as service PAU_NTCASCHAR1CHAR1
LVE09Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG09Start Date BEGDADATS8DATUM
END09End Date ENDDADATS8DATUM
MTH09Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY09Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT09Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY09FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS09Not to count as service PAU_NTCASCHAR1CHAR1
LVE10Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG10Start Date BEGDADATS8DATUM
END10End Date ENDDADATS8DATUM
MTH10Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY10Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT10Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY10FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS10Not to count as service PAU_NTCASCHAR1CHAR1
LVE11Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG11Start Date BEGDADATS8DATUM
END11End Date ENDDADATS8DATUM
MTH11Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY11Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT11Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY11FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS11Not to count as service PAU_NTCASCHAR1CHAR1
LVE12Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG12Start Date BEGDADATS8DATUM
END12End Date ENDDADATS8DATUM
MTH12Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY12Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT12Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY12FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS12Not to count as service PAU_NTCASCHAR1CHAR1
LVE13Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG13Start Date BEGDADATS8DATUM
END13End Date ENDDADATS8DATUM
MTH13Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY13Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT13Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY13FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS13Not to count as service PAU_NTCASCHAR1CHAR1
LVE14Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG14Start Date BEGDADATS8DATUM
END14End Date ENDDADATS8DATUM
MTH14Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY14Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT14Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY14FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS14Not to count as service PAU_NTCASCHAR1CHAR1
LVE15Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG15Start Date BEGDADATS8DATUM
END15End Date ENDDADATS8DATUM
MTH15Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY15Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT15Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY15FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS15Not to count as service PAU_NTCASCHAR1CHAR1
LVE16Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG16Start Date BEGDADATS8DATUM
END16End Date ENDDADATS8DATUM
MTH16Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY16Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT16Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY16FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS16Not to count as service PAU_NTCASCHAR1CHAR1
LVE17Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG17Start Date BEGDADATS8DATUM
END17End Date ENDDADATS8DATUM
MTH17Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY17Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT17Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY17FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS17Not to count as service PAU_NTCASCHAR1CHAR1
LVE18Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG18Start Date BEGDADATS8DATUM
END18End Date ENDDADATS8DATUM
MTH18Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY18Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT18Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY18FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS18Not to count as service PAU_NTCASCHAR1CHAR1
LVE19Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG19Start Date BEGDADATS8DATUM
END19End Date ENDDADATS8DATUM
MTH19Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY19Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT19Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY19FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS19Not to count as service PAU_NTCASCHAR1CHAR1
LVE20Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG20Start Date BEGDADATS8DATUM
END20End Date ENDDADATS8DATUM
MTH20Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY20Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT20Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY20FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS20Not to count as service PAU_NTCASCHAR1CHAR1
LVE21Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG21Start Date BEGDADATS8DATUM
END21End Date ENDDADATS8DATUM
MTH21Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY21Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT21Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY21FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS21Not to count as service PAU_NTCASCHAR1CHAR1
LVE22Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG22Start Date BEGDADATS8DATUM
END22End Date ENDDADATS8DATUM
MTH22Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY22Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT22Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY22FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS22Not to count as service PAU_NTCASCHAR1CHAR1
LVE23Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG23Start Date BEGDADATS8DATUM
END23End Date ENDDADATS8DATUM
MTH23Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY23Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT23Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY23FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS23Not to count as service PAU_NTCASCHAR1CHAR1
LVE24Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG24Start Date BEGDADATS8DATUM
END24End Date ENDDADATS8DATUM
MTH24Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY24Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT24Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY24FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS24Not to count as service PAU_NTCASCHAR1CHAR1
LVE25Leave type for Prior Service PAU_PSLVECHAR4T5QPBS2CPAU_LCODE
BEG25Start Date BEGDADATS8DATUM
END25End Date ENDDADATS8DATUM
MTH25Leave taken in prior service in months PAU_PSMTHDEC8DEC8
DAY25Leave taken in prior service in days PAU_PSDAYDEC5(2) DEC3_2
PFT25Leave taken in Part or Full time counter PAU_PFTCTCHAR1CHECKBOX
PAY25FULL OR HALF PAY COUNTER PAU_PAYCTCHAR1CHECKBOX
CAS25Not to count as service PAU_NTCASCHAR1CHAR1

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0508
INTO CORRESPONDING FIELDS OF WA_PA0508
WHERE...

How to access SAP table PA0508

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