FAC_DART_Z3_TAX_LINEITEM_BASE

DDL: FAC_DART_Z3_TAX_LINEITEM_BASE SQL: FAC_DZTAXLNITMB Type: view
58 Fields 1 Data Sources 2 Associations

Tax - Line Items Base View

FAC_DART_Z3_TAX_LINEITEM_BASE is a CDS View that provides data about "Tax - Line Items Base View" in SAP S/4HANA. It reads from 1 data source (I_TaxItem) and exposes 58 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TaxItem TaxItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_TaxCode _TaxCode TaxItem.TaxCode = _TaxCode.TaxCode and $projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZTAXLNITMB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Tax - Line Items Base View view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Tax Item
FiscalPeriod _JournalEntry FiscalPeriod Tax period
PostingDate _JournalEntry PostingDate Posting Date for GR
TaxCode TaxCode Tax Code
TaxCalculationProcedure
GLAccount GLAccount General Ledger
TaxItemGroup TaxItemGroup Tax doc. item number
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ConditionRecord ConditionRecord Cond.Record No.
VATRegistration VATRegistration VAT Registration No.
DestinationCountry DestinationCountry Dest. Ctry/Reg
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
ConditionType ConditionType Condition type
TaxReturnDate TaxReturnDate
TaxReturnExecutionTime TaxReturnExecutionTime
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxRate TaxRate Tax Rate
TaxReturnCountry TaxReturnCountry Reporting C/R
TaxAmountInCountryCrcy TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
BusinessPlace BusinessPlace Business place
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxJurisdictionLevel TaxJurisdictionLevel Jurisdiction level
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef Tax doc. item number
TaxResultManualModification TaxResultManualModification Tax Modified
DebitCreditCode DebitCreditCode Single-Character Flag
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
DocumentCurrency DocumentCurrency Document Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CountryCurrency CountryCurrency Currency
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxCountry TaxCountry Tax Ctry/Reg.
_JournalEntry _JournalEntry
_AccountingDocument _AccountingDocument
_Currency _Currency
_GLAccount _GLAccount
_CompanyCodeCurrency _CompanyCodeCurrency
_CompanyCodeCountry _CompanyCodeCountry
_TaxJurisdiction _TaxJurisdiction
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem
_ReceivablesPayablesItem _ReceivablesPayablesItem
_TaxCode _TaxCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FAC_DART_Z3_TAX_LINEITEM_BASE.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FAC_DZTAXLNITMB

CREATE VIEW FAC_DART_Z3_TAX_LINEITEM_BASE AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  _JournalEntry.FiscalPeriod AS FiscalPeriod,
  _JournalEntry.PostingDate AS PostingDate,
  TaxCode,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TransactionTypeDetermination,
  ConditionRecord,
  VATRegistration,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  TaxReturnExecutionTime,
  TaxReportingDate,
  TaxRate,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  CompanyCodeCurrency,
  CompanyCodeCountry,
  DocumentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CountryCurrency,
  TaxRateValidityStartDate,
  TaxCountry
FROM I_TaxItem AS TaxItem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxItem.TaxCode = _TaxCode.TaxCode AND TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure  -- association [0..1]
;

Learn More