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
See here for more information about this and other SAP enhancement categories

==>View Table relationships


Dictionary fields for SAP Cluster table BSET




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
BUKRSBUKRSCHAR4 T001Company Code
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
HKONTHKONTCHAR10 SKB1General Ledger AccountALPHA
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