I_MaterialSupplyDemandPegging

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_MaterialSupplyDemandPegging.
-- 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_MRPElementCategory : delkz, P_MRPElement : pph_del12

CREATE VIEW I_MaterialSupplyDemandPegging AS
SELECT
  PeggingRoot,
  PeggingNode,
  PeggingRootItem,
  DemandMRPElementCategory,
  DemandMRPElement,
  DemandMRPElementItem,
  DemandMRPElementScheduleLine,
  MatlCompRequirementDate AS DemandMRPElementDate,
  SupplyMRPElementCategory,
  SupplyMRPElement,
  SupplyMRPElementItem,
  SupplyMRPElementScheduleLine,
  PeggingParentNode,
  AggregatedPeggingNode,
  AggregatedPeggingParentNode,
  Product,
  MRPPlant,
  MRPArea,
  MRPPlanningSegmentType,
  MRPPlanningSegment,
  _MaterialPlant.MRPController AS MRPController,
  _MaterialPlant._Material.MaterialBaseUnit AS MaterialBaseUnit,
  Line.MRPElementStartDate AS MRPElementStartDate,
  Line.MRPAvailableQuantity AS MRPAvailableQuantity,
  Line.PeggingMessage AS PeggingMessage,
  Line.IssueDate AS IssueDate,
  MRPRequiredQuantityInBaseUnit AS RequiredQuantity,
  DynamicPeggingQuantity,
  MRPElementMissingQuantity,
  TotalDelayInDays,
  DmndMRPElmntAdjustedRqmtDate,
  NumberOfPeggingWarnings,
  NumberOfPeggingErrors
FROM I_MatlSupplyDemandPeggingBasic AS Line
LEFT OUTER JOIN I_MaterialSupplyDemandPegging AS _Parent ON Line.PeggingRoot = _Parent.PeggingRoot AND Line.PeggingParentNode = _Parent.PeggingNode  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON _MaterialPlant.Material = Product AND _MaterialPlant.Plant = MRPPlant  -- association [1..1]
LEFT OUTER JOIN I_MatlSupDmndPeggingMessage AS _Message ON _Message.PeggingRoot = PeggingRoot AND _Message.PeggingNode = PeggingNode  -- association [0..*]
;