PA0538 SAP (HR Master Record: Infotype 0538) Table details

Dictionary Type: Table
Description: HR Master Record: Infotype 0538




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




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

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

The PA0538 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0538 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 PA0538 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
SEPDTSeparation date PKR_SEPDTDATS8DATUM
CRPAYCorrection Pay PKR_CRPAYCURR11(2) WERT11
ADPAYAdditional pay PKR_ADPAYCURR11(2) WERT11
EXPAYExtra pay PKR_EXPAYCURR11(2) WERT11
NAPPRNational pension separation pay convertible amount PKR_NAPPRCURR11(2) WERT11
HPY00Honorary separation pay PKR_HPY00CURR11(2) WERT11
IPY00Insurance separation pay PKR_IPY00CURR11(2) WERT11
SVRPRService period in previous companies PKR_SVRPRNUMC3NUM3
DUPPRDuplicated service period in previous company PKR_DUPPRNUMC3NUM3
CURR1Currency Key WAERSCUKY5Assigned to domainWAERSFWS
BUS01Previous Company / Taxpayer Association Business Number PKR_BIZNOCHAR12T7KRP0PKR_BIZNO
SPY01Previous separation pay PKR_SPY01CURR11(2) WERT11
HPY01Previous honorary separation pay PKR_HPY01CURR11(2) WERT11
IPY01Previous insurance separation pay PKR_IPY01CURR11(2) WERT11
INT01Income tax paid in the previous company PKR_INT01CURR9(2) WERT05
RET01Resident tax paid in the previous company PKR_RET01CURR9(2) WERT05
SET01Previous special tax PKR_SET01CURR11(2) WERT11
EDT01Entry date of previous company PKR_EDT01DATS8DATUM
LDT01Previous company leave date PKR_LDT01DATS8DATUM
BUS02Previous Company / Taxpayer Association Business Number PKR_BIZNOCHAR12T7KRP0PKR_BIZNO
SPY02Previous separation pay PKR_SPY01CURR11(2) WERT11
HPY02Previous honorary separation pay PKR_HPY01CURR11(2) WERT11
IPY02Previous insurance separation pay PKR_IPY01CURR11(2) WERT11
INT02Income tax paid in the previous company PKR_INT01CURR9(2) WERT05
RET02Resident tax paid in the previous company PKR_RET01CURR9(2) WERT05
SET02Previous special tax PKR_SET01CURR11(2) WERT11
EDT02Entry date of previous company PKR_EDT01DATS8DATUM
LDT02Previous company leave date PKR_LDT01DATS8DATUM
CURR2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
UWDATDate of Bank Transfer UWDATDATS8DATUM
VALDTValuation Date of Monthly Average Income for Separation Pay PKR_VALDTDATS8DATUM
OVSCTTax Credit for Oversea PKR_OVSCTCURR9(2) WERT05
AGPDTAgreed Payment Date in case of Mid-separation PKR_AGPDTDATS8DATUM
TXEMPExemption of Calculated Separation Tax PKR_TXEMPCHAR1CHAR1
EXMLSExcluded Months for Legal Separation Payment PKR_EXMLSNUMC3NUM3
EXMHOExcluded Months for Total Separation Payment PKR_EXMHONUMC3NUM3
EXMPCExcluded Months for Previous Company PKR_EXMPCNUMC3NUM3
OSCHOTax Credit for Oversea Honorable PKR_OSCHOCURR9(2) WERT05
TEP01Tax Exemption in Previous Separation Payment PKR_TXEPRCHAR1CHAR1
TEP02Tax Exemption in Previous Separation Payment PKR_TXEPRCHAR1CHAR1
RETIDRetirement Reason PKR_RETIDCHAR2T7KR38PKR_RETID
PSPADAdjusted Previous Service Period PKR_PSPADNUMC3NUM3
DUPADAdjusted Duplicated Service Period PKR_DUPADNUMC3NUM3
OLYHOOnly Honorary Payment without Legal Separation Pay PKR_OLYHOCHAR1CHAR1
DISPSEnable Editing Previous Service Period PKR_DISPSCHAR1CHAR1
DISDMEnable Editing Month Number of Duplicated Period PKR_DISDMCHAR1CHAR1
ADJSTInfotype Subtype PKR_ADJSTCHAR1PKR_ADJST
IRABNBusiness Number of Individual Retirement Account Institution PKR_IRABNCHAR13RGBZNPKR_RGBZN
IRANMName of Individual Retirement Account Institution PKR_IRANMCHAR30TEXT30
DEPACAccount Number for IRP Contribution PKR_DEPACCHAR18BANKNPKR_BANKN
DEPAMContribution Amount PKR_DEPAMCURR11(2) WERT11
DEPCUDeposit Amount Currency Key PKR_DEPCUCUKY5Assigned to domainWAERS
DEPDTDate for Contribution Transfer PKR_DEPDTDATS8DATUM
OSPDTOriginal Separation Pay Date PKR_OSPDTDATS8DATUM
DPA01Contribution Amount PKR_DEPAMCURR11(2) WERT11
DPA02Contribution Amount PKR_DEPAMCURR11(2) WERT11
SENEXSenior Executive PKR_SENEXCHAR1CHAR1
EXSEPExcluded Separation Payment PKR_MDSEPCURR11(2) WERT11
ADDPCAdded Months for Previous Company PKR_ADDPCNUMC3NUM3
REPAMLump Sum Amount of Retirement Pension PKR_REPAMCURR11(2) WERT11
REPACAccount Number for Retirement Pension PKR_REPACCHAR18BANKN
PAYRPApplicable to Retirement Pension PKR_PAYRPCHAR1CHAR1
PRAINSum of Principle and Interest PKR_PRAINCURR11(2) WERT11
INCMSInclude Mid-Separation PKR_INCMSCHAR1CHAR1
PRPDTParticipation Date of DB Retirement Pension PKR_PRPDTDATS8DATUM
EXMBFExcluded Months Before 2013 PKR_EXMBFNUMC3NUM3
EXMAFExcluded Months After 2013 PKR_EXMAFNUMC3NUM3
ADDAFAdded Months After 2013 PKR_ADDAFNUMC3NUM3

Key field Non-key field



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

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

SELECT SINGLE *
FROM PA0538
INTO CORRESPONDING FIELDS OF WA_PA0538
WHERE...

How to access SAP table PA0538

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