I_CFinRpldSupplierInvoiceItem

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_CFinRpldSupplierInvoiceItem.
-- 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: ICFINRSIITEM

CREATE VIEW I_CFinRpldSupplierInvoiceItem AS
SELECT
  cfin_av_si_item.fins_logsys AS SenderLogicalSystem,
  cast(cfin_av_si_item.belnr as fins_cfin_av_rpld_suplr_invc preserving type ) AS CFinRpldSupplierInvoice,
  cfin_av_si_item.gjahr AS FiscalYear,
  cast(cfin_av_si_item.buzei as fins_cfin_av_rpld_suplr_iv_itm preserving type ) AS CFinRpldSupplierInvoiceItem,
  cast(cfin_av_si_item.ebeln as fins_cfin_av_rpld_purg_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast(cfin_av_si_item.ebelp as fins_cfin_av_rpld_purg_doc_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  cfin_av_si_item.mwskz AS TaxCode,
  cfin_av_si_item.matnr AS PurchaseOrderItemMaterial,
  cfin_av_si_item.wrbtr AS SupplierInvoiceItemAmount,
  I_CFinRpldSupplierInvoice.DocumentCurrency AS DocumentCurrency,
  cfin_av_si_item.werks AS Plant,
  cfin_av_si_item.menge AS QuantityInPurchaseOrderUnit,
  cfin_av_si_item.bstme AS PurchaseOrderQuantityUnit,
  cfin_av_si_item.lifnr AS FreightSupplier,
  cfin_av_si_item.tbtkz AS IsSubsequentDebitCredit,
  cfin_av_si_item.bprme AS PurchaseOrderPriceUnit,
  cfin_av_si_item.bpmng AS QtyInPurchaseOrderPriceUnit
FROM cfin_av_si_item
INNER JOIN I_CFinRpldSupplierInvoice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CFinRpldSupplierInvoice AS _SupplierInvoice ON CFinRpldSupplierInvoice = _SupplierInvoice.CFinRpldSupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear AND SenderLogicalSystem = _SupplierInvoice.SenderLogicalSystem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PurchaseOrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurOrdPriceUnitOfMeasure ON PurchaseOrderPriceUnit = _PurOrdPriceUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldSupplierInvoiceItem AS _Extension ON CFinRpldSupplierInvoice = _Extension.CFinRpldSupplierInvoice AND SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND FiscalYear = _Extension.FiscalYear AND CFinRpldSupplierInvoiceItem = _Extension.CFinRpldSupplierInvoiceItem  -- association [1..1]
;