C_OpenCatalogProposal

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_OpenCatalogProposal.
-- 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: COCIPROPOSAL

CREATE VIEW C_OpenCatalogProposal AS
SELECT
  OpnCtlgItemPrpslID,
  OpnCtlgItemPrpslUniqueID,
  OpnCtlgItemPrpslMatGrp,
  OpnCtlgItemPrpslUnit,
  OpnCtlgItemPrpsStatus,
  OpnCtlgItemPrpsCrtnDte,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _OpenCatalogProposalDesc.OpnCtlgItemPrpslDesc AS OpnCtlgItemPrpslDesc,
  _OpenCatalogProposalSuplr.OpnCtlgItemPrpslSupplier AS OpnCtlgItemPrpslSupplier,
  I_OpenCatalogProposal.PurReqnCatalog AS PurReqnCatalog,
  LastChangeDate,
  _OpenCatalogProposalSuplr.AuthorizationGroup AS AuthorizationGroup
FROM I_OpenCatalogProposal
LEFT OUTER JOIN C_OpenCatalogProposalSuplr AS _OpenCatalogProposalSuplr ON OpnCtlgItemPrpslID = _OpenCatalogProposalSuplr.OpnCtlgItemPrpslID AND _OpenCatalogProposalSuplr.OpnCtlgPrpslDescSequenceNumber = '001'  -- association [1..1]
LEFT OUTER JOIN C_OpnCtlgItmPrpslSuplrVH AS _Supplier ON OpnCtlgItemPrpslSupplier = _Supplier.OpnCtlgItemPrpslSupplier  -- association [1..*]
LEFT OUTER JOIN C_OpenCatalogProposalDesc AS _OpenCatalogProposalDesc ON OpnCtlgItemPrpslID = _OpenCatalogProposalDesc.OpnCtlgItemPrpslID AND _OpenCatalogProposalDesc.OpnCtlgPrpslDescSequenceNumber = '001'  -- association [1..1]
LEFT OUTER JOIN C_OpnCtlgItmPrpslStatusVH AS _OpnCtlgItmPrpslStatusVH ON OpnCtlgItemPrpsStatus = _OpnCtlgItmPrpslStatusVH.DomainValue  -- association [0..1]
LEFT OUTER JOIN C_OpnCtlgItmPrpslDescVH AS _OpnCtlgItmPrpslDescVH ON OpnCtlgItemPrpslID = _OpnCtlgItmPrpslDescVH.OpnCtlgItemPrpslID AND OpnCtlgItemPrpslDesc = _OpnCtlgItmPrpslDescVH.OpnCtlgItemPrpslDesc  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON OpnCtlgItemPrpslMatGrp = _MaterialGroup.MaterialGroup  -- association [1..1]
;