C_PMRPChangeInDemand

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_PMRPChangeInDemand.
-- 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 C_PMRPChangeInDemand AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  PMRPReferencePlan,
  TopLevelProduct,
  TopLevelMRPArea,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct.MRPController AS MRPController,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct._PMRPController.MRPControllerName AS MRPControllerName,
  _TopLevelProductText.MaterialName AS MaterialName,
  case when I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketCategory = 'M' then CONCAT_WITH_SPACE ( _Bucket._CalendarMonth._Text[Language = $session.system_language].CalendarMonthName , I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketYear ,1 ) else CONCAT_WITH_SPACE ( _Bucket._PMRPBucketCategory._Text[Language = $session.system_language].PMRPBucketCategoryText ,CONCAT_WITH_SPACE( CONCAT(I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketPeriod ,','), I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketYear ,1 ) ,1 ) end as PMRPBucketName AS PMRPBucketYear11endasPMRPBucketName,
  TopLevelPlant,
  _PlantTxt.PlantName AS PlantName,
  ReferenceRequiredQuantity,
  SimulatedRequiredQuantity,
  cast (( ReferenceRequiredQuantity - SimulatedRequiredQuantity ) as pmrp_req_quantity ) AS DeltaQuantity,
  UnitOfMeasure
FROM I_PMRPSimlnTopLevelDemandTP
LEFT OUTER JOIN C_PMRPSimulation AS _PMRPSimulation ON PMRPSimulation = _PMRPSimulation.PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantTxt ON TopLevelPlant = _PlantTxt.Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _TopLevelProductText ON TopLevelProduct = _TopLevelProductText.Material AND _TopLevelProductText.Language = $session.system_language  -- association [1..1]
;