BSET

Tax Data Document Segment | #transactional | Component: Financial Accounting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
Column Name Description
πŸ’² Currency Key (T001.WAERS):
HWBAS Tax Base Amount in Local Currency
FWBAS Tax Base Amount in Document Currency
HWSTE Tax Amount in Local Currency
FWSTE Tax Amount in Document Currency
LWSTE Tax Amount in Reporting Currency
LWBAS Tax Base in Reporting Currency
πŸ’² Currency Key of Second Local Currency (BKPF.HWAE2):
H2STE Tax Amount in Local Currency 2
H2BAS Tax Base Amount in Local Currency 2
πŸ’² Currency Key of Third Local Currency (BKPF.HWAE3):
H3STE Tax Amount in Local Currency 3
H3BAS Tax Base Amount in Local Currency 3
KBETR Tax Rate
Column Name Description
Column Name Description
TXDAT_FROM Valid-From Date of the Tax Rate
STMDT Date on Which the Tax Return Was Made
MLDDT Reporting Date for Tax Report
TXDAT Date for Determining Tax Rates
_DATAAGING Data Filter Value for Data Aging
FIWTIN_CHD Challan Date
Column Name Description
SHKZG Debit/Credit Indicator Show values
STBKZ Posting indicator Show values
TXMOD Tax Result Has Been Modified Manually Show values
Column Name Description Domain name
TAX_COUNTRY Tax Reporting Country/Region LAND1
TXGRP Group Indicator for Tax Line Items NUM03
KTOSL Transaction Key CHAR3
KNUMH Number of the Condition Record KNUMH
STCEG VAT Registration Number STCEG
EGBLD Country/Region of Destination for Delivery of Goods LAND1
EGLLD Supplying Country/Region for Delivery of Goods LAND1
STMTI Time of Program Run for the Tax Return TIME6
LSTML Country/Region for Tax Report LAND1
BUPLA Business Place J_1BBRANCH
TXJDP Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax TXJCD
TXJLV Tax jurisdiction code level CHAR1
TAXPS Tax document item number NUM6
FIWTIN_CHN Challan Number FIWTIN_CHN
Master Data Relations Join Conditions
Company Code
  • BSET.MANDT == T001.MANDT
  • BSET.BUKRS == T001.BUKRS
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • BSET.BUKRS == SKB1.BUKRS
  • BSET.MANDT == SKB1.MANDT
  • BSET.HKONT == SKB1.SAKNR
Condition type
  • Condition Type
  • Client
  • ?
  • ?
  • BSET.KSCHL == T685.KSCHL
  • BSET.MANDT == T685.MANDT
  • BSET.[column in domain "KVEWE"] == T685.KVEWE
  • BSET.[column in domain "KAPPL"] == T685.KAPPL
Client BSET.MANDT == T000.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • BSET.MANDT == T007A.MANDT
  • BSET.[column in domain "KALSM_D"] == T007A.KALSM
  • BSET.MWSKZ == T007A.MWSKZ
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • BSET.MANDT == TTXJ.MANDT
  • BSET.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • BSET.TXJCD == TTXJ.TXJCD