C_MaterialDailyDemand

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_MaterialDailyDemand.
-- 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: CMATDAILYDMND

CREATE VIEW C_MaterialDailyDemand AS
SELECT
  _DemandDrivenProduct.Material AS Material,
  _DemandDrivenProduct.Plant AS Plant,
  _DemandDrivenProduct.MRPArea AS MRPArea,
  _AvgDailyUsage.PostingDate AS PostingDate,
  _ActualValues.CurrentAvgDailyUsage AS CurrentAverageDailyUsage,
  case when (_AvgDailyUsage.PostingDate < _ProposalHeader.ProposalStartDate ) then cast(0 as abap.dec( 13, 3 )) end as PlndIndepRqmtQuantity AS dec133endasPlndIndepRqmtQuantity,
  cast(0 as abap.dec( 13, 3 )) AS DailyPlndIndepRqmtQuantity,
  cast(0 as abap.dec( 13, 3 )) AS WeeklyPlndIndepRqmtQtyPerDay,
  cast(0 as abap.dec( 13, 3 )) AS MonthlyPlndIndepRqmtQtyPerDay,
  cast(0 as abap.dec(13, 3)) AS TotalWeeklyPlndIndepRqmtQty,
  cast(0 as abap.dec(13, 3)) AS TotalMonthlyPlndIndepRqmtQty,
  sum(_PIRHist.QuantityInBaseUnit) AS PlndIndepRqmtQuantity,
  cast(0 as abap.dec( 13, 3 )) AS QuantityInBaseUnit,
  _ProposalHeader._BufMatPlant._Material.BaseUnit AS MaterialBaseUnit
FROM P_DailyWeeklyMnthlyPIRHistDate AS _PIRHist
LEFT OUTER JOIN I_MatlAvgDailyUsge1 AS _AvgDailyUsage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TimeDependentStockBuffer AS _ActualValues ON Material = _ActualValues.Material AND Plant = _ActualValues.Plant AND MRPArea = _ActualValues.MRPArea  -- association [1..*]
LEFT OUTER JOIN I_ProdBufLvlPrpslData AS _ProposalHeader ON Material = _ProposalHeader.Material AND Plant = _ProposalHeader.Plant AND MRPArea = _ProposalHeader.MRPArea AND _ProposalHeader.ProposalEndDate = '99991231' AND _ProposalHeader.ProposalStartDate <= $session.system_date  -- association [1..1]
-- UNION with additional select branch(es): P_DailyWeeklyMnthlyPIRHistDate
;