SAP table BSET (Tax Data Document Segment)

SAP table BSET has 5 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

BSET foreign key relationships

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