SAP table PA0364 (Infotype Tax TH)

SAP table PA0364 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
TAXID Tax Identification Number (TH) CHAR 10 0 PTH_TAXID
SPALL Spouse Allowance Status (TH) CHAR 1 0 PTH_SPALL
1 Spouse does not work
2 No spouse
4 Spouse works and claims child allowance
LPREM Life Insurance Premium CURR 9 2 PTH_LPREM
LPCUR Currency Key CUKY 5 0 TCURC WAERS
MGINT Mortgage Interest CURR 9 2 PTH_MGINT
MGCUR Currency Key CUKY 5 0 TCURC WAERS
CHAMT Charity amount CURR 9 2 PTH_CHAMT
CHCUR Currency Key CUKY 5 0 TCURC WAERS
CHNO1 Number of Children for Child Allowance NUMC 2 0 PTH_CHNO1
CHNO2 Number of Children Born After 1979 (TH) NUMC 2 0 PTH_CHNO2
CHNO3 Number of Children for Education Allowance NUMC 2 0 PTH_CHNO3
SPINS Spouse Insurance Amount for Tax Allowance TH CURR 9 2 PTH_SPINS
SPCUR Currency Key CUKY 5 0 TCURC WAERS
ALLTY Type of Allowance (Subtype) CHAR 4 0 * PTH_ALLTY
MFINV Mutual fund investment amount for Tax allowance CURR 9 2 PTH_MFINV
MFCUR Currency Key CUKY 5 0 TCURC WAERS
HACSH Housing Allowance - Cash amount for Tax Allowance CURR 9 2 PTH_HACSH
HCCUR Currency Key CUKY 5 0 TCURC WAERS
HAHIR Housing Allowance - Hire purchase amount for Tax Allowance CURR 9 2 PTH_HAHIR
HHCUR Currency Key CUKY 5 0 TCURC WAERS
PENSN Pension Fund amount for Tax allowance CURR 9 2 PTH_PENSN
PNCUR Currency Key CUKY 5 0 TCURC WAERS
LTEQF Long Term Equity Fund amount for Tax allowance CURR 9 2 PTH_LTEQF
LTCUR Currency Key CUKY 5 0 TCURC WAERS
CHEDU Charity for Education Amount CURR 9 2 PTH_CHEDU
CECUR Currency Key CUKY 5 0 TCURC WAERS
FCNTR Parental Contribution (Father) amount for Tax allowance CURR 9 2 PTH_FCNTR
FCCUR Currency Key CUKY 5 0 * WAERS
MCNTR Parental Contribution (Mother) amount for Tax allowance CURR 9 2 PTH_MCNTR
MCCUR Currency Key CUKY 5 0 * WAERS
SFCTR Spouse's Parental Contribution (Father) for Tax allowance CURR 9 2 PTH_SFCTR
SFCUR Currency Key CUKY 5 0 * WAERS
SMCTR Spouse's Parental Contribution (Mother) for Tax allowance CURR 9 2 PTH_SMCTR
SMCUR Currency Key CUKY 5 0 * WAERS
SPRCTR Sports Contribution for Tax allowance CURR 9 2 PTH_SPRCTR
SPRCUR Currency Key CUKY 5 0 * WAERS
FPRINS Parents' Ins. Premium (Father) CURR 9 2 PTH_FPRINS
FPRCUR Currency Key CUKY 5 0 * WAERS
MPRINS Parents' Ins. Premium (Mother) CURR 9 2 PTH_MPRINS
MPRCUR Currency Key CUKY 5 0 * WAERS
SFPINS Parents' Ins. Premium (Spouse Father) CURR 9 2 PTH_SFPINS
SFPCUR Currency Key CUKY 5 0 * WAERS
SMPINS Parents' Ins. Premium ( Spouse Mother) CURR 9 2 PTH_SMPINS
SMPCUR Currency Key CUKY 5 0 * WAERS
IMMEXP Expenses for buying immovable property CURR 9 2 PTH_IMMEXP
IMMCUR Currency Key CUKY 5 0 * WAERS
DIALL Disabled Dependent Allowance Status (TH) CHAR 1 0 PTH_DIALL
1 Spouse does not work
2 No spouse
4 Spouse works and claims disabled dependent allowance
DINO1 Number of Disabled for Disabled Dependent Allowance NUMC 2 0 PTH_DINO1
TUREXM Tourism Exemption CURR 9 2 PTH_TUREXM
TURCUR Currency Key CUKY 5 0 * WAERS
LPNSN Life Insurance Pension CURR 9 2 PTH_LPNSN
LNCUR Currency Key CUKY 5 0 * WAERS
DISCH Tax Allowance For Disabled Person CHAR 1 0 PTH_DISCH
EETAX New EE Tax ID(13 digits) CHAR 13 0 PTH_EETAX
IMDAT Immovable Property Purchase Date DATS 8 0 PTH_IMDAT
HIEXP Health Insurance Premium CURR 9 2 PTH_HIEXP
HICUR Currency Key CUKY 5 0 * WAERS
CHNO4 Number of Children Born after 2018 NUMC 2 0 PTH_CHNO4
SUSAF Super Saving Fund Amount for Tax Allowance CURR 9 2 PTH_SUSAF
SSCUR Currency Key CUKY 5 0 * WAERS
SSFEX Super Saving Fund Extra Amount for Tax Allowance CURR 9 2 PTH_SSFEX
SXCUR Currency Key CUKY 5 0 * WAERS

PA0364 foreign key relationships

Table Field Check Table Check Field
0 PA0364 CECUR TCURC Currency Codes MANDT
0 PA0364 CECUR TCURC Currency Codes WAERS
1 PA0364 CHCUR TCURC Currency Codes MANDT
1 PA0364 CHCUR TCURC Currency Codes WAERS
0 PA0364 HCCUR TCURC Currency Codes MANDT
0 PA0364 HCCUR TCURC Currency Codes WAERS
1 PA0364 HHCUR TCURC Currency Codes MANDT
1 PA0364 HHCUR TCURC Currency Codes WAERS
0 PA0364 LPCUR TCURC Currency Codes MANDT
0 PA0364 LPCUR TCURC Currency Codes WAERS
1 PA0364 LTCUR TCURC Currency Codes MANDT
1 PA0364 LTCUR TCURC Currency Codes WAERS
0 PA0364 MANDT T000 Clients MANDT
1 PA0364 MFCUR TCURC Currency Codes MANDT
1 PA0364 MFCUR TCURC Currency Codes WAERS
0 PA0364 MGCUR TCURC Currency Codes MANDT
0 PA0364 MGCUR TCURC Currency Codes WAERS
1 PA0364 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
1 PA0364 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
0 PA0364 PNCUR TCURC Currency Codes MANDT
0 PA0364 PNCUR TCURC Currency Codes WAERS
1 PA0364 PREAS T530E Reasons for Changes MANDT
1 PA0364 PREAS T530E Reasons for Changes INFTY
1 PA0364 PREAS T530E Reasons for Changes PREAS
0 PA0364 SPCUR TCURC Currency Codes MANDT
0 PA0364 SPCUR TCURC Currency Codes WAERS