I_PMRPResource

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_PMRPResource.
-- 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: IPMRPRES

CREATE VIEW I_PMRPResource AS
SELECT
  reference_id AS PMRPReferencePlan,
  resource_id AS PMRPResourceInternalID,
  resource_name AS PMRPResourceName,
  factory_calendar_id AS FactoryCalendar,
  Plant,
  workcenter_id AS WorkCenterInternalID,
  workcenter_name AS WorkCenter,
  capacity_planner AS CapacityResponsiblePlanner,
  capacity_category AS CapacityCategory,
  base_unit AS CapacityBaseQtyUnit,
  display_unit AS CapacityQuantityUnit,
  Numerator,
  Denominator
FROM pmrp_resource
LEFT OUTER JOIN I_PMRPReferencePlan AS _ReferencePlan ON _ReferencePlan.PMRPReferencePlan = PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN I_PMRPCapacityWorkCenterText AS _WorkCenterText ON _WorkCenterText.PMRPReferencePlan = PMRPReferencePlan AND _WorkCenterText.PMRPResourceInternalID = PMRPResourceInternalID  -- association [1..1]
;