1. Home
  2. Resources
  3. SAP Tables
  4. BTXEMPT - BSI: Employee tax results

SAP Table BTXEMPT

BSI: Employee tax results

BTXEMPT (BSI: Employee tax results) 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 BTXEMPT to other SAP tables.

Source: BTXEMPT (BSI: Employee tax results)

BTXEMPT table fields

Field Data element Checktable Datatype Length Decimals
EMPLOYEE BSI: Employee PB10_EMP CHAR 11 0
CHECKDATE BSI: Check Date PB10_CDATE DATS 8 0
EMPNAME BSI Canada: Employee name PB10_EMPNA CHAR 30 0
COMPANY BSI: Tax Company Code COMPANY BTXCOMP CHAR 11 0
GROUPCODE BSI Canada: Group code PB10_GCODE CHAR 11 0
PAYTYPE BSI: Payment type PB10_PTYPE NUMC 1 0
0 Regular
1 Supplemental
2 Cumulative
3 Vacation
PAYFREQ BSI: Pay frequency PB10_PFREQ NUMC 3 0
YTDPAYPER BSI: Year to date pay periods PB10_YTDPP NUMC 3 0
VACATION BSI: Leave payment PB10_VAC DEC 5 2
STDHOURS BSI: Standard hours PB10_STDHR DEC 5 2
COTERM BSI: Coterminous COTERM NUMC 1 0
NETWAGES BSI: Net wages PB10_NETWG DEC 9 2
ESTGROSS BSI: Estimated gross PB10_ESTGR DEC 9 2
ESTSPOUSAL BSI: Estimated gross - spouse PB10_ESTSP DEC 9 2
GROSSUP BSI: Gross up indicator PB10_GRSUP NUMC 1 0
1
RECIPROCAL BSI: Reciprocity indicator PB10_RECIP NUMC 1 0
1
GROSSWAGES BSI: Total gross PB10_GROSS DEC 9 2
MAINTDATE BSI: Last changed on MAINTDATE DATS 8 0
MAINTTIME BSI: Last changed at MAINTTIME TIMS 6 0

BTXEMPT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BTXEMPT COMPANY SYST MANDT BTXCOMP BSI: Tax Company Code MANDT
BTXEMPT COMPANY BTXEMPT COMPANY BTXCOMP BSI: Tax Company Code COMPANY