I_ExternalVATItemCube

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 I_ExternalVATItemCube.
-- 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.

CREATE VIEW I_ExternalVATItemCube AS
SELECT
  Item.ExternalTaxHeaderUUID AS ExternalTaxHeaderUUID,
  Item.ExternalTaxItemUUID AS ExternalTaxItemUUID,
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.TaxationType AS TaxationType,
  _Header.FiscalPeriod AS FiscalPeriod,
  _Header.ReferenceDocumentType AS ReferenceDocumentType,
  _Header.OriginalReferenceDocument AS OriginalReferenceDocument,
  _Header.PostingDate AS PostingDate,
  _Header.DocumentDate AS DocumentDate,
  _Header.TaxReportingDate AS TaxReportingDate,
  case when _Header.TaxReportingDate = '00000000' then _Header.PostingDate else _Header.TaxReportingDate end as ReportingDate AS TaxReportingDateendasReportingDate,
  _Header.TaxFulfillmentDate AS TaxFulfillmentDate,
  _Header.AccountingDocumentType AS AccountingDocumentType,
  _Header.ReverseDocument AS ReverseDocument,
  _Header.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _Header.IsReversed AS IsReversed,
  _Header.IsReversal AS IsReversal,
  _Header.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  _Header.DocumentReferenceID AS DocumentReferenceID,
  _Header.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  _Header.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _Header.SenderCompanyCode AS SenderCompanyCode,
  _Header.SenderAccountingDocument AS SenderAccountingDocument,
  _Header.SenderFiscalYear AS SenderFiscalYear,
  _Header.SenderLogicalSystem AS SenderLogicalSystem,
  _Header.AccountingDocumentCategory AS AccountingDocumentCategory,
  Item.TaxSection AS TaxSection,
  Item.BusinessPlace AS BusinessPlace,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.Supplier AS Supplier,
  Item.Customer AS Customer,
  Item.BusinessPartner AS BusinessPartner,
  Item.DocumentItemText AS DocumentItemText,
  Item.ClearingDate AS ClearingDate,
  Item.ClearingJournalEntry AS ClearingJournalEntry,
  Item.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  Item.ClearingItem AS ClearingItem,
  Item.Ledger AS Ledger,
  Item.LedgerGroup AS LedgerGroup,
  Item.GLAccount AS GLAccount,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.SpecialGLTransactionType AS SpecialGLTransactionType,
  Item.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  Item.InvoiceReference AS InvoiceReference,
  Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  Item.InvoiceItemReference AS InvoiceItemReference,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.AdditionalCurrency1 AS AdditionalCurrency1,
  Item.AdditionalCurrency2 AS AdditionalCurrency2,
  Item.CountryCurrency AS CountryCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  Item.CashDiscountAmount AS CashDiscountAmount,
  Item.TaxCode AS TaxCode,
  Item.VATRegistration AS VATRegistration,
  Item.TaxJurisdiction AS TaxJurisdiction,
  Item.TaxRate AS TaxRate,
  Item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Item.TaxCountry AS TaxCountry,
  Item.TaxReturnCountry AS TaxReturnCountry,
  Item.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  Item.ConditionType AS ConditionType,
  Item.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  Item.TaxItemGroup AS TaxItemGroup,
  Item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  Item.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  Item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Item.TaxAmount AS TaxAmount,
  Item.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  Item.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  Item.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  Item.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  Item.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy
FROM I_ExternalTaxItem AS Item
LEFT OUTER JOIN I_ExternalTaxHeader AS _Header ON _Header.ExternalTaxHeaderUUID = Item.ExternalTaxHeaderUUID AND _Header.CompanyCode = Item.CompanyCode AND _Header.AccountingDocument = Item.AccountingDocument AND _Header.FiscalYear = Item.FiscalYear  -- association [1..1]
;