C_PMRPCapacityInspectorPanel

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 C_PMRPCapacityInspectorPanel.
-- 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.
-- Parameters: P_PMRPSimulation : pmrp_simulation_id, P_BucketInternalID : pmrp_bucket_id, P_PMRPParentNodeID : cr_objid

CREATE VIEW C_PMRPCapacityInspectorPanel AS
SELECT
  PMRPSimulation,
  PMRPNodeID,
  PMRPRsceGrpHierNodeType,
  CapacityCategory,
  BucketInternalID,
  PMRPParentNodeID,
  PMRPRsceGrpHierParentNodeType,
  R_PMRPRsceBcktAggrgdHierNode._Resource.PMRPResourceInternalID AS PMRPResourceInternalID,
  PMRPAvailableCapacity,
  PMRPCapacityDemandQuantity,
  PMRPAvailableCapacity - PMRPCapacityDemandQuantity AS PMRPCapacityDeltaQty,
  CapacityQuantityUnit,
  PMRPResourceDisregardIssStatus,
  PMRPReferencePlan,
  Plant,
  R_PMRPRsceBcktAggrgdHierNode._Bucket.PMRPBucketCategory AS PMRPBucketCategory,
  case when PMRPRsceGrpHierNodeType = 'G' then _WorkCenterGroupType.WorkCenterGroup else R_PMRPRsceBcktAggrgdHierNode._Resource.WorkCenter end as WorkCenter AS WorkCenterendasWorkCenter
FROM R_PMRPRsceBcktAggrgdHierNode
LEFT OUTER JOIN I_WorkCenterGroup AS _WorkCenterGroupType ON _WorkCenterGroupType.WorkCenterGroupTypeCode = PMRPRsceGrpHierNodeType AND _WorkCenterGroupType.WorkCenterGroupInternalID = PMRPNodeID  -- association [0..1]
;