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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
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 |