FAC_DART_Z3_TAX_LINEITEM

Tax - Line Items | view: FAC_DZTAXLNITM | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPFBSETKONPTTXDT685AT001TKA02T005T007SFINSC_LD_CMPFINSC_PERIOD
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
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
system_client Client
FiscalPeriod Fiscal Period POPER
TaxCodeName Tax Code Name TEXT50
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
TaxPercent null
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
DebitCreditCodeName Debit/Credit Code Name DDTEXT
TaxCountry Tax Reporting Country/Region LAND1
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FAC_DART_Z3_TAX_LINEITEM.COMPANYCODE == T001.BUKRS
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T005.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.COMPANYCODECOUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • Reporting Currency
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == TCURC.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM.COUNTRYCURRENCY == TCURC.WAERS
Condition type
  • Client
  • Condition Type
  • ?
  • ?
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T685.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.CONDITIONTYPE == T685.KSCHL
  • FAC_DART_Z3_TAX_LINEITEM.[column in domain "KAPPL"] == T685.KAPPL
  • FAC_DART_Z3_TAX_LINEITEM.[column in domain "KVEWE"] == T685.KVEWE
Reporting Currency
  • Client
  • Currency Key
  • Reporting Currency
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == TCURC.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_TAX_LINEITEM.COUNTRYCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T009.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.FISCALYEARVARIANT == T009.PERIV
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • FAC_DART_Z3_TAX_LINEITEM.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_TAX_LINEITEM.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == SKB1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T683.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • FAC_DART_Z3_TAX_LINEITEM.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_DART_Z3_TAX_LINEITEM.[column in domain "KAPPL"] == T683.KAPPL
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == T007A.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.TAXCODE == T007A.MWSKZ
  • FAC_DART_Z3_TAX_LINEITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
Tax Jurisdiction
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax Jurisdiction
  • FAC_DART_Z3_TAX_LINEITEM.MANDT == TTXJ.MANDT
  • FAC_DART_Z3_TAX_LINEITEM.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • FAC_DART_Z3_TAX_LINEITEM.TAXJURISDICTION == TTXJ.TXJCD