BTXTTAX SAP table for – BSI: Test Taxes

Here we would like to draw your attention to BTXTTAX table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). BTXTTAX is a SAP standard transp table used for storing BSI: Test Taxes related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB10.

SAP BTXTTAX table

Table BTXTTAX technical data

TableBTXTTAX
Data storingBSI: Test Taxes
ModulePA
Sub ModulePA-PA-US
SAP PackagePB10
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCUS
Table CategoryTRANSP

SAP BTXTTAX Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in BTXTTAX table.

  • EMPLOYEE : BSI: Employee
    Its a key field. Its data type is CHAR (Character String) with field length 11
  • CHECKDATE : BSI: Check Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COUNTRY : BSI: Country indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • INCOME : BSI: Income category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TAXCODE : BSI: Tax Code
    Its a key field. Its data type is CHAR (Character String) with field length 11
  • TAXTYPE : BSI: Tax category
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • FORMULA : BSI: Tax formula
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 1
  • RESCODE : BSI: Resident code
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • EXEMPT : Exempt
    Its data type is CHAR (Character String) with field length 1
  • RECIPROCAL : BSI: Reciprocity indicator
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • NONRESCER : Certificate status
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PPWAGES : BSI Canada: Pay Period Wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • YTDWAGES : BSI Canada: Year to date Wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • YTDTAX : BSI Canada: Year to date tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ROUNDING : Number of positions to roundoff
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MARITAL : BSI: Marital status
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • REXEMPT : BSI: Remaining tax exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • REXAMOUNT : BSI: Remaining exempt amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PEXEMPT : BSI: Prior tax exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • DEXEMPT : BSI: D Tax exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ADEXEMPT : BSI: Additional tax exemptions
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ADEXAMOUNT : BSI: Additional exemption amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SUPPCODE : BSI: Supplemental Code
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • BASEWAGES : BSI: Base wage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ADDTAXCODE : BSI: Additional Tax Code
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADDTAXRATE : BSI: Additional Tax Rate
    Its data type is CHAR (Character String) with field length 24
  • ADDTAXAMT : BSI: Additional Tax Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EICSTATUS : EIC status
    Its data type is CHAR (Character String) with field length 1
  • PPTAX : BSI Canada: Pay Period Wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • MTDWAGES : BSI: Month to date Wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • MTDTAX : BSI: Month to date tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PCTWORKED : BSI: Percentage work
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • RPTAXCRAMT : BSI: Tax credit
    Its data type is CHAR (Character String) with field length 24
  • EXPRATE : BSI: Experience amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • MAXWAGEOR : BSI: Maximum rate
    Its data type is CHAR (Character String) with field length 24
  • NONTAXCON : BSI: Non taxable contributions
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SELFADJTX : BSI: Indicator for self-adjusting tax
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CALCTAX : BSI: Calculated tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TAXWAGE : BSI: Taxable wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TOTALWAGE : BSI: Total pay
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • STATUS : BSI: Status
    Its data type is NUMC (Character String with Digits Only) with field length 1