P_FORECASTDEMANDITEMHISTORY

CDS View
19 Fields 2 CDS Views

Private View for I_ForecastDemandItemHistory

P_FORECASTDEMANDITEMHISTORY is a CDS View in S/4HANA. Private View for I_ForecastDemandItemHistory. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_DailyWeeklyMnthlyPIRHist view_entity inner CONSUMPTION P_DailyWeeklyMnthlyPIRHist
P_PlndIndepRqmtItemHistory view_entity from CONSUMPTION PIR History P view

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Forecast Forecast 2
KEY ForecastPeriodMode ForecastPeriodMode 2
KEY ForecastYearMonth ForecastYearMonth 2
KEY LastChangeDate LastChangeDate 1
KEY LastChangeTime LastChangeTime 1
_CalendarMonth _CalendarMonth 1
_MaterialMaster _MaterialMaster 1
CalendarMonth CalendarMonth 1
DeliveryDate DeliveryDate 1
DemandPlanner DemandPlanner 1
ForecastDemandVersion ForecastDemandVersion 1
ForecastPeriodStartDate ForecastPeriodStartDate 1
ForecastQuantity ForecastQuantity 1
ForecastYearQuarter ForecastYearQuarter 2
LastChangeDateTime LastChangeDateTime 2
Material Material 1
MRPArea MRPArea 1
ProductionPlant ProductionPlant 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.

-- Private View for I_ForecastDemandItemHistory
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FORECASTDEMANDITEMHISTORY (
    FORECAST,
    FORECASTPERIODMODE,
    FORECASTYEARMONTH,
    LASTCHANGEDATE,
    LASTCHANGETIME,
    _CALENDARMONTH,
    _MATERIALMASTER,
    CALENDARMONTH,
    DELIVERYDATE,
    DEMANDPLANNER,
    FORECASTDEMANDVERSION,
    FORECASTPERIODSTARTDATE,
    FORECASTQUANTITY,
    FORECASTYEARQUARTER,
    LASTCHANGEDATETIME,
    MATERIAL,
    MRPAREA,
    PRODUCTIONPLANT,
    REQUIREMENTTYPE,
    PRIMARY KEY (FORECAST, FORECASTPERIODMODE, FORECASTYEARMONTH, LASTCHANGEDATE, LASTCHANGETIME)
);

Learn More