PA0538 SAP (HR Master Record: Infotype 0538) Table details
Dictionary Type: Table
Description: HR Master Record: Infotype 0538
Description: HR Master Record: Infotype 0538
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PERNR | Personnel number | PERSNO | NUMC | 8 | PA0003 | PERSNO | PER | ||
SUBTY | Subtype | SUBTY | CHAR | 4 | SUBTY | SUB | |||
OBJPS | Object Identification | OBJPS | CHAR | 2 | OBJPS | OPS | |||
SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | SPRPS | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
AEDTM | Changed On | AEDAT | DATS | 8 | DATUM | ||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
HISTO | Historical Record Flag | HISTO | CHAR | 1 | CHAR1 | ||||
ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | XFELD | ||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | XFELD | ||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | XFELD | ||||
ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | CHAR2 | ||||
PREAS | Reason for Changing Master Data | PREAS | CHAR | 2 | T530E | PREAS | |||
FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | NUSED2 | ||||
RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | NUSED2 | ||||
GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | PCCE_GPVAL | ||||
SEPDT | Separation date | PKR_SEPDT | DATS | 8 | DATUM | ||||
CRPAY | Correction Pay | PKR_CRPAY | CURR | 11(2) | WERT11 | ||||
ADPAY | Additional pay | PKR_ADPAY | CURR | 11(2) | WERT11 | ||||
EXPAY | Extra pay | PKR_EXPAY | CURR | 11(2) | WERT11 | ||||
NAPPR | National pension separation pay convertible amount | PKR_NAPPR | CURR | 11(2) | WERT11 | ||||
HPY00 | Honorary separation pay | PKR_HPY00 | CURR | 11(2) | WERT11 | ||||
IPY00 | Insurance separation pay | PKR_IPY00 | CURR | 11(2) | WERT11 | ||||
SVRPR | Service period in previous companies | PKR_SVRPR | NUMC | 3 | NUM3 | ||||
DUPPR | Duplicated service period in previous company | PKR_DUPPR | NUMC | 3 | NUM3 | ||||
CURR1 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
BUS01 | Previous Company / Taxpayer Association Business Number | PKR_BIZNO | CHAR | 12 | T7KRP0 | PKR_BIZNO | |||
SPY01 | Previous separation pay | PKR_SPY01 | CURR | 11(2) | WERT11 | ||||
HPY01 | Previous honorary separation pay | PKR_HPY01 | CURR | 11(2) | WERT11 | ||||
IPY01 | Previous insurance separation pay | PKR_IPY01 | CURR | 11(2) | WERT11 | ||||
INT01 | Income tax paid in the previous company | PKR_INT01 | CURR | 9(2) | WERT05 | ||||
RET01 | Resident tax paid in the previous company | PKR_RET01 | CURR | 9(2) | WERT05 | ||||
SET01 | Previous special tax | PKR_SET01 | CURR | 11(2) | WERT11 | ||||
EDT01 | Entry date of previous company | PKR_EDT01 | DATS | 8 | DATUM | ||||
LDT01 | Previous company leave date | PKR_LDT01 | DATS | 8 | DATUM | ||||
BUS02 | Previous Company / Taxpayer Association Business Number | PKR_BIZNO | CHAR | 12 | T7KRP0 | PKR_BIZNO | |||
SPY02 | Previous separation pay | PKR_SPY01 | CURR | 11(2) | WERT11 | ||||
HPY02 | Previous honorary separation pay | PKR_HPY01 | CURR | 11(2) | WERT11 | ||||
IPY02 | Previous insurance separation pay | PKR_IPY01 | CURR | 11(2) | WERT11 | ||||
INT02 | Income tax paid in the previous company | PKR_INT01 | CURR | 9(2) | WERT05 | ||||
RET02 | Resident tax paid in the previous company | PKR_RET01 | CURR | 9(2) | WERT05 | ||||
SET02 | Previous special tax | PKR_SET01 | CURR | 11(2) | WERT11 | ||||
EDT02 | Entry date of previous company | PKR_EDT01 | DATS | 8 | DATUM | ||||
LDT02 | Previous company leave date | PKR_LDT01 | DATS | 8 | DATUM | ||||
CURR2 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
UWDAT | Date of Bank Transfer | UWDAT | DATS | 8 | DATUM | ||||
VALDT | Valuation Date of Monthly Average Income for Separation Pay | PKR_VALDT | DATS | 8 | DATUM | ||||
OVSCT | Tax Credit for Oversea | PKR_OVSCT | CURR | 9(2) | WERT05 | ||||
AGPDT | Agreed Payment Date in case of Mid-separation | PKR_AGPDT | DATS | 8 | DATUM | ||||
TXEMP | Exemption of Calculated Separation Tax | PKR_TXEMP | CHAR | 1 | CHAR1 | ||||
EXMLS | Excluded Months for Legal Separation Payment | PKR_EXMLS | NUMC | 3 | NUM3 | ||||
EXMHO | Excluded Months for Total Separation Payment | PKR_EXMHO | NUMC | 3 | NUM3 | ||||
EXMPC | Excluded Months for Previous Company | PKR_EXMPC | NUMC | 3 | NUM3 | ||||
OSCHO | Tax Credit for Oversea Honorable | PKR_OSCHO | CURR | 9(2) | WERT05 | ||||
TEP01 | Tax Exemption in Previous Separation Payment | PKR_TXEPR | CHAR | 1 | CHAR1 | ||||
TEP02 | Tax Exemption in Previous Separation Payment | PKR_TXEPR | CHAR | 1 | CHAR1 | ||||
RETID | Retirement Reason | PKR_RETID | CHAR | 2 | T7KR38 | PKR_RETID | |||
PSPAD | Adjusted Previous Service Period | PKR_PSPAD | NUMC | 3 | NUM3 | ||||
DUPAD | Adjusted Duplicated Service Period | PKR_DUPAD | NUMC | 3 | NUM3 | ||||
OLYHO | Only Honorary Payment without Legal Separation Pay | PKR_OLYHO | CHAR | 1 | CHAR1 | ||||
DISPS | Enable Editing Previous Service Period | PKR_DISPS | CHAR | 1 | CHAR1 | ||||
DISDM | Enable Editing Month Number of Duplicated Period | PKR_DISDM | CHAR | 1 | CHAR1 | ||||
ADJST | Infotype Subtype | PKR_ADJST | CHAR | 1 | PKR_ADJST | ||||
IRABN | Business Number of Individual Retirement Account Institution | PKR_IRABN | CHAR | 13 | RGBZN | PKR_RGBZN | |||
IRANM | Name of Individual Retirement Account Institution | PKR_IRANM | CHAR | 30 | TEXT30 | ||||
DEPAC | Account Number for IRP Contribution | PKR_DEPAC | CHAR | 18 | BANKN | PKR_BANKN | |||
DEPAM | Contribution Amount | PKR_DEPAM | CURR | 11(2) | WERT11 | ||||
DEPCU | Deposit Amount Currency Key | PKR_DEPCU | CUKY | 5 | Assigned to domain | WAERS | |||
DEPDT | Date for Contribution Transfer | PKR_DEPDT | DATS | 8 | DATUM | ||||
OSPDT | Original Separation Pay Date | PKR_OSPDT | DATS | 8 | DATUM | ||||
DPA01 | Contribution Amount | PKR_DEPAM | CURR | 11(2) | WERT11 | ||||
DPA02 | Contribution Amount | PKR_DEPAM | CURR | 11(2) | WERT11 | ||||
SENEX | Senior Executive | PKR_SENEX | CHAR | 1 | CHAR1 | ||||
EXSEP | Excluded Separation Payment | PKR_MDSEP | CURR | 11(2) | WERT11 | ||||
ADDPC | Added Months for Previous Company | PKR_ADDPC | NUMC | 3 | NUM3 | ||||
REPAM | Lump Sum Amount of Retirement Pension | PKR_REPAM | CURR | 11(2) | WERT11 | ||||
REPAC | Account Number for Retirement Pension | PKR_REPAC | CHAR | 18 | BANKN | ||||
PAYRP | Applicable to Retirement Pension | PKR_PAYRP | CHAR | 1 | CHAR1 | ||||
PRAIN | Sum of Principle and Interest | PKR_PRAIN | CURR | 11(2) | WERT11 | ||||
INCMS | Include Mid-Separation | PKR_INCMS | CHAR | 1 | CHAR1 | ||||
PRPDT | Participation Date of DB Retirement Pension | PKR_PRPDT | DATS | 8 | DATUM | ||||
EXMBF | Excluded Months Before 2013 | PKR_EXMBF | NUMC | 3 | NUM3 | ||||
EXMAF | Excluded Months After 2013 | PKR_EXMAF | NUMC | 3 | NUM3 | ||||
ADDAF | Added Months After 2013 | PKR_ADDAF | NUMC | 3 | NUM3 |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects