FAC_DART_Z3_TAX_LINEITEM_BKPF

Tax Line Item with BSTAT <> D/M | view: FAC_DZTAXBKPF | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPFBSETKONPTTXDT001TKA02T005
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Tax Line Item
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
TaxAmount null
💲 Additional Currency 1 (AdditionalCurrency1):
TaxAmountInAdditionalCurrency1 null
TaxBaseAmtInAdditionalCrcy1 null
💲 Additional Currency 2 (AdditionalCurrency2):
TaxAmountInAdditionalCurrency2 null
TaxBaseAmtInAdditionalCrcy2 null
💲 Reporting Currency (CountryCurrency):
TaxRate null
ABSTaxRate null
TaxAmountInCountryCrcy null
TaxBaseAmountInCountryCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReturnDate Date on Which the Tax Return Was Made
TaxReturnExecutionTime Time of Program Run for the Tax Return
TaxReportingDate Reporting Date for Tax Report
TaxDeterminationDate Date for Determining Tax Rates
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
TaxResultManualModification Tax Result Has Been Modified Manually Show values
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
ExternalTaxSystemActive Indicator: External tax system active CHAR1
TaxItemGroup Group Indicator for Tax Line Items NUM03
TransactionTypeDetermination Transaction Key CHAR3
ConditionRecord Number of the Condition Record KNUMH
VATRegistration VAT Registration Number STCEG
DestinationCountry Country/Region of Destination for Delivery of Goods LAND1
SupplyingCountry Supplying Country/Region for Delivery of Goods LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
BusinessPlace Business Place J_1BBRANCH
LowestLevelTaxJurisdiction Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax TXJCD
TaxJurisdictionLevel Tax jurisdiction code level CHAR1
TaxItemAcctgDocItemRef Tax document item number NUM6
TaxCountry Tax Reporting Country/Region LAND1
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == T001.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODECOUNTRY == T005.LAND1
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.DOCUMENTCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COUNTRYCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == TCURC.MANDT
Condition type
  • ?
  • Condition Type
  • Client
  • ?
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.[column in domain "KVEWE"] == T685.KVEWE
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.CONDITIONTYPE == T685.KSCHL
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == T685.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.[column in domain "KAPPL"] == T685.KAPPL
Reporting Currency
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.DOCUMENTCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COUNTRYCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.DOCUMENTCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COUNTRYCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == TCURC.MANDT
General Ledger Account
  • Client
  • Company Code
  • General Ledger Account
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == SKB1.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.GLACCOUNT == SKB1.SAKNR
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.TAXCALCULATIONPROCEDURE == T683.KALSM
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == T683.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.[column in domain "KAPPL"] == T683.KAPPL
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on sales/purchases code
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == T007A.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax Jurisdiction
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.MANDT == TTXJ.MANDT
  • FAC_DART_Z3_TAX_LINEITEM_BKPF.TAXJURISDICTION == TTXJ.TXJCD