fis_cds_bset_ev

Tax Data for Accounting Document Line Item | view: FISV_BSET_EV | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BKPFBSET
Column Name Description
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
fwbas Tax Base Amount in Document Currency
fwste Tax Amount in Document Currency
hwbas Tax Base Amount in Local Currency
hwste Tax Amount in Local Currency
h2bas Tax Base Amount in Local Currency 2
h2ste Tax Amount in Local Currency 2
h3bas Tax Base Amount in Local Currency 3
h3ste Tax Amount in Local Currency 3
fwstesol Tax Amount in Document Currency
fwstehab Tax Amount in Document Currency
hwstesol Tax Amount in Local Currency
hwstehab Tax Amount in Local Currency
h2stesol Tax Amount in Local Currency 2
h2stehab Tax Amount in Local Currency 2
h3stesol Tax Amount in Local Currency 3
h3stehab Tax Amount in Local Currency 3
fwbassol Tax Base Amount in Document Currency
fwbashab Tax Base Amount in Document Currency
hwbassol Tax Base Amount in Local Currency
hwbashab Tax Base Amount in Local Currency
h2bassol Tax Base Amount in Local Currency 2
h2bashab Tax Base Amount in Local Currency 2
h3bassol Tax Base Amount in Local Currency 3
h3bashab Tax Base Amount in Local Currency 3
lwbas Tax Base in Reporting Currency
lwste Tax Amount in Reporting Currency
kbetr Tax Rate
Column Name Description
Column Name Description
vatdate Tax Reporting Date
Column Name Description
shkzg Debit/Credit Indicator Show values
bstat Document Status Show values
Column Name Description Domain name
lstml Country/Region for Tax Report LAND1
knumh Number of the Condition Record KNUMH
txkrs Exchange Rate for Taxes KURSF
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FIS_CDS_BSET_EV.BUKRS == T001.BUKRS
  • FIS_CDS_BSET_EV.MANDT == T001.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • FIS_CDS_BSET_EV.BUKRS == SKB1.BUKRS
  • FIS_CDS_BSET_EV.HKONT == SKB1.SAKNR
  • FIS_CDS_BSET_EV.MANDT == SKB1.MANDT
Condition type
  • Condition Type
  • ?
  • ?
  • Client
  • FIS_CDS_BSET_EV.KSCHL == T685.KSCHL
  • FIS_CDS_BSET_EV.[column in domain "KVEWE"] == T685.KVEWE
  • FIS_CDS_BSET_EV.[column in domain "KAPPL"] == T685.KAPPL
  • FIS_CDS_BSET_EV.MANDT == T685.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • FIS_CDS_BSET_EV.MWSKZ == T007A.MWSKZ
  • FIS_CDS_BSET_EV.MANDT == T007A.MANDT
  • FIS_CDS_BSET_EV.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Tax Jurisdiction
  • Client
  • ?
  • FIS_CDS_BSET_EV.TXJCD == TTXJ.TXJCD
  • FIS_CDS_BSET_EV.MANDT == TTXJ.MANDT
  • FIS_CDS_BSET_EV.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Currency Key
  • Client
  • Currency Key
  • FIS_CDS_BSET_EV.MANDT == TCURC.MANDT
  • FIS_CDS_BSET_EV.WAERS == TCURC.WAERS