SAP Table PA0065

HR Master Record: Infotype 0065 (Tax - GB)

PA0065 (HR Master Record: Infotype 0065 (Tax - GB)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PA0065 to other SAP tables.

PA0065 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
TXNUM Text number TXNUM NUMC 5 0
TXLET Tax indicator TXLET CHAR 2 0
TXBAS Tax basis TXBAS CHAR 1 0
0 Cumulative
1 Week1 / Month1
TXRFS Tax refund indicator TXRFS CHAR 1 0
NULL Take no action
B Pay all refunds withheld
K Pay refund withheld (strike)
TXSTK On strike indicator TXSTK CHAR 1 0
X Yes
NULL No
P45PY P45 taxable pay P45PY CURR 9 2
P45TX P45 tax paid P45TX CURR 9 2
TXRFV TXRFV DEC 11 0
P45WK P45 Tax week number P45WK NUMC 2 0
P45MN P45 Tax month number P45MN NUMC 2 0
P45ID P45 has been issued indicator P45ID CHAR 1 0
X Yes
NULL No
P45DT Date P45 issued P45DT DATS 8 0
TDSRC Source of tax code stored TDSRC CHAR 3 0
P16 P46(PEN) for retired person
P45 P45 form
P46 P46 form
P38 P38 student form
P9 P9 form
P9X P9X form
P6 P6 form
P7X P7X form
PEX P46EXPAT
LVR LEAVER
EMR EMERGENCY
EMP EMPLOYEE
PEN PENSIONER
EXP EXPAT
STU STUDENT
ITM12 HR-GB: P45 Item 13 P08_ITM12 CURR 9 2
P45CR HR-GB: Correction Indicator for P45 Item 13 P08_P45CR CHAR 1 0
X Yes
NULL No
TXREG Regional code P08_TXREG CHAR 1 0
TXNMB Tax Number P08_TXNMB NUMC 6 0
TXCOD Tax Code P08_TXCODE CHAR 8 0
GLBID HR B2A: Global Object ID PC_B2A_GLBID CHAR 32 0
P46ID P46 has been issued indicator P46ID CHAR 1 0
X Yes
NULL No
P46DT Date P45(3) / P46 issued P46DT DATS 8 0
P160ID P46(PEN) has been issued indicator P08_P160ID CHAR 1 0
X Yes
NULL No
P46CLS HR GB: P46/P46(EXPAT) Class P08_P46CLS NUMC 1 0
1 If statement A is ticked, then P46 class =1.
2 If statement B is ticked, then P46 class = 2.
3 If statement C is ticked , then P46 class = 3.
4 If statement C is not ticked, then P46 class = 3 & tax = 0T.
P453ID P45(3) has been issued indicator P08_P453ID CHAR 1 0
X Yes
NULL No
PFIRE HR GB: Previous Employment Leaving Date P08_PFIREDATE DATS 8 0
TDNUM HR GB: Previous Employment Tax district number P08_PTDNUM CHAR 3 0
TDREF HR GB: Previous Employment Tax District Indicator P08_PTDRCE CHAR 10 0
PENAMT HR GB: Pension Amount Paid by employer Annually to Employee P08_PENAMT CURR 15 2
PENWIDI HR GB: Retiring on Pension Recently Bereaved Indicator P08_PENWIDI CHAR 1 0
X Yes
NULL No
P453DT P45(3) issued date P08_P453DT DATS 8 0
P160DT Date P46(PEN) is issued P160DT DATS 8 0
NPUAPR HR GB : No Pay Until April P08_NPUAPR CHAR 1 0
X Yes
NULL No
PTXCOD Tax Code P08_TXCODE CHAR 8 0
PTXBAS Previous Tax Basis PTXBAS CHAR 1 0
X Yes
NULL No
DP45WK P45 Tax week number (Previous tax year) DP45WK NUMC 2 0
DP45MN P45 Tax month number (Previous tax year) DP45MN NUMC 2 0
DP45PY P45 taxable pay (Previous tax year) DP45PY CURR 9 2
DP45TX P45 tax paid (Previous tax year) DP45TX CURR 9 2
PP45WK P46(PEN) tax week number PP45WK NUMC 2 0
PP45MN P46 (PEN)Tax month number PP45MN NUMC 2 0
PP45PY P46 (PEN) taxable pay PP45PY CURR 9 2
PP45TX P46 (PEN) tax paid PP45TX CURR 9 2
PPFIRE HR GB: Previous Employment Leaving Date - P46(PEN) PPFIRE DATS 8 0
PTDNUM HR GB: Previous Employment Tax district number P46 (PEN) PTDNUM CHAR 3 0
PTDREF HR GB: Previous Employment Tax District Indicator P46 (PEN) PTDREF CHAR 10 0
PPTXCOD Previous tax code - P46PEN P08_PPTXC CHAR 8 0
PPTXBAS Previous Tax Basis P46PEN P08_PPTXB CHAR 1 0
X Yes
NULL No
EMPPEN Employer to Pensioner flag EMPPEN CHAR 1 0
X Yes
NULL No
P46EDT Date P46(EXPAT) issued P08_P46EDT DATS 8 0
P46EID P46(EXPAT) has been issued indicator P08_P46EID CHAR 1 0
X Yes
NULL No
IYMV_PID HR B2A: Global Object ID PC_B2A_GLBID CHAR 32 0
WRKNO HR GB: HMRC Works Number P08_WRKSN NUMC 10 0
WRKNO_REHIRE_IND Rehire Indicator for Worknumber (HMRC) P08_WRK_RHIRE_IND CHAR 2 0

PA0065 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0065 MANDT PA0065 MANDT T000 Clients MANDT
PA0065 PERNR PA0065 MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0065 PERNR PA0065 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0065 PREAS PA0065 MANDT T530E Reasons for Changes MANDT
PA0065 PREAS '0065' T530E Reasons for Changes INFTY
PA0065 PREAS PA0065 PREAS T530E Reasons for Changes PREAS