SAP Table BSET
Tax Data Document Segment
What Is the SAP BSET Table?
BSET is an SAP Financial Accounting table that stores the tax-related line-items details of accounting document. It contains tax information generated during financial postings.
In SAP, the tax information of accounting document is stored separately from document header and line item data. The document header is stored in BKPF and line items are stored in BSEG, and tax related information is stored in BSET.
A single accounting document can contain multiple tax related in BSET when multiple tax lines are involved or different tax codes are applied.
SAP FI Consultants, users and support team use the BSET table to analyse tax posting, verify tax codes and tax amounts, reconcile tax entries, and troubleshoot tax related issues.
Quick overview
| SAP table | BSET |
|---|---|
| Short description | Tax Data Document Segment |
| Table type | Transparent table |
| Primary key | MANDT (Client), BUKRS (Company Code), BELNR (Document Number of an Accounting Document), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document) |
| Client-dependent | Yes |
| Commonly used fields | BUKRS (Company Code), BELNR (Document Number of an Accounting Document), GJAHR (Fiscal Year), TAX_COUNTRY (Tax Reporting Country/Region), MWSKZ (Tax on sales/purchases code), BUZEI (Number of Line Item Within Accounting Document), HWSTE (Tax Amount in Local Currency) |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
BUKRS |
Company Code | Company code to which the tax accounting document belongs. |
BELNR |
Document Number of an Accounting Document | Accounting document number associated with the tax line. |
GJAHR |
Fiscal Year | Fiscal year of the accounting document. |
TAX_COUNTRY |
Tax Reporting Country/Region | Country or region used for tax reporting on this tax line. |
MWSKZ |
Tax on sales/purchases code | Tax code used to determine the tax calculation rules for the transaction. |
HWSTE |
Tax Amount in Local Currency | Tax amount in local (company code) currency. |
At a glance
- Module
- Financial Accounting FI
Technical details
- Delivery class
- A (Application table: master and transaction data)
- Data class
- APPL1 (Transaction Data, Transparent Tables)
- Package
- Financial Accounting "Basis" (FBAS)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
BUKRS
|
Company Code | BUKRS | CHAR | 4 |
BELNR
|
Document Number of an Accounting Document | BELNR_D | CHAR | 10 |
GJAHR
|
Fiscal Year | GJAHR | NUMC | 4 |
BUZEI
|
Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 |
Table fields
43 fields
43 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
BUKRS
Key
|
Company Code | BUKRS | BUKRS | CHAR | 4 | — | T001 |
BELNR
Key
|
Document Number of an Accounting Document | BELNR_D | BELNR | CHAR | 10 | — | |
GJAHR
Key
|
Fiscal Year | GJAHR | GJAHR | NUMC | 4 | — | |
BUZEI
Key
|
Number of Line Item Within Accounting Document | BUZEI | BUZEI | NUMC | 3 | — | |
TAX_COUNTRY
|
Tax Reporting Country/Region | FOT_TAX_COUNTRY | LAND1 | CHAR | 3 | — | |
MWSKZ
|
Tax on sales/purchases code | MWSKZ | MWSKZ | CHAR | 2 | — | T007A |
TXDAT_FROM
|
Valid-From Date of the Tax Rate | FOT_TXDAT_FROM | — | DATS | 8 | — | |
HKONT
|
General Ledger Account | HKONT | SAKNR | CHAR | 10 | — | SKB1 |
TXGRP
|
Group Indicator for Tax Line Items | TXGRP | NUM03 | NUMC | 3 | — | |
SHKZG
|
Debit/Credit Indicator | SHKZG | SHKZG | CHAR | 1 | — | |
HWBAS
|
Tax Base Amount in Local Currency | HWBAS_BSES | AFLE15D2O21S_TO_23D2O31S | CURR | 23 | 2 | |
FWBAS
|
Tax Base Amount in Document Currency | FWBAS_BSES | AFLE15D2O21S_TO_23D2O31S | CURR | 23 | 2 | |
HWSTE
|
Tax Amount in Local Currency | HWSTE | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
FWSTE
|
Tax Amount in Document Currency | FWSTE | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
KTOSL
|
Transaction Key | KTOSL | CHAR3 | CHAR | 3 | — | |
KNUMH
|
Number of Condition Record | KNUMH | KNUMH | CHAR | 10 | — | |
STCEG
|
VAT Registration Number | STCEG | STCEG | CHAR | 20 | — | |
EGBLD
|
Country/Region of Destination for Delivery of Goods | EGBLD | LAND1 | CHAR | 3 | — | |
EGLLD
|
Supplying Country/Region for Delivery of Goods | EGLLD | LAND1 | CHAR | 3 | — | |
TXJCD
|
Tax Jurisdiction | TXJCD | TXJCD | CHAR | 15 | — | TTXJ |
H2STE
|
Tax Amount in Local Currency 2 | H2STE | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
H3STE
|
Tax Amount in Local Currency 3 | H3STE | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
H2BAS
|
Tax Base Amount in Local Currency 2 | H2BAS_BSES | AFLE15D2O21S_TO_23D2O31S | CURR | 23 | 2 | |
H3BAS
|
Tax Base Amount in Local Currency 3 | H3BAS_BSES | AFLE15D2O21S_TO_23D2O31S | CURR | 23 | 2 | |
KSCHL
|
Condition Type | KSCHL | KSCHL | CHAR | 4 | — | T685 |
STMDT
|
Date on Which the Tax Return Was Made | STMDT_BSET | DATUM | DATS | 8 | — | |
STMTI
|
Time of Program Run for the Tax Return | STMTI_BSET | TIME6 | CHAR | 6 | — | |
MLDDT
|
Reporting Date for Tax Report | MLDDT_BSET | DATUM | DATS | 8 | — | |
KBETR
|
Tax Rate | KBETR_TAX | AFLE11D2O16S_TO_23D2O31S | CURR | 23 | 2 | |
STBKZ
|
Posting indicator | STBKZ_007B | STBKZ_007B | CHAR | 1 | — | |
LSTML
|
Country/Region for Tax Report | LAND1_STML | LAND1 | CHAR | 3 | — | |
LWSTE
|
Tax Amount in Reporting Currency | LWSTE_BSET | AFLE13D2O16N_TO_23D2O30N | CURR | 23 | 2 | |
LWBAS
|
Tax Base in Reporting Currency | LWBAS_BSET | AFLE15D2O21S_TO_23D2O31S | CURR | 23 | 2 | |
TXDAT
|
Date for Determining Tax Rates | TXDAT | DATUM | DATS | 8 | — | |
BUPLA
|
Business Place | BUPLA | J_1BBRANCH | CHAR | 4 | — | |
TXJDP
|
Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax | TXJCD_DEEP | TXJCD | CHAR | 15 | — | |
TXJLV
|
Tax jurisdiction code level | TXJCD_LEVEL | CHAR1 | CHAR | 1 | — | |
TAXPS
|
Tax document item number | TAX_POSNR | NUM6 | NUMC | 6 | — | |
TXMOD
|
Tax Result Has Been Modified Manually | TAX_MOD | TAX_MOD | INT1 | 3 | — | |
_DATAAGING
|
Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS | 8 | — | |
FIWTIN_CHN
|
Challan Number | FIWTIN_CHN | FIWTIN_CHN | CHAR | 12 | — | |
FIWTIN_CHD
|
Challan Date | FIWTIN_CHD | — | DATS | 8 | — |
No fields match the selected filters.
SAP BSET Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with BSET |
|---|---|---|
| SKB1 | G/L account master (company code) | MANDT, BUKRS |
| BSEG | Accounting Document Segment | MANDT, BUKRS, BELNR, GJAHR, BUZEI |
| BKPF | Accounting Document Header | MANDT, BUKRS, BELNR, GJAHR |
| T007S | Tax Code Names | MANDT |
| T007A | Tax Keys | MANDT |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 6, 2026
The information on this SAP BSET table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.