I_PMRPSimulationResource

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_PMRPSimulationResource.
-- 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.

CREATE VIEW I_PMRPSimulationResource AS
SELECT
  sim.simulation_id AS PMRPSimulation,
  res.resource_id AS PMRPResourceInternalID,
  sim.reference_id AS PMRPReferencePlan,
  coalesce(sim_res.disregard_status, ' ') AS PMRPResourceDisregardIssStatus,
  coalesce(sim_res.disregard_reason_code, ' ') AS PMRPResourceDisregardIssReason,
  sim.resource_overload_tolerance AS PMRPRsceOverloadTolerancePct,
  res.plant AS Plant,
  res.display_unit AS CapacityQuantityUnit,
  res.numerator AS Numerator,
  res.denominator AS Denominator
FROM pmrp_simulation AS sim
INNER JOIN pmrp_resource AS res ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pmrp_sim_res AS sim_res ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PMRPSimulation AS _Simulation ON _Simulation.PMRPSimulation = PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_PMRPReferencePlan AS _ReferencePlan ON _ReferencePlan.PMRPReferencePlan = PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN I_PMRPResource AS _Resource ON _Resource.PMRPReferencePlan = PMRPReferencePlan AND _Resource.PMRPResourceInternalID = PMRPResourceInternalID  -- association [1..1]
;