C_PMRPTopLevelDemandColumn

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_PMRPTopLevelDemandColumn.
-- 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: CPMRPTLDC

CREATE VIEW C_PMRPTopLevelDemandColumn AS
SELECT
  PMRPSimulation,
  TopLevelProduct,
  TopLevelPlant,
  TopLevelMRPArea,
  BucketInternalID,
  TopLevelDemandInternalID,
  cast (BucketInternalID as sstring) AS PMRPBucketName,
  _Bucket.PMRPBucketCategory AS PMRPBucketCategory,
  PMRPReferencePlan,
  UnitOfMeasure,
  SimulatedRequiredQuantity,
  ReferenceRequiredQuantity,
  cast (( ReferenceRequiredQuantity - SimulatedRequiredQuantity ) as pmrp_req_quantity ) AS DeltaQuantity,
  _DemandKPI.PMRPTopLvlDmndDeltaQuantity AS PMRPDeltaQuantity,
  AcceptedRequestedRatioInPct,
  _Bucket.PMRPBucketYear AS PMRPBucketYear,
  _Bucket.PMRPBucketPeriod AS PMRPBucketPeriod,
  _Bucket._PMRPBucketCategory._Text[Language = $session.system_language].PMRPBucketCategoryText AS PMRPBucketCategoryText
FROM I_PMRPSimlnTopLevelDemandTP
LEFT OUTER JOIN I_PMRPSimlnTopLevelDemandKPI AS _DemandKPI ON PMRPSimulation = _DemandKPI.PMRPSimulation AND TopLevelDemandInternalID = _DemandKPI.TopLevelDemandInternalID  -- association [1..1]
;