C_Supinvlistinvoiceall

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 C_Supinvlistinvoiceall.
-- 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: CSIINVOICEALL

CREATE VIEW C_Supinvlistinvoiceall AS
SELECT
  active.SupplierInvoice AS SupplierInvoice,
  active.FiscalYear AS FiscalYear,
  active.SupplierInvoiceUUID AS SupplierInvoiceUUID,
  active.InvoicingParty AS InvoicingParty,
  active.CompanyCode AS CompanyCode,
  active.DocumentDate AS DocumentDate,
  active.PostingDate AS PostingDate,
  active.DocumentCurrency AS DocumentCurrency,
  active.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  active.DueCalculationBaseDate AS DueCalculationBaseDate,
  active.CashDiscount1Days AS CashDiscount1Days,
  active.CashDiscount1Percent AS CashDiscount1Percent,
  active.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  active.CreatedByUser AS CreatedByUser,
  active.DocumentHeaderText AS DocumentHeaderText,
  active.CashDiscount1DueDate AS CashDiscount1DueDate,
  active.InvoiceGrossAmount AS InvoiceGrossAmount,
  active.SupplierInvoiceProcessingMode AS SupplierInvoiceProcessingMode,
  active.InvoiceStatusAndOrigin AS InvoiceStatusAndOrigin,
  active.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  active.SupplierInvoiceStatusDesc AS SupplierInvoiceStatusDesc,
  active.SupplierInvoiceOriginDesc AS SupplierInvoiceOriginDesc,
  active._SupplierInvoiceStsOriginText.InvoiceStatusAndOriginDesc AS InvoiceStatusAndOriginDesc,
  'X' AS IsActiveEntity,
  active.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM C_SupInvListActiveInvoices AS active
LEFT OUTER JOIN I_SupplierInvoiceStatusText AS _SupplierInvoiceStatusText ON SupplierInvoiceStatus = _SupplierInvoiceStatusText.SupplierInvoiceStatus AND _SupplierInvoiceStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceStsAndOrign AS _SupplierInvoiceStsAndOrign ON SupplierInvoice = _SupplierInvoiceStsAndOrign.SupplierInvoice AND FiscalYear = _SupplierInvoiceStsAndOrign.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStsOriginText AS _SupplierInvoiceStsOriginText ON InvoiceStatusAndOrigin = _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin AND _SupplierInvoiceStsOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
-- UNION ALL with additional select branch(es): C_SupInvListDrafts
;