C_MultiLevelOrderReport

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_MultiLevelOrderReport.
-- 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 C_MultiLevelOrderReport AS
SELECT
  PeggingRoot,
  AggregatedPeggingNode,
  AggregatedPeggingParentNode,
  DemandMRPElementCategory,
  DemandMRPElement,
  DemandMRPElementItem,
  DemandMRPElementScheduleLine,
  SupplyMRPElementCategory,
  SupplyMRPElement,
  SupplyMRPElementItem,
  SupplyMRPElementScheduleLine,
  MRPElementAvailyOrRqmtDate,
  DemandMRPElementDate,
  Product,
  Product AS Material,
  _MaterialText[ 1: Language = $session.system_language ].MaterialName AS MaterialName,
  MRPPlant,
  _Plant.PlantName AS PlantName,
  MRPArea,
  _MRPArea.MRPAreaText AS MRPAreaText,
  MRPPlanningSegmentType,
  MRPPlanningSegment,
  MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  MaterialBaseUnit,
  DynamicPeggingQuantity,
  RequiredQuantity,
  CriticalPeggingQuantity,
  MRPElementMissingQuantity,
  MRPElementDelayedQuantity,
  DmndMRPElmntAdjustedRqmtDate,
  MaximumDelayInDays,
  TotalDelayInDays,
  PeggingRootItem,
  NumberOfPeggingWarnings,
  NumberOfPeggingErrors,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _UnitOfMeasure.UnitOfMeasure_E AS UnitOfMeasureCommercialName,
  cast( '' as char15 ) AS UICT_BufferUpdate,
  _Root(P_MRPElement:$parameters.P_MRPElement, P_MRPElementCategory:$parameters.P_MRPElementCategory).MRPPlant AS UICT_RootNodeMRPPlant,
  _ParentDetail(P_MRPElement:$parameters.P_MRPElement, P_MRPElementCategory:$parameters.P_MRPElementCategory).SupplyMRPElement as SourceMRPElement AS SupplyMRPElementasSourceMRPElement
FROM I_MatlSupDmndAggrgdPegging
LEFT OUTER JOIN C_MultiLevelOrderReport AS _Parent ON _Line.PeggingRoot = _Parent.PeggingRoot AND _Line.AggregatedPeggingParentNode = _Parent.AggregatedPeggingNode  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _DemMRPElementCategoryText ON _DemMRPElementCategoryText.MRPElementCategory = DemandMRPElementCategory AND _DemMRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _SupMRPElementCategoryText ON _SupMRPElementCategoryText.MRPElementCategory = SupplyMRPElementCategory AND _SupMRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = Product  -- association [0..*]
LEFT OUTER JOIN C_MRPController AS _MRPController ON _MRPController.Plant = MRPPlant AND _MRPController.MRPController = MRPController  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = MaterialBaseUnit  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = MRPPlant  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON _MRPArea.MRPArea = MRPArea  -- association [0..1]
LEFT OUTER JOIN I_MatlSupDmndAggrgdPegging AS _Root ON _Root.PeggingRoot = PeggingRoot AND _Root.AggregatedPeggingParentNode = 0 AND _Root.PeggingRootItem = _Line.PeggingRootItem  -- association [0..1]
;