BTXEMPT SAP table for – BSI: Employee tax results

Here we would like to draw your attention to BTXEMPT 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). BTXEMPT is a SAP standard transp table used for storing BSI: Employee tax results related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB10.

SAP BTXEMPT table

Table BTXEMPT technical data

TableBTXEMPT
Data storingBSI: Employee tax results
ModulePA
Sub ModulePA-PA-US
SAP PackagePB10
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCUS
Table CategoryTRANSP

SAP BTXEMPT 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 BTXEMPT 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
  • EMPNAME : BSI Canada: Employee name
    Its data type is CHAR (Character String) with field length 30
  • COMPANY : BSI: Tax Company Code
    Its data type is CHAR (Character String) with field length 11
  • GROUPCODE : BSI Canada: Group code
    Its data type is CHAR (Character String) with field length 11
  • PAYTYPE : BSI: Payment type
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PAYFREQ : BSI: Pay frequency
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • YTDPAYPER : BSI: Year to date pay periods
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VACATION : BSI: Leave payment
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • STDHOURS : BSI: Standard hours
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • COTERM : BSI: Coterminous
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • NETWAGES : BSI: Net wages
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ESTGROSS : BSI: Estimated gross
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ESTSPOUSAL : BSI: Estimated gross – spouse
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • GROSSUP : BSI: Gross up indicator
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RECIPROCAL : BSI: Reciprocity indicator
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • GROSSWAGES : BSI: Total gross
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • MAINTDATE : BSI: Last changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MAINTTIME : BSI: Last changed at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6