Forecast Quality

Query Query: 0FRE_MC03_Q0002 / 0FRE_MC23_Q0002

This query is used to analyze the quality of forecasts produced by SAP Forecasting and Replenishment (SAP F&R). It allows you to compare the forecasted units against the actual consumption values for previous periods.

This query shows all forecasted values and actual consumption values, even if there are no differences between those values. The lowest level of detail represents product, location, and calendar week values.

The key figures are derived from the differences between the actual consumption and three different versions of the forecast. These different versions represent the number of weeks in the future that the forecasted values have been executed (for example, a forecast that was executed two weeks into the future, and one that was executed four weeks into the future). This allows you to analyze not only the most recent forecasted values, but also the values forecasted for multiple weeks in the past.

Variables are provided for you to enter a selection range of weekly periods, products, and locations.

The following KPIs and key figures are calculated in this query:

NOTE: All the key figures listed below are calculated for the most recent forecast as well as for the forecast versions 1 and 2.

Total Forecast Error
Total Forecast Error Percentage
Mean Absolute Deviation
Mean Percentage Deviation
Minimum Percentage Deviation
Maximum Percentage Deviation

The following KPIs and key figures are displayed in this query:

Weekly Consumption Units
Weekly Forecast Units
Weekly Forecast Version 1
Weekly Forecast Version 2

Weekly Active Forecast

Note

Data for the F&R Weekly Figures InfoProvider (0FRE_C05) is collected on a weekly basis and contains the following time characteristics: 0CALWEEK, 0CALMONTH, 0CALYEAR, 0FISCPER, 0FISCVARNT and 0FISCYEAR. In this query, BI summarizes the key figure data from this InfoProvider, based on the first day of the calendar week.

For example, assume you have the following weekly records:

The total for June is 360. Consumption for calendar week 22, which includes five days in June, is not included in the June summary line. This is because only the first day of the week is used to determine the month to which the weekly information belongs.

This limitation applies to all reports based on the F&R Weekly Figures InfoProvider (0FRE_C05).

End of the note.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
		`N/A`	-

Free Characteristics
Object Type	Name	Technical Name
	Description	`InfoObject`
	Location Type	`0PLANT__PLANTCAT`
	Merchandise Category	`0MATERIAL__MATL_GROUP`
	Merchandise Category Level 1	`0MATERIAL__ORPA_WGH1`
	Merchandise Category Level 2	`0MATERIAL__ORPA_WGH2`
	Merchandise Category Level 3	`0MATERIAL__ORPA_WGH3`
	Merchandise Category Level 4	`0MATERIAL__ORPA_WGH4`
	Replenishment Type	`0FRE_REPLST`
	Vendor	`0VENDOR`
	Supplying Plant	`0SUPP_PLANT`
	Replenishment Planner	`0MAT_PLANT__0FRE_PLNPUR`
	Listing Status	`0FRE_LISTST`
	ABC Indicator	`0MAT_PLANT__0ABCKEY`
	Selling Class	`0MAT_PLANT__0FRE_SELCLS`
	Production Substitution Type	`0FRE_REPLTY`

Variables
Object Type	Name	Technical Name
	Description	`Variable`
	(required) Calendar year/week	`0I_CWEEK`
	Product	`0S_PROD`
	Location	`0S_LOC`

Rows
Name	Technical Name	Value Restriction / Calculation
Calendar Year/Week	`0CALWEEK`	-
Product	`0MATERIAL`	-
Location	`0PLANT`	-

