I_MaterialStockRangeOfCoverage

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_MaterialStockRangeOfCoverage.
-- 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_KeyDate : sydate, P_NumberOfDays : nsdm_roc_consideration_period

CREATE VIEW I_MaterialStockRangeOfCoverage AS
SELECT
  Material,
  RoC.Plant AS Plant,
  MaterialBaseUnit,
  MatlWrhsStkQtyInMatlBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  case $parameters.P_NumberOfDays when 0 then cast(0 as abap.dec(18,3)) else division(cast(MatlCnsmpnQtyInMatlBaseUnit as abap.dec(18,3)), $parameters.P_NumberOfDays, 2) end as MatlCnsmpnQtyAverage AS P_NumberOfDays2endasMatlCnsmpnQtyAverage,
  case when MatlWrhsStkQtyInMatlBaseUnit > 0 and MatlCnsmpnQtyInMatlBaseUnit > 0 then division(cast(MatlWrhsStkQtyInMatlBaseUnit as abap.dec(18,3)) * $parameters.P_NumberOfDays, cast(MatlCnsmpnQtyInMatlBaseUnit as abap.dec(18,3)), 2) else cast(0 as abap.dec(18,3)) end as RangeOfCoverageInDays AS dec183endasRangeOfCoverageInDays
FROM P_MaterialStockRoC2
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PlantMaterialCount AS _PlantCount ON Plant = _PlantCount.Plant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;