1. Home
  2. Resources
  3. SAP Tables
  4. BTXTTAX - BSI: Test Taxes

SAP Table BTXTTAX

BSI: Test Taxes

BTXTTAX (BSI: Test Taxes) 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 BTXTTAX to other SAP tables.

Source: BTXTTAX (BSI: Test Taxes)

BTXTTAX table fields

Field Data element Checktable Datatype Length Decimals
EMPLOYEE BSI: Employee PB10_EMP CHAR 11 0
CHECKDATE BSI: Check Date PB10_CDATE BTXEMPT DATS 8 0
COUNTRY BSI: Country indicator COUNTRY CHAR 1 0
INCOME BSI: Income category INCOME CHAR 1 0
TAXCODE BSI: Tax Code PB10_TCODE BTXTAXC CHAR 11 0
TAXTYPE BSI: Tax category TAXTYPE BTXTAXT CHAR 2 0
FORMULA BSI: Tax formula PB10_FORML NUMC 1 0
RESCODE BSI: Resident code PB10_RESID NUMC 1 0
1
EXEMPT Exempt PB10_EXEMP CHAR 1 0
X Yes
NULL No
RECIPROCAL BSI: Reciprocity indicator PB10_RECIP NUMC 1 0
1
NONRESCER Certificate status CERTF NUMC 1 0
0 No certificate
1 Certificate of non-residence
2 Exempt from withholding
3 Withholding tax credit
PPWAGES BSI Canada: Pay Period Wages PB10_PPWAG DEC 9 2
YTDWAGES BSI Canada: Year to date Wages PB10_YTDWG DEC 9 2
YTDTAX BSI Canada: Year to date tax PB10_YTDTX DEC 9 2
ROUNDING Number of positions to roundoff ROUNDING NUMC 1 0
MARITAL BSI: Marital status PB10_MARIT NUMC 2 0
REXEMPT BSI: Remaining tax exemptions PB10_REXMP NUMC 5 0
REXAMOUNT BSI: Remaining exempt amount PB10_REAMT DEC 9 2
PEXEMPT BSI: Prior tax exemptions PB10_PEXMP NUMC 5 0
DEXEMPT BSI: D Tax exemptions PB10_DEXMP NUMC 5 0
ADEXEMPT BSI: Additional tax exemptions PB10_AEXMP NUMC 5 0
ADEXAMOUNT BSI: Additional exemption amount PB10_AEAMT DEC 9 2
SUPPCODE BSI: Supplemental Code PB10_SUPPC NUMC 1 0
1
BASEWAGES BSI: Base wage PB10_BASWG DEC 9 2
ADDTAXCODE BSI: Additional Tax Code PB10_ATCOD NUMC 1 0
1
ADDTAXRATE BSI: Additional Tax Rate PB10_ATRAT CHAR 24 0
ADDTAXAMT BSI: Additional Tax Amount PB10_ATAMT DEC 9 2
EICSTATUS EIC status EICST CHAR 1 0
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 PB10_PPTAX DEC 9 2
MTDWAGES BSI: Month to date Wages PB10_MTDWG DEC 9 2
MTDTAX BSI: Month to date tax PB10_MTDTX DEC 9 2
PCTWORKED BSI: Percentage work PB10_PCTWK DEC 9 2
RPTAXCRAMT BSI: Tax credit PB10_TAXCR CHAR 24 0
EXPRATE BSI: Experience amount PB10_EXPAM DEC 9 2
MAXWAGEOR BSI: Maximum rate PB10_MAXRT CHAR 24 0
NONTAXCON BSI: Non taxable contributions PB10_NONTX DEC 9 2
SELFADJTX BSI: Indicator for self-adjusting tax PB10_SELFA NUMC 1 0
1
CALCTAX BSI: Calculated tax PB10_CALCT DEC 9 2
TAXWAGE BSI: Taxable wages PB10_TAXWG DEC 9 2
TOTALWAGE BSI: Total pay PB10_TOTAL DEC 9 2
STATUS BSI: Status PB10_STATU NUMC 1 0
1
ROUNDIND PBSI_ROUND PBSI_ROUND DEC 1 0
1
HOURS1 BSI: Standard hours PBSI_HOURS DEC 9 2
RCPFORMULA PBSI_RCPF1 DEC 1 0

BTXTTAX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BTXTTAX CHECKDATE BTXTTAX EMPLOYEE BTXEMPT BSI: Employee tax results EMPLOYEE
BTXTTAX CHECKDATE BTXTTAX CHECKDATE BTXEMPT BSI: Employee tax results CHECKDATE
BTXTTAX TAXCODE SYST MANDT BTXTAXC BSI: BSI Tax Authorities SAP Tax Authorities Grouping MANDT
BTXTTAX TAXCODE BTXTTAX COUNTRY BTXTAXC BSI: BSI Tax Authorities SAP Tax Authorities Grouping COUNTRY
BTXTTAX TAXCODE BTXTTAX INCOME BTXTAXC BSI: BSI Tax Authorities SAP Tax Authorities Grouping INCOME
BTXTTAX TAXCODE BTXTTAX TAXCODE BTXTAXC BSI: BSI Tax Authorities SAP Tax Authorities Grouping TAXCODE
BTXTTAX TAXTYPE BTXTTAX TAXTYPE BTXTAXT BSI: Tax Category TAXTYPE