Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Reading historical forecasts

Former Member
0 Kudos

Hi,

I am using FM MPOP_SINGLE_READ to read forecasts for a material in ECC 6 Retail.

The only problem with it is that it returns only the current forecast results which is generally only for the future.

I would like to be able to return previous forecasts as well so that I can compare a week's consumption against the original forecast for the same week.

Does anyone have some ideas on how I could do this?

I know it keeps forecast history, does someone know how long it keeps it?

Thanks

Charl

3 REPLIES 3

Former Member
0 Kudos

Stupid question or does no-one have a need to read historical forecasts?

Seems I will be able to create some logic to read the old forecasts, but can't find a simple FM that is able to read it for me.

Since I need to read a forecast for a specific period I can compare the forecast date against the start date of the period.

The one closest and in the past should then have the forecast information.

Unlikely that an older forecast will contain information that a more recent forecast does not.

It won't be perfect, but it will be pretty close.

That is one option anyway.

Might be a bit tricky to get it runtime efficient.

0 Kudos

hi,

check these tables.

MPRP

PROP.

0 Kudos

I was thinking of using MAPR-num1, to link to PROP.

PROP has the forecast dates of the previous forecast versions.

So there I compare dates with the required date and go to PROW using PROP-num2.