SAP table PA0065 (HR Master Record: Infotype 0065 (Tax - GB))

SAP table PA0065 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

PA0065 foreign key relationships

Table Field Check Table Check Field
0 PA0065 MANDT T000 Clients MANDT
1 PA0065 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0065 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0065 PREAS T530E Reasons for Changes MANDT
0 PA0065 PREAS T530E Reasons for Changes INFTY
0 PA0065 PREAS T530E Reasons for Changes PREAS