Skip to Content
author's profile photo Former Member
Former Member

Preparing Forecast in SAP R/3

Hi Gurus,

Good Morning.

I am trying to prepare a Forecast Plan for next 6 months based on the Sales History for Past 13 weeks. The solution which i was thinking of is to prepare a Custom Sales Forecast report in SAP with the Sales History over the 13 weeks as the basis for the calculation , spread it out in monthly buckets and then upload it to the Planned Independent requirement table (MD61)

If at all if i dont use the above option , In the system if i extend the forecast view then we can plan the Total Consumption over there , ther total Consumption does looks for all the Sales Order over that particular period? and also how can i get the data in the the forecasting to be transferred to the Planned Independent requirement table ? It would be great if you are able to provide some Configuration/Setup details.

Thanks in Advance..



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2010 at 03:01 PM


    It appears you are asking about R/3 forecasting, and not APO. You don't have to write a custom report, SAP standard functionality provides your requirement.

    Standard methods in R/3 to arrive at Planned independent Requirements through a forecast are Material Forecasting (which creates forecasts based on historical consumption) and Sales and Operations Planning (which can forecast based on anything you design).

    Simplest to implement is material forecasting. For most companies, FGs consumption data is more than adequate to provide realistic forecasts.

    Once your forecast is done, using either Material forecasting or SOP, it can automatically be converted to Planned Independent requirements.

    Material forecasting


    Creating PIRs



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello DB.

      I have landed to this conversation while searching for something else, but it immediately caught my eye. I have an issue with forecast through the material consumption values. In making the forecast (through the "Execute Forecast" button in "Forecasting" tab in material master) i am using Forecasting method 2 (which compares all forecasting methods and chooses the one which has the least MAD error). My problem is that the forecasting method that this process has derived is not automatically updated in "Forecast Model" box (MPOP-PRMOD). Am i doing something wrong??? Is it possible that it may be due to not having any user exit implemented?

      Best personal regards,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.