P_PlndIndepRqmtItemHistByDate

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_PlndIndepRqmtItemHistByDate.
-- 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.

CREATE VIEW P_PlndIndepRqmtItemHistByDate AS
SELECT
  Material,
  ProductionPlant AS Plant,
  MRPArea,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  ForecastQuantity AS QuantityInBaseUnit,
  DeliveryDate AS PostingDate,
  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,
  cast('' as abap.char(10)) AS StorageLocation,
  cast('' as abap.char(10)) AS Supplier,
  cast('' as abap.char(10)) AS MRPAreaCategory,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _DDProdCF.TotalNoOfDays AS MaterialkeyMaterial,
  _DDProdCF.TotalNoOfDays AS TotalNoOfDays
FROM P_DailyPlndIndepReqmtHist
LEFT OUTER JOIN P_DDProductHorizCalcFields AS _DDProdCF ON Material = _DDProdCF.Material AND Plant = _DDProdCF.Plant AND MRPArea = _DDProdCF.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
-- UNION with additional select branch(es): P_WeeklyPlndIndepRqmtHistByDte, P_MnthlyPlndIndepRqmtHistByDte
;