SAP extract Forecasting parameters (MPOP structure)

ybierling October 2, 2013November 18, 2016 en, Forecasting, MAPR, MM03, MPOP, PROP, SAP

SAP MPOP structure is not a real table, and is not directly accessible, for example using SE16N (Fig 1).

Fig 1 : Accessing MPOP in SE16N

Therefore, if we want to extract Material Master’s MPOP data for a given set of materials, it must be done by accessing several tables, MAPR (Fig 2) and PROP (Fig 3), which contains information from the Material Master’s Forecasting view (Fig 4).

Fig 2 : SAP MAPR table content

Fig 3 : SAP PROP table content

Fig 4 : SAP MM03 Material Master Forecasting view

First, we must look for PNUM1 pointer corresponding to the Plant / Material in MAPR table (Fig 5), and, then, use it in PROP‘s table PNUM1 field (Fig 6), various Forecasting parameters versions will be detailed.

Fig 5 : SQVI data source selection

Fig 6 : MAPR and PROP tables selection in SQVI

We finally have to select the highest History number, HSNUM parameter sequentially assigned, in order to get active forecasting parameters.
It is then quite simple, in SQVI, to create a Table join view, add tables MAPR and PROP, to display and extract our MPOP data.

Tables keys :

MAPR table – Material Index for Forecast (Fig 7)
Plant	WERKS
Material	MATNR
Pointer parameters	PNUM1
PROP table – Forecast parameters (Fig 8)
Pointer parameters	PNUM1
History number	HSNUM
Version	VERSP

Fig 7 : MAPR fields details in SE16N

Fig 8 : PROP fields details in SE16N

PROP fields displayed by default in MM03 Forecasting view (Fig 4) and coming from MPOP :

Number of periods required
PERAN	Historical periods
ANZPR	Forecast periods
PERIO	Periods per season
PERIN	Initialization pds
FIMON	Fixed periods
Control data
KZINI	Initialization
SIGGR	Tracking limit
MODAW	Model selection
MODAV	Selection procedure
KZPAR	Param.optimization
OPGRA	Optimization level
GEWGR	Weighting group
ALPHA	Alpha factor
BETA1	Beta factor
GAMMA	Gamma factor
DELTA	Delta factor