topic Re: Reading historical forecasts in Application Development and Automation Discussions

Reading historical forecasts

Former Member — Wed, 17 Sep 2008 12:23:41 GMT

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

Re: Reading historical forecasts

Former Member — Sun, 21 Sep 2008 09:55:12 GMT

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.

Re: Reading historical forecasts

GauthamV — Sun, 21 Sep 2008 10:07:11 GMT

hi,

check these tables.

MPRP

PROP.

Re: Reading historical forecasts

Former Member — Sun, 21 Sep 2008 10:48:41 GMT

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.