SAP table PA0235 (HR Master Record: Infotype 0235 (Other Taxes - USA))

SAP table PA0235 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
TAURT Tax authority record type CHAR 4 0 T5UTZ TAURT
TYP01 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM01 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP01 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP02 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM02 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP02 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP03 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM03 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP03 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP04 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM04 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP04 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP05 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM05 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP05 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP06 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM06 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP06 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP07 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM07 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP07 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP08 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM08 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP08 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP09 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM09 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP09 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP10 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM10 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP10 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP11 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM11 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP11 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP12 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM12 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP12 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP13 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM13 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP13 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP14 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM14 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP14 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP15 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM15 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP15 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP16 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM16 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP16 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP17 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM17 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP17 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP18 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM18 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP18 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP19 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM19 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP19 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP20 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM20 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP20 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP21 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM21 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP21 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP22 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM22 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP22 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP23 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM23 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP23 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP24 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM24 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP24 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP25 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM25 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP25 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP26 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM26 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP26 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP27 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM27 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP27 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP28 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM28 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP28 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP29 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM29 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP29 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable
TYP30 Tax type CHAR 2 0 HRPAYUS_TAX_TYPE
FRM30 Formula number CHAR 1 0 * P10_BSIFORMULA
EXP30 Tax exemption indicator CHAR 1 0 EXEMP
Not exempt
R Exempt, reportable
X Exempt, partly reportable
Y Exempt, not reportable

PA0235 foreign key relationships

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