PA0065 SAP (HR Master Record: Infotype 0065 (Tax - GB)) Table details
Dictionary Type: Table
Description: HR Master Record: Infotype 0065 (Tax - GB)
Description: HR Master Record: Infotype 0065 (Tax - GB)
Table field list including key, data, relationships and ABAP select examples
PA0065 is a standard SAP Table which is used to store HR Master Record: Infotype 0065 (Tax - GB) data and is available within R/3 SAP systems depending on the version and release level.
The PA0065 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0065 (Tax - GB) 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 PA0065 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 | T000 | 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 | ||||
TXNUM | Text number | TXNUM | NUMC | 5 | NUMC5 | ||||
TXLET | Tax indicator | TXLET | CHAR | 2 | CHAR2 | ||||
TXBAS | Tax basis | TXBAS | CHAR | 1 | P08_TXBAS | ||||
TXRFS | Tax refund indicator | TXRFS | CHAR | 1 | TXRFS | ||||
TXSTK | On strike indicator | TXSTK | CHAR | 1 | XFELD | ||||
P45PY | P45 taxable pay | P45PY | CURR | 9(2) | WERTV5 | ||||
P45TX | P45 tax paid | P45TX | CURR | 9(2) | WERTV5 | ||||
TXRFV | TXRFV | DEC | 11 | DEC11 | |||||
P45WK | P45 Tax week number | P45WK | NUMC | 2 | PABRP | ||||
P45MN | P45 Tax month number | P45MN | NUMC | 2 | PABRP | ||||
P45ID | P45 has been issued indicator | P45ID | CHAR | 1 | XFELD | ||||
P45DT | Date P45 issued | P45DT | DATS | 8 | DATUM | ||||
TDSRC | Source of tax code stored | TDSRC | CHAR | 3 | TDSRC | ||||
ITM12 | HR-GB: P45 Item 13 | P08_ITM12 | CURR | 9(2) | WERTV5 | ||||
P45CR | HR-GB: Correction Indicator for P45 Item 13 | P08_P45CR | CHAR | 1 | XFELD | ||||
TXREG | Regional code | P08_TXREG | CHAR | 1 | CHAR1 | ||||
TXNMB | Tax Number | P08_TXNMB | NUMC | 6 | NUMC6 | ||||
TXCOD | Tax Code | P08_TXCODE | CHAR | 8 | CHAR8 | ||||
GLBID | HR B2A: Global Object ID | PC_B2A_GLBID | CHAR | 32 | CHAR32 | ||||
P46ID | P46 has been issued indicator | P46ID | CHAR | 1 | XFELD | ||||
P46DT | Date P45(3) / P46 issued | P46DT | DATS | 8 | DATUM | ||||
P160ID | P46(PEN) has been issued indicator | P08_P160ID | CHAR | 1 | XFELD | ||||
P46CLS | HR GB: P46/P46(EXPAT) Class | P08_P46CLS | NUMC | 1 | P08_P46CLS | ||||
P453ID | P45(3) has been issued indicator | P08_P453ID | CHAR | 1 | XFELD | ||||
PFIRE | HR GB: Previous Employment Leaving Date | P08_PFIREDATE | DATS | 8 | DATUM | ||||
TDNUM | HR GB: Previous Employment Tax district number | P08_PTDNUM | CHAR | 3 | Assigned to domain | TDNUM | |||
TDREF | HR GB: Previous Employment Tax District Indicator | P08_PTDRCE | CHAR | 10 | Assigned to domain | TDRCE | |||
PENAMT | HR GB: Pension Amount Paid by employer Annually to Employee | P08_PENAMT | CURR | 15(2) | PRBETRG | ||||
PENWIDI | HR GB: Retiring on Pension Recently Bereaved Indicator | P08_PENWIDI | CHAR | 1 | XFELD | ||||
P453DT | P45(3) issued date | P08_P453DT | DATS | 8 | DATUM | ||||
P160DT | Date P46(PEN) is issued | P160DT | DATS | 8 | DATUM | ||||
NPUAPR | HR GB : No Pay Until April | P08_NPUAPR | CHAR | 1 | XFELD | ||||
PTXCOD | Tax Code | P08_TXCODE | CHAR | 8 | CHAR8 | ||||
PTXBAS | Previous Tax Basis | PTXBAS | CHAR | 1 | XFELD | ||||
DP45WK | P45 Tax week number (Previous tax year) | DP45WK | NUMC | 2 | PABRP | ||||
DP45MN | P45 Tax month number (Previous tax year) | DP45MN | NUMC | 2 | PABRP | ||||
DP45PY | P45 taxable pay (Previous tax year) | DP45PY | CURR | 9(2) | WERTV5 | ||||
DP45TX | P45 tax paid (Previous tax year) | DP45TX | CURR | 9(2) | WERTV5 | ||||
PP45WK | P46(PEN) tax week number | PP45WK | NUMC | 2 | PABRP | ||||
PP45MN | P46 (PEN)Tax month number | PP45MN | NUMC | 2 | PABRP | ||||
PP45PY | P46 (PEN) taxable pay | PP45PY | CURR | 9(2) | WERTV5 | ||||
PP45TX | P46 (PEN) tax paid | PP45TX | CURR | 9(2) | WERTV5 | ||||
PPFIRE | HR GB: Previous Employment Leaving Date - P46(PEN) | PPFIRE | DATS | 8 | DATUM | ||||
PTDNUM | HR GB: Previous Employment Tax district number P46 (PEN) | PTDNUM | CHAR | 3 | Assigned to domain | TDNUM | |||
PTDREF | HR GB: Previous Employment Tax District Indicator P46 (PEN) | PTDREF | CHAR | 10 | Assigned to domain | TDRCE | |||
PPTXCOD | Previous tax code - P46PEN | P08_PPTXC | CHAR | 8 | CHAR8 | ||||
PPTXBAS | Previous Tax Basis P46PEN | P08_PPTXB | CHAR | 1 | XFELD | ||||
EMPPEN | Employer to Pensioner flag | EMPPEN | CHAR | 1 | XFELD | ||||
P46EDT | Date P46(EXPAT) issued | P08_P46EDT | DATS | 8 | DATUM | ||||
P46EID | P46(EXPAT) has been issued indicator | P08_P46EID | CHAR | 1 | XFELD | ||||
IYMV_PID | HR B2A: Global Object ID | PC_B2A_GLBID | CHAR | 32 | CHAR32 | ||||
WRKNO | HR GB: HMRC Works Number | P08_WRKSN | NUMC | 10 | NUMC10 | ||||
WRKNO_REHIRE_IND | Rehire Indicator for Worknumber (HMRC) | P08_WRK_RHIRE_IND | CHAR | 2 | P08_WRK_RHIRE_INDP08_WRK_RHIRE |
Key field | Non-key field |
How do I retrieve data from SAP table PA0065 using ABAP code
The following ABAP code Example will allow you to do a basic selection on PA0065 to SELECT all data from the tableDATA: WA_PA0065 TYPE PA0065.
SELECT SINGLE *
FROM PA0065
INTO CORRESPONDING FIELDS OF WA_PA0065
WHERE...
How to access SAP table PA0065
Within an ECC or HANA version of SAP you can also view further information about PA0065 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