C_PMRPChangeInCapacity

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_PMRPChangeInCapacity.
-- 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: CPMRPCHGINCAP

CREATE VIEW C_PMRPChangeInCapacity AS
SELECT
  PMRPSimulation,
  PMRPResourceInternalID,
  BucketInternalID,
  PMRPReferencePlan,
  WorkCenter,
  CapacityResponsiblePlanner,
  Plant,
  CapacityCategory,
  CapacityCategoryName,
  PMRPWorkCenterText,
  _PMRPCpTxt.CapacityResponsiblePlannerName AS CapacityResponsiblePlannerName,
  PlantName,
  case when PMRPBucketCategory = 'W' then concat_with_space( _Bucket._PMRPBucketCategory._Text[Language = $session.system_language].PMRPBucketCategoryText , concat_with_space( CONCAT ( cast ( _Bucket.PMRPBucketPeriod as abap.char(2) ) ,','), cast ( _Bucket.PMRPBucketYear as abap.char(4) ), 1 ), 1) else concat_with_space( _Bucket._CalendarMonth._Text[Language = $session.system_language].CalendarMonthName, cast ( _Bucket.PMRPBucketYear as abap.char(4) ) ,1) end as PMRPBucketName AS char41endasPMRPBucketName,
  concat_with_space(cast (AdaptedCapacityRateInPercent as abap.char(11)), '%', 1) AS AdaptedCapacityRateInPercent,
  CapacityQuantityUnit,
  PMRPAvailableCapacity AS PMRPProposedAvailableCapacity
FROM C_PMRPCapacity
LEFT OUTER JOIN C_PMRPSimulation AS _PMRPSimulation ON PMRPSimulation = _PMRPSimulation.PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_CapacityRespPlannerText AS _PMRPCpTxt ON CapacityResponsiblePlanner = _PMRPCpTxt.CapacityResponsiblePlanner AND Language = $session.system_language  -- association [1..1]
;