I_MpFilterProcurement

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_MpFilterProcurement.
-- 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: IMPFLTPRCMNT

CREATE VIEW I_MpFilterProcurement AS
SELECT
  cast(ProcStruct.MasterProject as /cpd/cpm_comlprojid) AS MasterProject,
  cast(ProcStruct.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  cast(ProcStruct.Supplier as md_supplier) AS Supplier,
  cast(ProcStruct.PurchaseOrder as ebeln) AS PurchaseOrder,
  ProcStruct.PurchaseRequisition AS PurchaseRequisition,
  ProcStruct.Material AS Material,
  ProcStruct.ReleaseCode AS ReleaseCode
FROM P_MPProcurement AS ProcStruct
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MstrProjProcurementStrElm AS _ControllingObject ON ControllingObjectExternalID = _ControllingObject.ControllingObjectExternalID AND MasterProject = _ControllingObject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPPrchsRqstnVH AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition AND MasterProject = _PurchaseRequisition.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPPrchsOrdrVH AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder AND MasterProject = _PurchaseOrder.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPPRMaterialVH AS _Material ON Material = _Material.Material AND MasterProject = _Material.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPPRSupplierVH AS _Supplier ON Supplier = _Supplier.Supplier AND MasterProject = _Supplier.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_MPReleaseCode AS _ReleaseCode ON _ReleaseCode.PurchasingReleaseStatus = ReleaseCode  -- association [0..1]
;