I_ZA_StRpRevenueExpenseLineC

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_StRpRevenueExpenseLineC.
-- 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: ISRZARVEXLINENC

CREATE VIEW I_ZA_StRpRevenueExpenseLineC AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxBox AS TaxBox,
  I_StRpTaxItemBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  Taxgroupingversion.verstax AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItemBoxCube.TaxRate AS TaxRate,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  I_StRpTaxItemBoxCube.PostingDate AS PostingDate,
  I_StRpTaxItemBoxCube.ReportingDate AS ReportingDate,
  I_StRpTaxItemBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxItemBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  _MaterialText.MaterialName AS MaterialName,
  _AccountingDocument._CompanyCode.VATRegistration AS VATRegistration,
  FinancialAccountType,
  I_ReceivablesPayablesItem.Material AS Material,
  stazf AS CashDiscountIsDeductible,
  CashDiscountAmtInCoCodeCrcy,
  ReportingCountry,
  case when DocumentItemText <> '' then DocumentItemText else case when AccountingDocumentHeaderText <> '' then AccountingDocumentHeaderText else _MaterialText.MaterialName end end as DocumentItemText AS MaterialNameendendasDocumentItemText,
  ReportingCurrency,
  _Customer.Customer AS Customer,
  _Supplier.Supplier AS Supplier,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerName
FROM I_StRpTaxItemBoxCube
LEFT OUTER JOIN I_ReceivablesPayablesItem 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_TimeDepdntVersAssgmtNext AS Taxgroupingversion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [1..*]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;