I_MstrProjPurchaseRequisition

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_MstrProjPurchaseRequisition.
-- 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: IMSTRPROJPR

CREATE VIEW I_MstrProjPurchaseRequisition AS
SELECT
  PurchaseRequisition.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisition.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  WBSElement.MasterProject AS MasterProject,
  WBSElement.MasterProjectName AS MasterProjectName,
  WBSElement.MasterProjectItem AS MasterProjectItem,
  cast (WBSElement.WBSElementShortID as abap.char( 22 )) AS ControllingObjectExternalID,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.WBSElementShortID AS WBSElementShortID,
  WBSElement.WBSDescription AS WBSDescription,
  WBSElement.WBSDescription AS ControllingObjectDescription,
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  cast('' as ps_s4_aufnr) AS ProjectNetwork,
  cast('' as ps_s4_auftext) AS ProjectNetworkDescription,
  cast('' as abap.numc( 10 )) AS ProjectNetworkInternalID,
  cast('' as pt_vornr_receiver) AS NetworkActivity,
  cast('' as ps_s4_ltxa1) AS NetworkActivityDescription,
  cast('' as abap.numc( 8 )) AS NetworkActivityInternalID,
  cast('' as j_objnr) AS NetworkActivityObject
FROM I_PurReqnAcctAssgmt AS PurchaseRequisition
INNER JOIN I_MPWBSElement AS WBSElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_MPNetwork AS Network ON /* join condition not captured in parsed metadata */
INNER JOIN I_MPNetworkActivity AS NetworkActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterProject AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [1..1]
-- UNION with additional select branch(es): I_PurReqnAcctAssgmt
;