I_CacheShortageStatistic

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_CacheShortageStatistic.
-- 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: ICACHESHRTST

CREATE VIEW I_CacheShortageStatistic AS
SELECT
  pph_cache_shrtst.mrpplant AS MRPPlant,
  pph_cache_shrtst.material AS Material,
  pph_cache_shrtst.mrparea AS MRPArea,
  pph_cache_shrtst.mrpplanningsegmenttype AS MRPPlanningSegmentType,
  pph_cache_shrtst.mrpplanningsegmentnumber AS MRPPlanningSegment,
  pph_cache_shrtst.materialshortageprofile AS MaterialShortageProfile,
  pph_cache_shrtst.materialshortageprof_cnt AS MaterialShortageProfileCount,
  pph_cache_shrtst.materialshortagestartdate AS MaterialShortageStartDate,
  pph_cache_shrtst.materialshortageenddate AS MaterialShortageEndDate,
  pph_cache_shrtst.materialshortagequantity AS MaterialShortageQuantity,
  pph_cache_shrtst.materialshortageduration AS MaterialShortageDuration,
  pph_cache_shrtst.materialshortagedurninworkdays AS MaterialShortageDurnInWorkdays,
  pph_cache_shrtst.daysofsupplycoveragepercent AS DaysOfSupplyCoveragePercent,
  pph_cache_shrtst.minavailableqtyatshortage AS MinAvailableQtyAtShortage,
  pph_cache_shrtst.minavailableqtyovercomplhrzn AS MinAvailQtyOverCompleteHrzn,
  pph_cache_shrtst.daysofsupplyduration AS DaysOfSupplyDuration,
  pph_cache_shrtst.matmaxcoveragedurninworkdays AS MatlMaxCoverageDurnInWorkdays,
  pph_cache_shrtst.numberofshortagespersegment AS NumberOfShortagesPerSegment,
  pph_cache_shrtst.materialfirstuncoveragedate AS MaterialFirstShortageDate,
  pph_cache_shrtst.materialfirstuncoveragedateqty AS MaterialFirstShortageDateQty,
  pph_cache_shrtst.daysofsupplydurdaysdigit2 AS IntraDaySupplyDuration,
  pph_cache_shrtst.receiptdayssupply AS ReceiptDaysSupplyDuration,
  pph_cache_shrtst.receiptdayssupplycriticality AS ReceiptDaysSupplyCriticality,
  pph_cache_shrtst.daysofsupplycriticality AS DaysOfSupplyCriticality,
  pph_cache_shrtst.stockdayssupply AS StockDaysSupplyDuration,
  pph_cache_shrtst.stockdayssupplycriticality AS StockDaysSupplyCriticality,
  pph_cache_shrtst.stockintradayssupply AS StockIntraDaySupplyDuration,
  _MaterialShortageDefinition.EvaluationHorizonInDays AS EvaluationHorizonInDays,
  _MaterialShortageDefinition.MaterialShortageDefinitionName AS MaterialShortageDefinitionName
FROM pph_cache_shrtst
LEFT OUTER JOIN I_MaterialShortageDefinition AS _MaterialShortageDefinition ON MaterialShortageProfile = _MaterialShortageDefinition.MaterialShortageProfile AND MaterialShortageProfileCount = _MaterialShortageDefinition.MaterialShortageProfileCount  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON MRPPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
;