SAP Tables | Financial Accounting(FI) SAP FI

BSET SAP Tax Data Document Segment Cluster table







BSET is a standard SAP Cluster table which is used to store Tax Data Document Segment information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Cluster table. You can view further information about Cluster table BSET and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified

==>View Table relationships


Dictionary fields for SAP Cluster table BSET

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
BUKRSBUKRSCHAR4 T001Company Code
BELNRBELNR_DCHAR10 Accounting Document Number
GJAHRGJAHRNUMC4 Fiscal Year
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
HKONTHKONTCHAR10 SKB1General Ledger Account
TXGRPTXGRPNUMC3 Group Indicator for Tax Line Items
SHKZGSHKZGCHAR1 Debit/Credit Indicator
HWBASHWBAS_BSESCURR15(2) Tax Base Amount in Local Currency
FWBASFWBAS_BSESCURR15(2) Tax base amount in document currency
HWSTEHWSTECURR13(2) Tax Amount in Local Currency
FWSTEFWSTECURR13(2) Tax Amount in Document Currency
KTOSLKTOSLCHAR3 Transaction Key
KNUMHKNUMHCHAR10 Condition record number
STCEGSTCEGCHAR20 VAT Registration Number
EGBLDEGBLDCHAR3
*
Country of Destination for Delivery of Goods
EGLLDEGLLDCHAR3
*
Supplying Country for Delivery of Goods
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
H2STEH2STECURR13(2) Tax Amount in Local Currency 2
H3STEH3STECURR13(2) Tax Amount in Local Currency 3
H2BASH2BAS_BSESCURR15(2) Tax Base Amount in Local Currency 2
H3BASH3BAS_BSESCURR15(2) Tax Base Amount in Local Currency 3
KSCHLKSCHLCHAR4 T685Condition Type
STMDTSTMDT_BSETDATS8 Date on Which the Tax Return Was Made
STMTISTMTI_BSETCHAR6 Time of Program Run for the Tax Return
MLDDTMLDDT_BSETDATS8 Reporting Date for Tax Report
KBETRKBETR_TAXCURR11(2) Tax Rate
STBKZSTBKZ_007BCHAR1 Posting indicator
LSTMLLAND1_STMLCHAR3
*
Country for Tax Return
LWSTELWSTE_BSETCURR13(2) Tax Amount in Country Currency
LWBASLWBAS_BSETCURR15(2) Tax Base in Country Currency
TXDATTXDATDATS8 Date for defining tax rates
BUPLABUPLACHAR4
*
Business Place
TXJDPTXJCD_DEEPCHAR15
*
Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax
TXJLVTXJCD_LEVELCHAR1 Tax jurisdiction code level
TAXPSTAX_POSNRNUMC6 Tax document item number
TXMODTAX_MODINT13 Tax Result Has Been Modified Manually


Key field
Non-key field


Relations between BSET and other tables


BOSG-Uppermost Hierarchy Segment for BRF
      BKPF-Accounting Document Header
            BSEG-Accounting Document Segment
            BSET-Tax Data Document Segment
            FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
      KNA1-General Data in Customer Master
            KNBK-Customer Master (Bank Details)
            KNB1-Customer Master (Company Code)
                  KNB4-Customer Payment History
                  KNB5-Customer Master (Dunning Data)
                  KNKK-Credit Management Cust. Mstr: Control Area Data
                  KNC1-Customer Master (Transaction Figures)
                  KNC3-Customer Master (Special G/L Transaction Figures)
      LFA1-Vendor Master (General Section)
            LFBK-Vendor Master (Bank Details)
            LFB1-Vendor Master (Company Code)
                  LFB5-Vendor Master (Dunning Data)
                  LFC1-Vendor Master (Transaction Figures)
                  LFC3-Vendor Master (Transaction Figures) Special Ledger
      SKA1-G/L Account Master Record (Chart of Accounts)
            SKB1-G/L Account Master Record (Company Code)
                  SKC1A-G/L Sales Segment Derived from GLDB - Internal
                  SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


BKPF-Accounting Document Header
      BSET-Tax Data Document Segment
      BSEG-Accounting Document Segment
            BSEC-One-Time Account Data Document Segment
            EKKO-Purchasing Document Header
                  EKPO-Purchasing Document Item
                        EKBE-Purchasing Document History