I_ForecastDemandItemHistory

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_ForecastDemandItemHistory.
-- 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: IPPFCSTDMNDIHIST

CREATE VIEW I_ForecastDemandItemHistory AS
SELECT
  cast(ForecastHistory.laeda as laeda preserving type) AS LastChangeDate,
  cast(ForecastHistory.uzeit as uzeit preserving type) AS LastChangeTime,
  cast(coalesce(ForecastHistory.pdatu,'00000000') as lfdat_v preserving type) AS DeliveryDate,
  ForecastHeader.Material AS Material,
  ForecastHeader.ProductionPlant AS ProductionPlant,
  ForecastHeader.RequirementType AS RequirementType,
  ForecastHeader.RequirementPlan AS RequirementPlan,
  ForecastHeader.PlannedIndependentRequirement AS PlannedIndependentRequirement,
  ForecastHeader.MRPArea AS MRPArea,
  ForecastHeader.PlndIndepRqmtConsumptionStrgy AS PlndIndepRqmtConsumptionStrgy,
  ForecastHeader.PlndIndepRqmtIsActive AS PlndIndepRqmtIsActive,
  ForecastHeader.PlndIndepRqmtConsumptionAssgmt AS PlndIndepRqmtConsumptionAssgmt,
  ForecastHeader.PlndIndepRqmtUsage AS PlndIndepRqmtUsage,
  ForecastHeader.PlndIndepRqmtIsToBeDeleted AS PlndIndepRqmtIsToBeDeleted,
  ForecastHeader.ExternalRequirementPlan AS ExternalRequirementPlan,
  ForecastHeader.RequirementSegment AS RequirementSegment,
  cast((coalesce(ForecastHistory.aenam,' ')) as demandplanner preserving type) AS DemandPlanner,
  _PlannedCalendarPeriod.CalendarMonth AS CalendarMonth,
  _PlannedCalendarPeriod._YearMonth AS _YearMonth,
  _PlannedCalendarPeriod._CalendarMonth AS _CalendarMonth
FROM I_ForecastDemandHeader AS ForecastHeader
LEFT OUTER JOIN pbhi AS ForecastHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _PlannedCalendarPeriod ON ForecastHistory.pdatu = _PlannedCalendarPeriod.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_Material AS _MaterialMaster ON ForecastHeader.Material = _MaterialMaster.Material  -- association [1..1]
;