SAP BTXFORM Table – BSI Tax Formulas

The BTXFORM table in SAP ERP or S/4HANA stores BSI Tax Formulas data. There are total 7 fields in BTXFORM table. The BSI Tax Formulas table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BTXFORM table. It is in HR payroll accounting: BSI tax interface for USA (PZ1B) ABAP package and is part of the BSI (PY-US-NT-TX-BSI) module.

SAP BTXFORM Table Fields

Following is the list of fields that are available in SAP BTXFORM table. The primary key fields of the table are BSIAUTH (BSI: Tax authority), TAXTYPE (BSI: Tax type), EFFECTIVE (BSI: Validity date), FORMULA (Formula number).

Field Description Data Element Check Table Data Type
BSIAUTH BSI: Tax authority BSIAUTH BTXAUTH CHAR (8)
TAXTYPE BSI: Tax type TAXTYPE BTXTAXT CHAR (2)
EFFECTIVE BSI: Validity date EFFECTIVE DATS (8)
FORMULA Formula number P10_BSIFORMULA CHAR (1)
GROUPNO BSI: Group number PB10_GRPNO NUMC (2)
RESIDENT BSI: Resident code PB10_RESID NUMC (1)
TITLE BSI: Formula title PB10_TITLE CHAR (35)