PA0526 SAP (HR Master Record: Infotype 0526) Table details
Dictionary Type: Table
Description: HR Master Record: Infotype 0526
Description: HR Master Record: Infotype 0526
Table field list including key, data, relationships and ABAP select examples
PA0526 is a standard SAP Table which is used to store HR Master Record: Infotype 0526 data and is available within R/3 SAP systems depending on the version and release level.
The PA0526 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0526 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 PA0526 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 | ||||
SART0 | ELDA Record Type (Electronic Data Transfer) | PB03_SART0 | CHAR | 4 | SUBTY | ||||
VENT0 | Continued Payment of Full Remuneration Until | PB03_VENT0 | DATS | 8 | DATS | ||||
STATU | Status Information for ELDA | PB03_STATU | CHAR | 1 | PB03_STATU | ||||
DGNR0 | Contribution Account Number | PB03_DGNR0 | CHAR | 10 | TEXT10 | ||||
DGNA0 | Employer's Name | PB03_DGNA0 | CHAR | 70 | TEXT70 | ||||
DTEL0 | Employer's Telephone Number | PB03_DTEL1 | CHAR | 50 | TEXT50 | ||||
ASVGR | SI group | ASVGR | CHAR | 1 | Assigned to domain | ASVGR | |||
AUSVA | Social Insurance Body | AUSVA | CHAR | 2 | Assigned to domain | AUSVA | |||
AUSVL | 1st Part of SI Number (Sequential Number) | AUSVL | NUMC | 4 | NUM4 | ||||
AUSVG | 2nd Part of SI Number (Birth Date) | AUSVG | NUMC | 8 | NUM8 | ||||
GEBD0 | Date of Birth | GBDAT | DATS | 8 | PDATE | GBDAT | |||
FANA0 | Family Name | PB03_FANA0 | CHAR | 35 | TEXT35 | ||||
VONA0 | First name | PB03_VONA0 | CHAR | 42 | TEXT42 | ||||
AKGR0 | Title | TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
WKFZ0 | City of Residence, International License Plate Number | PB03_WKFZ0 | CHAR | 3 | LANDK | ||||
PLZL0 | City of Residence, Postal Code | PB03_PLZL0 | CHAR | 7 | TEXT7 | ||||
WORT0 | City of Residence, City | PB03_WORT0 | CHAR | 20 | TEXT20 | ||||
STRA0 | City of Residence, Street | PB03_STRA0 | CHAR | 30 | TEXT30 | ||||
BEAB0 | Employed Since (Last Legally Defined Entry) | PB03_BEAB0 | DATS | 8 | DATS | ||||
KABE0 | Type of Employment (Worker, Salaried Employee) | PB03_KABE0 | CHAR | 1 | |||||
TAET0 | Job | PB03_TAET0 | CHAR | 30 | TEXT30 | ||||
BTAG0 | Employment Days per Week | PB03_BTAG0 | NUMC | 1 | NUM1 | ||||
TATU0 | Work Day Rotation | PB03_TATU0 | NUMC | 1 | NUM1 | ||||
LTAG0 | Last Working Day | PB03_LTAG0 | DATS | 8 | DATS | ||||
GRUN0 | Reason for Cessation of Work | PB03_GRUN0 | CHAR | 30 | TEXT30 | ||||
KZKU0 | Indicator for Illness/Accident, Work Accident/Illness | PB03_KZKU0 | NUMC | 1 | PB03_KZKU0 | ||||
ARFT0 | Vector of Days Off per Week | ARFTG | CHAR | 7 | TEXT7 | ||||
ARTX0 | Rule for Working Days | ARFTX | CHAR | 25 | TEXT25 | ||||
BLOE0 | Work Relationship Terminated | PB03_BLOE0 | CHAR | 1 | XFELD | ||||
EBSV0 | End of Work Relationship | PB03_EBSV0 | DATS | 8 | DATS | ||||
BKTN0 | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BBLZ0 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BENT0 | Tips or Commissions Contained in Gross Remuneration | PB03_BENT0 | NUMC | 1 | PB03_BENT0 | ||||
BVO10 | Payment From | PB03_BVO10 | DATS | 8 | DATS | ||||
BBI10 | Payment To | PB03_BBI10 | DATS | 8 | DATS | ||||
BBE10 | Payment Amount | PB03_BBE10 | CURR | 9(2) | WERTV5 | ||||
BVO20 | Payment From | PB03_BVO10 | DATS | 8 | DATS | ||||
BBI20 | Payment To | PB03_BBI10 | DATS | 8 | DATS | ||||
BBE20 | Payment Amount | PB03_BBE10 | CURR | 9(2) | WERTV5 | ||||
BVO30 | Payment From | PB03_BVO10 | DATS | 8 | DATS | ||||
BBI30 | Payment To | PB03_BBI10 | DATS | 8 | DATS | ||||
BBE30 | Payment Amount | PB03_BBE10 | CURR | 9(2) | WERTV5 | ||||
BVO40 | Payment From | PB03_BVO10 | DATS | 8 | DATS | ||||
BBI40 | Payment To | PB03_BBI10 | DATS | 8 | DATS | ||||
BBE40 | Payment Amount | PB03_BBE10 | CURR | 9(2) | WERTV5 | ||||
BSUM0 | Total | PB03_BSUM0 | CURR | 9(2) | WERTV5 | ||||
SZKZ0 | Entitlement to Special Payment | PB03_SZKZ0 | CHAR | 1 | XFELD | ||||
SBTW0 | No. of Days with Payment in Kind per Week | PB03_SBTW0 | NUMC | 1 | NUM1 | ||||
SBZT0 | Payments in Kind (Provide Exact Types and Amounts) | PB03_SBTZ0 | CHAR | 24 | TEXT24 | ||||
KEAB0 | Pay in Lieu of Notice From | PB03_KEAB0 | DATS | 8 | DATS | ||||
KEBI0 | Pay in Lieu of Notice To | PB03_KEBI0 | DATS | 8 | DATS | ||||
UAAB0 | Payment in Lieu of Unused Leave, From | PB03_UAAB0 | DATS | 8 | DATS | ||||
UABI0 | Payment in Lieu of Unused Leave, To | PB03_UABI0 | DATS | 8 | DATS | ||||
AEFZ0 | Contd Pay Entitlement in Weeks | PB03_AEFZ0 | NUMC | 2 | NUM2 | ||||
JAGU0 | Entitlement Calc. Acc. to Working Year or Calendar Year | PB03_JAGU0 | NUMC | 1 | PB03_JAGU0 | ||||
TAGU0 | Calc. Cont. Pay Entitl. Acc. to Working Days, Calendar Days | PB03_TAGU0 | NUMC | 1 | PB03_TAGU0 | ||||
TPR10 | Partial Remuneration: Percentage of Total Pay | PB03_TPR10 | NUMC | 2 | NUM2 | ||||
TVO10 | Partial Remuneration From | PB03_TVO10 | DATS | 8 | DATS | ||||
TBI10 | Partial Remuneration To | PB03_TBI10 | DATS | 8 | DATS | ||||
TPR20 | Partial Remuneration: Percentage of Total Pay | PB03_TPR10 | NUMC | 2 | NUM2 | ||||
TVO20 | Partial Remuneration From | PB03_TVO10 | DATS | 8 | DATS | ||||
TBI20 | Partial Remuneration To | PB03_TBI10 | DATS | 8 | DATS | ||||
PROV0 | Commision During Incapacity to Work | PB03_PROV0 | CHAR | 1 | P03_PROV0 | ||||
ANV10 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB10 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
ANV20 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB20 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
ANV30 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB30 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
ANV40 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB40 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
AGRD0 | Deregistration Reason: Code | PB03_AGRD1 | CHAR | 2 | PB03_AGRD1 | ||||
URLV0 | Leave Prior to Maternity Leave: From | PB03_URLV0 | DATS | 8 | DATS | ||||
URLB0 | Leave Prior to Maternity Leave: To | PB03_URLB0 | DATS | 8 | DATS | ||||
AVER0 | Earned Income in Last Three Calendar Months | PB03_AVER1 | CURR | 9(2) | WERTV5 | ||||
AVON0 | Earned Income - Period From | PB03_AVON0 | DATS | 8 | DATS | ||||
ABIS0 | Earned Income - Period To | PB03_ABIS0 | DATS | 8 | DATS | ||||
UNV10 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB10 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV20 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB20 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV30 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB30 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV40 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB40 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
SZMO0 | Not used | NUMCNUSED2 | NUMC | 2 | NUMC2 | ||||
SZWO0 | Not used | NUMCNUSED2 | NUMC | 2 | NUMC2 | ||||
ANGV0 | Entitlement to Continued Pay | PB03_ANGV0 | CHAR | 1 | PB03_ANGV0 | ||||
AHEB0 | Entitlement to Half Pay Until | PB03_AHEB0 | DATS | 8 | DATS | ||||
AMEB0 | Entitlement to More Than Half Pay Until | PB03_AMEB0 | DATS | 8 | DATS | ||||
WAHR0 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ANV50 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB50 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
ANV60 | Count Previous Illness - From | PB03_ANV10 | DATS | 8 | DATS | ||||
ANB60 | Count Previous Illness - To | PB03_ANB10 | DATS | 8 | DATS | ||||
AGRD2 | Deregistration Reason: Code | PB03_AGRD2 | CHAR | 2 | PB03_AGRD2 | ||||
VOAB0 | Period of Previous Employment - From | P03_VOAB0 | DATS | 8 | DATS | ||||
VOBI0 | Period of Previous Employment - To | P03_VOBI0 | DATS | 8 | DATS | ||||
FEAB0 | Voluntary Remuneration Paid - From | P03_FEAB0 | DATS | 8 | DATS | ||||
FEBI0 | Voluntary Remuneration Paid - To | P03_FEBI0 | DATS | 8 | DATS | ||||
EIN10 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
EIN20 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
EIN30 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
EIN40 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
EIN50 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
EIN60 | Orientation Day | P03_EIN10 | DATS | 8 | DATS | ||||
SZMO1 | Extent of Special Payment in Monthly Pay | PB03_SZMO0 | DEC | 4(2) | DEC2_2 | ||||
SZWO1 | Extent of Special Payment in Weekly Pay | PB03_SZWO0 | DEC | 4(2) | DEC2_2 | ||||
SBZW0 | Payment in Kind: Extension During Payment of Maternity Pay | P03_SBZW0 | CHAR | 1 | XFELD | ||||
SBZE0 | Payment in Kind Included in Earned Income | P03_SBZE0 | CHAR | 1 | XFELD | ||||
PRAB0 | Entry Date into Civil Service | P03_PRAB0 | DATS | 8 | DATS | ||||
UNV50 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB50 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV60 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB60 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV70 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB70 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
UNV80 | Suspension of Pay From | PB03_UNV10 | DATS | 8 | DATS | ||||
UNB80 | Suspension of Pay To | PB03_UNB10 | DATS | 8 | DATS | ||||
AVER2 | Earned Income for Freelance Employees (Gross) | PB03_AVER2 | CURR | 9(2) | WERTV5 | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
TITL2 | Second Title | TITL2 | CHAR | 15 | Assigned to domain | TITEL | |||
SBGB0 | Checkbox: Monetary Remuneration Includes Payment in Kind | PB03_SBGB0 | CHAR | 1 | XFELD | ||||
LABTG0 | Last Working Day - If WR Continues | PB03_LABTG0 | DATS | 8 | DATS | ||||
PLZL1 | City of Residence, Postal Code | PB03_PLZL1 | CHAR | 9 | TEXT9 | ||||
WORT1 | City of Residence, City | PB03_WORT1 | CHAR | 40 | TEXT40 | ||||
STRA1 | City of Residence, Street | PB03_STRA1 | CHAR | 50 | TEXT50 |
Key field | Non-key field |
How do I retrieve data from SAP table PA0526 using ABAP code
The following ABAP code Example will allow you to do a basic selection on PA0526 to SELECT all data from the tableDATA: WA_PA0526 TYPE PA0526.
SELECT SINGLE *
FROM PA0526
INTO CORRESPONDING FIELDS OF WA_PA0526
WHERE...
How to access SAP table PA0526
Within an ECC or HANA version of SAP you can also view further information about PA0526 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