I_OpenCatalogProposalSuplr

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_OpenCatalogProposalSuplr.
-- 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: IOCICTLGSUP

CREATE VIEW I_OpenCatalogProposalSuplr AS
SELECT
  OpnCtlgItemPrpslID,
  OpnCtlgItemPrpslSupplier,
  OpnCtlgPrpslDescSequenceNumber,
  NetPriceAmount,
  Currency,
  SupplierMaterialNumber,
  OpnCtlgItemPrpslLeadTime,
  OpnCtlgItemPrpslUnitOfMeasure,
  OpnCtlgItemPrpslPriceUnitQty,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet,
  _OpenCatalogProposal.PurReqnCatalog AS PurReqnCatalog
FROM R_OpenCatalogProposalSupplier
LEFT OUTER JOIN I_OpenCatalogProposal AS _OpenCatalogProposal ON OpnCtlgItemPrpslID = _OpenCatalogProposal.OpnCtlgItemPrpslID  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OpnCtlgItemPrpslSupplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;