P_MaterialDemandForecast

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 P_MaterialDemandForecast.
-- 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: PMATLDMNDFCST

CREATE VIEW P_MaterialDemandForecast AS
SELECT
  Product,
  Plant,
  MRPArea,
  cast('' as abap.char(10)) AS MaterialDocumentYear,
  cast('' as abap.char(10)) AS MaterialDocument,
  cast('' as abap.char(10)) AS MaterialDocumentItem,
  cast('' as abap.char(10)) AS MaterialDocumentRecordType,
  WorkingDayDate AS PostingDate,
  PlannedQuantity AS QuantityInBaseUnit,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  cast('' as abap.char(10)) AS StorageLocation,
  cast('' as abap.char(10)) AS Supplier,
  cast('' as abap.char(10)) AS MRPAreaCategory,
  _DDProdCF.TotalNoOfDays AS MaterialkeyProduct,
  _DDProdCF.TotalNoOfDays AS TotalNoOfDays
FROM P_DailyPlndIndepRqmt AS _DPIR
LEFT OUTER JOIN P_DDProductCalcFields AS _DDProdCF ON Product = _DDProdCF.Material AND Plant = _DDProdCF.Plant AND MRPArea = _DDProdCF.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Product = _Material.Material  -- association [1..1]
-- UNION with additional select branch(es): P_WeeklyPlndIndepRqmtByDate, P_MonthlyPlndIndepRqmtByDate
;