SAP TABLES | Financial Accounting(FI) SAP FI

BSET SAP Tax Data Document Segment Cluster table and data







BSET is a standard SAP Cluster table which is used to store Tax Data Document Segment data and 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 SAP BSET Cluster table and the data within it using relevant 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
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP BSET Cluster table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
BUKRSBUKRSCHAR4T001Company Code
BELNRBELNR_DCHAR10Accounting Document NumberALPHA
GJAHRGJAHRNUMC4Fiscal YearGJAHR
BUZEIBUZEINUMC3Number of Line Item Within Accounting Document
MWSKZMWSKZCHAR2T007ATax on sales/purchases code
HKONTHKONTCHAR10SKB1General Ledger AccountALPHA
TXGRPTXGRPNUMC3Group Indicator for Tax Line Items
SHKZGSHKZGCHAR1Debit/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
KTOSLKTOSLCHAR3Transaction Key
KNUMHKNUMHCHAR10Condition record number
STCEGSTCEGCHAR20VAT Registration Number
EGBLDEGBLDCHAR3
*
Country of Destination for Delivery of Goods
EGLLDEGLLDCHAR3
*
Supplying Country for Delivery of Goods
TXJCDTXJCDCHAR15TTXJTax 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
KSCHLKSCHLCHAR4T685Condition Type
STMDTSTMDT_BSETDATS8Date on Which the Tax Return Was Made
STMTISTMTI_BSETCHAR6Time of Program Run for the Tax Return
MLDDTMLDDT_BSETDATS8Reporting Date for Tax Report
KBETRKBETR_TAXCURR11(2)Tax Rate
STBKZSTBKZ_007BCHAR1Posting indicator
LSTMLLAND1_STMLCHAR3
*
Country for Tax Return
LWSTELWSTE_BSETCURR13(2)Tax Amount in Country Currency
LWBASLWBAS_BSETCURR15(2)Tax Base in Country Currency
TXDATTXDATDATS8Date for defining tax rates
BUPLABUPLACHAR4
*
Business Place
TXJDPTXJCD_DEEPCHAR15
*
Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax
TXJLVTXJCD_LEVELCHAR1Tax jurisdiction code level
TAXPSTAX_POSNRNUMC6Tax document item number
TXMODTAX_MODINT13Tax Result Has Been Modified Manually



Key field
Non-key field

BSET relationships with 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