The BTXPLNX table in SAP ERP or S/4HANA stores BSI: Benefit Plan data. There are total 10 fields in BTXPLNX table. The BSI: Benefit Plan 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 BTXPLNX 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 BTXPLNX Table Fields
Following is the list of fields that are available in SAP BTXPLNX table. The primary key fields of the table are BSIAUTH (BSI: Tax authority), TAXTYPE (BSI: Tax type), PLANTYPE (BSI: Plan type), EFFECTIVE (BSI: Validity date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| BSIAUTH | BSI: Tax authority | BSIAUTH | BTXAUTH | CHAR (8) |
| TAXTYPE | BSI: Tax type | TAXTYPE | BTXTAXT | CHAR (2) |
| PLANTYPE | BSI: Plan type | PB10_TPLAN | BTXPLAN | CHAR (4) |
| EFFECTIVE | BSI: Validity date | EFFECTIVE | DATS (8) | |
| AGGCLASS | BSI: Total data class | AGGCLASS | CHAR (2) | |
| RESCIND | BSI: Rescission date | PB10_RECAL | DATS (8) | |
| EEPLNMAX | BSI: Employee’s planned maximum amount | EEPLNMAX | DEC (9) | |
| ERPLNMAX | BSI: Employer’s planned maximum amount | ERPLNMAX | DEC (9) | |
| MAINTDATE | BSI: Last changed on | MAINTDATE | DATS (8) | |
| MAINTTIME | BSI: Last changed at | MAINTTIME | TIMS (6) |


