1. Home
  2. Resources
  3. SAP Tables
  4. BSET - Tax Data Document Segment

SAP Table BSET

Tax Data Document Segment

BSET (Tax Data Document Segment) 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 BSET to other SAP tables.

BSET table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
HKONT General Ledger Account HKONT SKB1 CHAR 10 0
TXGRP Group Indicator for Tax Line Items TXGRP NUMC 3 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
HWBAS Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS Tax base amount in document currency FWBAS_BSES CURR 15 2
HWSTE Tax Amount in Local Currency HWSTE CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
KTOSL Transaction Key KTOSL CHAR 3 0
KNUMH Condition record number KNUMH CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD CHAR 3 0
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
H2STE Tax Amount in Local Currency 2 H2STE CURR 13 2
H3STE Tax Amount in Local Currency 3 H3STE CURR 13 2
H2BAS Tax Base Amount in Local Currency 2 H2BAS_BSES CURR 15 2
H3BAS Tax Base Amount in Local Currency 3 H3BAS_BSES CURR 15 2
KSCHL Condition Type KSCHL T685 CHAR 4 0
STMDT Date on Which the Tax Return Was Made STMDT_BSET DATS 8 0
STMTI Time of Program Run for the Tax Return STMTI_BSET CHAR 6 0
MLDDT Reporting Date for Tax Report MLDDT_BSET DATS 8 0
KBETR Tax Rate KBETR_TAX CURR 11 2
STBKZ Posting indicator STBKZ_007B CHAR 1 0
1 No posting required
2 Separate line item
3 Distribute to relevant expense/revenue items
LSTML Country for Tax Return LAND1_STML CHAR 3 0
LWSTE Tax Amount in Country Currency LWSTE_BSET CURR 13 2
LWBAS Tax Base in Country Currency LWBAS_BSET CURR 15 2
TXDAT Date for defining tax rates TXDAT DATS 8 0
BUPLA Business Place BUPLA CHAR 4 0
TXJDP Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax TXJCD_DEEP CHAR 15 0
TXJLV Tax jurisdiction code level TXJCD_LEVEL CHAR 1 0
TAXPS Tax document item number TAX_POSNR NUMC 6 0
TXMOD Tax Result Has Been Modified Manually TAX_MOD INT1 3 0
1 Base amount has been changed
2 Direct Tax Item
3 Double Taxation
4 Tax local currency has been changed
5 Values Predefined (Interface)

BSET foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSET BUKRS BSET MANDT T001 Company Codes MANDT
BSET BUKRS BSET BUKRS T001 Company Codes BUKRS
BSET HKONT BSET MANDT SKB1 G/L account master (company code) MANDT
BSET HKONT BSET BUKRS SKB1 G/L account master (company code) BUKRS
BSET HKONT BSET HKONT SKB1 G/L account master (company code) SAKNR
BSET KSCHL T685 KAPPL T685 Conditions: Types KAPPL
BSET KSCHL BSET KSCHL T685 Conditions: Types KSCHL
BSET KSCHL T685 MANDT T685 Conditions: Types MANDT
BSET KSCHL T685 KVEWE T685 Conditions: Types KVEWE
BSET MANDT BSET MANDT T000 Clients MANDT
BSET MWSKZ BSET MANDT T007A Tax Keys MANDT
BSET MWSKZ T005 KALSM T007A Tax Keys KALSM
BSET MWSKZ BSET MWSKZ T007A Tax Keys MWSKZ
BSET TXJCD BSET MANDT TTXJ Check Table for Tax Jurisdiction MANDT
BSET TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
BSET TXJCD BSET TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD