Historical Simulative Orders Archiving

[rudy_schmitz]

Hello everybody,

In order to analyze the forecasts, the business is asking a report to compare the simulative Raw Material requirements of previous month, with what was effectively issued from the stocks.

For this, we would need the historical simulative requirements (or simulative planned orders).

But we don't have them anymore...

Is there a standard way to keep this kind of data?

I mean, is it possible to archive the historical planned orders/requirements before they are deleted?

Thanks in advance for your help.

Regards,

Rudy

[Former Member · Accepted solution]

Hi,

Not sure what you mean by simulative planned orders?

If you're planning materials by placing a PIR, then you can check the PIR & which demand has consumed the same via MD73 or via MD63 by going to history.

But if you want to know the total demand for a month from a order & issues done to them, you should be able to get this details from RESB table.

If the above is not what you're looking, then it would help with a explanation with an example or some screenshots.

Regards,

Vivek

[rudy_schmitz]

OK... This is what I was thinking about... No standard way to obtain this...

Thank you Vivek!

[rudy_schmitz]

Hi Vivek,

I will try to explain better:

We are using PIR's for top-level materials as starting point for our LTP.

LTP is generating simulative planned orders, which are giving us what has to be ordered.

The simulative planned orders are copied to "operative" planned orders.

Then, these operative planned orders are transferred as indep.requirements in the purchasing plant.

Finally, MRP Run is generating purchase requisitions in the purchasing plants.

All this process is scheduled to run every night in background.

I can retrieve what has been issued from the stocks using tables MKPF and MSEG.

This is what is shown in transaction MB51.

But we would like to compare these figures (what was issued from the stocks) to what was resquested first (= simulative dependent requirements or planned orders on Raw Materials).

So, my question is: is there a way to keep trace of these simulative planned orders? or the simulative dependent requirements?

A kind of archiving? or?...

Regards,

Rudy

[Former Member]

Hi,

You can write those values to a Z table, but i am trying to figure out a business need / benefit in doing this.

Regards,

Vivek