I_ResourceRequest

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_ResourceRequest.
-- 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: IRSRCEREQUEST

CREATE VIEW I_ResourceRequest AS
SELECT
  demand_key AS ResourceRequestUUID,
  mp_id AS EngagementProject,
  wp_id AS WorkPackage,
  status AS ResourceRequestStatus,
  start_date AS StartDate,
  end_date AS EndDate,
  created_by AS CreatedByUser,
  cast( created_on as /cpd/cpm_createdon ) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast( changed_on as /cpd/cpm_changedon ) AS LastChangeDateTime
FROM /cpd/demand_hdr
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_ResourceRequestSkillTag AS _ResourceRequestSkillTag ON ResourceRequestUUID = _ResourceRequestSkillTag.ResourceRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_ResourceRequestPlanItem AS _ResourceRequestPlanItem ON ResourceRequestUUID = _ResourceRequestPlanItem.ResourceRequestUUID  -- association [0..*]
;