I_CFinRpldSupplierInvoice

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_CFinRpldSupplierInvoice.
-- 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: ICFINRSIROOT

CREATE VIEW I_CFinRpldSupplierInvoice AS
SELECT
  cfin_av_si_root.fins_logsys AS SenderLogicalSystem,
  cast(cfin_av_si_root.belnr as fins_cfin_av_rpld_suplr_invc preserving type ) AS CFinRpldSupplierInvoice,
  cfin_av_si_root.gjahr AS FiscalYear,
  cfin_av_si_root.bldat AS DocumentDate,
  cfin_av_si_root.bukrs AS CompanyCode,
  cfin_av_si_root.rbstat AS SupplierInvoiceStatus,
  cfin_av_si_root.stblg AS ReverseDocument,
  cfin_av_si_root.stjah AS ReverseDocumentFiscalYear,
  cfin_av_si_root.ivtyp AS SupplierInvoiceOrigin,
  cfin_av_si_root.waers AS DocumentCurrency,
  cfin_av_si_root.vgart AS SuplrInvcTransactionCategory,
  cfin_av_si_root.lifnr AS InvoicingParty,
  cfin_av_si_root.cpudt AS CreationDate,
  cfin_av_si_root.logmx_uuid AS ElectronicInvoiceUUID,
  ' ' AS IsEndOfPurposeBlocked,
  cfin_av_si_root.xrech AS IsInvoice
FROM cfin_av_si_root
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CFinRpldSupplierInvoiceItem AS _Item ON SenderLogicalSystem = _Item.SenderLogicalSystem AND CFinRpldSupplierInvoice = _Item.CFinRpldSupplierInvoice AND FiscalYear = _Item.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldSupplierInvoice AS _Extension ON CFinRpldSupplierInvoice = _Extension.CFinRpldSupplierInvoice AND SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND FiscalYear = _Extension.FiscalYear  -- association [1..1]
;