SAP table BTXTTAX (BSI: Test Taxes)

SAP table BTXTTAX has 7 primary key fields being EMPLOYEE,CHECKDATE,COUNTRY,INCOME,TAXCODE,TAXTYPE,FORMULA.

Field Description Data Type Length Decimals Checktable Data Element
EMPLOYEE BSI: Employee CHAR 11 0 PB10_EMP
CHECKDATE BSI: Check Date DATS 8 0 BTXEMPT PB10_CDATE
COUNTRY BSI: Country indicator CHAR 1 0 COUNTRY
INCOME BSI: Income category CHAR 1 0 INCOME
TAXCODE BSI: Tax Code CHAR 11 0 BTXTAXC PB10_TCODE
TAXTYPE BSI: Tax type CHAR 2 0 BTXTAXT TAXTYPE
FORMULA BSI: Tax formula NUMC 1 0 PB10_FORML
RESCODE BSI: Resident code NUMC 1 0 PB10_RESID
EXEMPT Exempt CHAR 1 0 PB10_EXEMP
RECIPROCAL BSI: Reciprocity indicator NUMC 1 0 PB10_RECIP
NONRESCER Certificate status NUMC 1 0 CERTF
0 No certificate
1 Certificate of non-residence
2 Exempt from withholding
3 Withholding tax credit
4 Exemption from Withholding Other State
PPWAGES BSI Canada: Pay Period Wages DEC 9 2 PB10_PPWAG
YTDWAGES BSI Canada: Year to date Wages DEC 9 2 PB10_YTDWG
YTDTAX BSI Canada: Year to date tax DEC 9 2 PB10_YTDTX
ROUNDING Number of positions to roundoff NUMC 1 0 ROUNDING
MARITAL BSI: Marital status NUMC 2 0 PB10_MARIT
REXEMPT BSI: Remaining tax exemptions NUMC 5 0 PB10_REXMP
REXAMOUNT BSI: Remaining exempt amount DEC 9 2 PB10_REAMT
PEXEMPT BSI: Prior tax exemptions NUMC 5 0 PB10_PEXMP
DEXEMPT BSI: D Tax exemptions NUMC 5 0 PB10_DEXMP
ADEXEMPT BSI: Additional tax exemptions NUMC 5 0 PB10_AEXMP
ADEXAMOUNT BSI: Additional exemption amount DEC 9 2 PB10_AEAMT
SUPPCODE BSI: Supplemental Code NUMC 1 0 PB10_SUPPC
BASEWAGES BSI: Base wage DEC 9 2 PB10_BASWG
ADDTAXCODE BSI: Additional Tax Code NUMC 1 0 PB10_ATCOD
ADDTAXRATE BSI: Additional Tax Rate CHAR 24 0 PB10_ATRAT
ADDTAXAMT BSI: Additional Tax Amount DEC 9 2 PB10_ATAMT
EICSTATUS EIC status CHAR 1 0 EICST
0 Not applicable
1 Single, head of household or qualifying widow(er)
2 Married, filing jointly, both spouses filing Form W-5
3 Married, filing jointly, spouse not filing Form W-5
PPTAX BSI Canada: Pay Period Wages DEC 9 2 PB10_PPTAX
MTDWAGES BSI: Month to date Wages DEC 9 2 PB10_MTDWG
MTDTAX BSI: Month to date tax DEC 9 2 PB10_MTDTX
PCTWORKED BSI: Percentage work DEC 9 2 PB10_PCTWK
RPTAXCRAMT BSI: Tax credit CHAR 24 0 PB10_TAXCR
EXPRATE BSI: Experience amount DEC 9 2 PB10_EXPAM
MAXWAGEOR BSI: Maximum rate CHAR 24 0 PB10_MAXRT
NONTAXCON BSI: Non taxable contributions DEC 9 2 PB10_NONTX
SELFADJTX BSI: Indicator for self-adjusting tax NUMC 1 0 PB10_SELFA
CALCTAX BSI: Calculated tax DEC 9 2 PB10_CALCT
TAXWAGE BSI: Taxable wages DEC 9 2 PB10_TAXWG
TOTALWAGE BSI: Total pay DEC 9 2 PB10_TOTAL
STATUS BSI: Status NUMC 1 0 PB10_STATU

BTXTTAX foreign key relationships

Table Field Check Table Check Field
0 BTXTTAX CHECKDATE BTXEMPT BSI: Employee tax results EMPLOYEE
1 BTXTTAX TAXCODE BTXTAXC Tax Authority Mapping MANDT
1 BTXTTAX TAXCODE BTXTAXC Tax Authority Mapping COUNTRY
0 BTXTTAX TAXTYPE BTXTAXT BSI Tax Types TAXTYPE