SAP extract Forecasting parameters (MPOP structure)

Quick links

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

SAP extract Forecasting parameters (MPOP structure) : Fig 1 : Accessing MPOP in SE16N
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).

SAP extract Forecasting parameters (MPOP structure) : Fig 2 : SAP MAPR table content
Fig 2 : SAP MAPR table content
SAP extract Forecasting parameters (MPOP structure) : Fig 3 : SAP PROP table content
Fig 3 : SAP PROP table content
SAP extract Forecasting parameters (MPOP structure) : Fig 4 : SAP MM03 Material Master Forecasting view
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.

SAP extract Forecasting parameters (MPOP structure) : Fig 5 : SQVI data source selection
Fig 5 : SQVI data source selection
SAP extract Forecasting parameters (MPOP structure) : Fig 6 : MAPR and PROP tables selection in SQVI
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

SAP extract Forecasting parameters (MPOP structure) : Fig 7 : MAPR fields details in SE16N
Fig 7 : MAPR fields details in SE16N
SAP extract Forecasting parameters (MPOP structure) : Fig 8 : PROP 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

Full detail of MPOP Structure is available online[1]

Similar articles

Comments (2)

lupusbabex05F, 2018-08-19
正確に私が探していたもの、完璧なもの
slovenskaZ, 2018-08-19
Jag ska prova det nu, tack för att du delar

Leave a comment