Columns
Name	Technical Name	Value Restriction / Calculation
Weekly Consumption	`0FRE_CONSWK`	-
Weekly Forecasted Consumption in BuoM	`0FRE_FCSTWK`	-
Weekly Active Forecast	`0FRE_ACTFCW`	-
Weekly DIF Effects in BUoM	`0FRE_WDIFEF`	-
Minimum Stock – Uses Formula Variable OF_MINST	`0FRE_MC03_CK023`	-
Target Service Level – Uses Formula Variable OF_SERLV	`0FRE_MC03_CK024`	-
* MOST RECENT FORECAST *	`* MOST RECENT FORECAST *`	*vMOST RECENT FORECAST *
Total Forecast Error – (Calculated Key Figure)	`0FRE_MC03_CK011`	Total Forecast Error = Weekly Consumption – Weekly Forecast.
Total Forecast Error Percentage – (Calculated Key Figure)	`0FRE_MC03_CK012`	(‘Weekly Consumption’ – ‘Weekly Forecast’) %A ‘Weekly Forecast’
MAD – (Calculated Key Figure)	`0FRE_MC03_CK025`	ABS (‘Mean Absolute Deviation’ / ‘General Counter’)
Mean % Deviation – (Calculated Key Figure)	`0FRE_MC03_CK026`	‘Mean Percentage Deviation’ %A ‘General Counter’ * 100
Minimum % Deviation – Total Lines Only – (Calculated Key Figure)	`0FRE_MC03_CK026`	Calculate Results as - Minimum
Maximum % Deviation – Total Lines Only – (Calculated Key Figure)	`0FRE_MC03_CK026`	Calculate Results as = Maximum
Mean Forecast Error (MFE) – (Calculated Key Figure)	`0FRE_MC03_CK005`	'Total Forecast Error' / 'General Counter'
Mean Forecast Error (No UoM) – (Calculated Key Figure)	`0FRE_MC03_CK006`	NODIM ('Total Forecast Error' / 'General Counter' )
Mean Absolute Percentage Error (MAPE) - Mean – (Calculated Key Figure)	`0FRE_MC03_CK004`	MAPE(Mean pre Calculation) %A (General Counter * 100) where MAPE(Mean pre Calculation) = ABS (Weekly Consumption – Weekly Frcst Consmpt ) %A Weekly Consumption
Mean Absolute Percentage Error (MAPE) - Level – (Calculated Key Figure)	`0FRE_MC03_CK002`	NODIM (Mean Absolute Deviation) %A NODIM(Weekly Consumption)
* FORECAST VERSION 1 *	`* FORECAST VERSION 1 *`	* FORECAST VERSION 1 *
Total error – (Calculated Key Figure)	`0FRE_MC03_CK015`	Same as 0FRE_MC03_CK011 but using Weekly Forecast Version 1 Instead of Weekly Forecast.
Total Error Percentage – (Calculated Key Figure)	`0FRE_MC03_CK016`	Same as 0FRE_MC03_CK012, but using Weekly Forecast Version 1 Instead of Weekly Forecast.
MAD – (Calculated Key Figure)	`0FRE_MC03_CK027`	Same as 0FRE_MC03_CK025 Using Weekly Forecast Version 1 Instead of Weekly Forecast.
Mean % Deviation – (Calculated Key Figure)	`0FRE_MC03_CK028`	Same as 0FRE_MC03_CK026 Using Weekly Forecast Version 1 Instead of Weekly Forecast.
Minimum % Deviation – Total Lines Only – (Calculated Key Figure)	`0FRE_MC03_CK028`	Same as 0FRE_MC03_CK026 Using Weekly Forecast Version 1 Instead of Weekly Forecast.
Maximum % Deviation – total lines only – (Calculated Key Figure).	`0FRE_MC03_CK028`	-
* FORECAST VERSION 2 *	`* FORECAST VERSION 2 *`	* FORECAST VERSION 2 *
Total Error – (Calculated Key Figures)	`0FRE_MC03_CK019`	Same as 0FRE_MC03_CK011, but Using Weekly Forecast Version 2, instead of Weekly Forecast.
Total Error Percent – (Calculated Key Figure)	`0FRE_MC03_CK020`	Same as 0FRE_MC03_CK012, but Using Weekly Forecast Version 2 instead of Weekly Forecast.
MAD – (Calculated Key Figure)	`0FRE_MC03_CK029`	Same as 0FRE_MC03_CK025 Using Weekly Forecast Version 2 Instead of Weekly Forecast.
Mean % Deviation – (Calculated Key Figure)	`0FRE_MC03_CK030`	Same as 0FRE_MC03_CK026, Using Weekly Forecast Version 2 Instead of Weekly Forecast.
Minimum % Deviation – Total Lines Only – (Calculated Key Figure)	`0FRE_MC03_CK030`	Same as 0FRE_MC03_CK026 Using Weekly Forecast Version 2 instead of Weekly Forecast.
Maximum % Deviation – Total Lines Only – (Calculated Key Figure)	`0FRE_MC03_CK030`	Same as 0FRE_MC03_CK026, Using Weekly Forecast Version 2, Instead of Weekly Forecast.