cancel
Showing results for 
Search instead for 
Did you mean: 

question on forecast

former_member323340
Participant
0 Kudos

Hi All,

Is there a transaction in SAP where I get the average weekly
forecast for the next 3 months per sku per warehouse? 

Best Regards

LSS

Accepted Solutions (1)

Accepted Solutions (1)

marianoc
Active Contributor
0 Kudos

Hi LSS,

I am quite sure there is no standard t-code in SAP with the average weekly forecast.

Go to MD63, extract the PIRs and make the calculation in an excel.

In case you need to extract the data massivelly, you can use MD79 (complete the plant and leave the material open) to extract all the PIRs into an excel.

Kind Regards,

Mariano

marianoc
Active Contributor
0 Kudos

Hi,

You can maybe use MD04 and get totals by week..

Once you are in MD04, press the sumarization button and then select week:

Kind Regards,

Mariano

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi.

I suggest to describe better your scenario. Do you mean the forecast issue? How many requirements do you have by sku in you system now? the requirements are related by customer order or production order or planned order?

In SAP you can run the forecast but the result is by plant or mrp area, not by storage location. You can decide the period (weeky or monthly..) and the results is depending on the consuption in the past.

If you have already many requirements on you system, may by you've just to make a query con RESB table grouping by week the requirements.

Regards.