I_FORECASTDEMANDITEMHISTORY

CDS View
15 Fields 4 CDS Views

Forecast Demand Item History with Header

I_FORECASTDEMANDITEMHISTORY is a CDS View in S/4HANA. Forecast Demand Item History with Header. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_ForecastDemand view from COMPOSITE
P_ForecastDemand view left_outer COMPOSITE
P_ForecastDemand view union COMPOSITE
P_ForecastDemandItemHistory view from CONSUMPTION

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Forecast Forecast 1
KEY ForecastYearMonth ForecastYearMonth 1
_CalendarMonth _CalendarMonth 1
_YearMonth _YearMonth 1
CalendarMonth CalendarMonth 1
DemandPlanner DemandPlanner 1
ForecastDemandVersion ForecastDemandVersion 1
ForecastPeriodMode ForecastPeriodMode 1
ForecastYearQuarter ForecastYearQuarter 1
Material Material 1
MRPArea MRPArea 1
PlannedIndependentRequirement PlannedIndependentRequirement 1
ProductionPlant ProductionPlant 1
RequirementPlan RequirementPlan 1
RequirementType RequirementType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Forecast Demand Item History with Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FORECASTDEMANDITEMHISTORY (
    FORECAST,
    FORECASTYEARMONTH,
    _CALENDARMONTH,
    _YEARMONTH,
    CALENDARMONTH,
    DEMANDPLANNER,
    FORECASTDEMANDVERSION,
    FORECASTPERIODMODE,
    FORECASTYEARQUARTER,
    MATERIAL,
    MRPAREA,
    PLANNEDINDEPENDENTREQUIREMENT,
    PRODUCTIONPLANT,
    REQUIREMENTPLAN,
    REQUIREMENTTYPE,
    PRIMARY KEY (FORECAST, FORECASTYEARMONTH)
);

Learn More