I_ZA_StRpTaxItemCube

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_ZA_StRpTaxItemCube.
-- 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: ISRZATAXITEMC

CREATE VIEW I_ZA_StRpTaxItemCube AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube.TaxBox AS TaxBox,
  I_StRpTaxItemBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  Taxgroupingversion.verstax AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItemBoxCube.DocumentDate AS DocumentDate,
  I_StRpTaxItemBoxCube.PostingDate AS PostingDate,
  I_StRpTaxItemBoxCube.ReportingDate AS ReportingDate,
  _AccountingDocument._CompanyCode.VATRegistration AS VATRegistration,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  NumberOfDocuments,
  stazf AS CashDiscountIsDeductible,
  I_StRpTaxItemBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  case when _DebtorCreditorRblsPyblsItem._Customer.Customer <> '' and I_StRpTaxItemBoxCube.TaxType = 'A' then case when Knas.stceg = '' then case when _DebtorCreditorRblsPyblsItem._Customer.VATRegistration = '' then case when _DebtorCreditorRblsPyblsItem._Customer.TaxNumber1 <> '' then _DebtorCreditorRblsPyblsItem._Customer.TaxNumber1 else case when _DebtorCreditorRblsPyblsItem._Customer.TaxNumber2 <> '' then _DebtorCreditorRblsPyblsItem._Customer.TaxNumber2 else case when _DebtorCreditorRblsPyblsItem._Customer.TaxNumber5 <> '' then _DebtorCreditorRblsPyblsItem._Customer.TaxNumber5 end end end else _DebtorCreditorRblsPyblsItem._Customer.VATRegistration end else Knas.stceg end else case when _DebtorCreditorRblsPyblsItem._Supplier.Supplier <> '' and I_StRpTaxItemBoxCube.TaxType = 'V' then case when Lfas.stceg = '' then case when _DebtorCreditorRblsPyblsItem._Supplier.VATRegistration = '' then case when _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber1 <> '' then _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber1 else case when _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber2 <> '' then _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber2 else case when _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber5 <> '' then _DebtorCreditorRblsPyblsItem._Supplier.TaxNumber5 end end end else _DebtorCreditorRblsPyblsItem._Supplier.VATRegistration end else Lfas.stceg end end end as CustomerSupplierVATRegn AS stcegendendendasCustomerSupplierVATRegn,
  DocumentReferenceID,
  TaxRate,
  ReportingCountry,
  I_StRpTaxItemBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxItemBoxCube.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxItemBoxCube.ReferenceDocumentType AS ReferenceDocumentType,
  _AccountingDocument._CompanyCode.Country AS Country,
  I_StRpTaxItemBoxCube._AccountingDocument.ReversalReason AS ReversalReason,
  case when _DebtorCreditorRblsPyblsItem._Customer.Customer <> '' then _DebtorCreditorRblsPyblsItem._Customer.Country when _DebtorCreditorRblsPyblsItem._Supplier.Supplier <> '' then _DebtorCreditorRblsPyblsItem._Supplier.Country end as BusinessPartnerCountry AS CountryendasBusinessPartnerCountry,
  _DebtorCreditorRblsPyblsItem._Customer.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerName,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  I_StRpTaxItemBoxCube._AccountingDocument AS _AccountingDocument,
  _DebtorCreditorRblsPyblsItem._Customer.Customer AS Customer,
  _DebtorCreditorRblsPyblsItem._Supplier.Supplier AS Supplier
LEFT OUTER JOIN P_CountOfSameTaxCodeLines ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RetrieveMRNValues ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_KNAS_GLO AS Knas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_LFAS_GLO AS Lfas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TimeDepdntVersAssgmtNext AS Taxgroupingversion ON /* join condition not captured in parsed metadata */
;