cancel
Showing results for 
Search instead for 
Did you mean: 

Forecasting stock levels

Former Member
0 Kudos

Hi,

How can I forecast stock levels for a given time? - i.e. in 30 days.

We do not capacity plan.

When we went live with sap, we chose finite sheduling.

We do not forecast either.

Many Thanks

Suky Kumar

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member196530
Active Contributor
0 Kudos

Hi

I am little bit curious on this requirement .Are you  looking for Safety Stock calculation for 30 days ??

However , You derived you demand based on Forecast Base Planning and that will also calculate your safety stock .

Please Note the following parameters are to be maintained in MRP views in FBP

1.MRP1 : MRP Type : VV -Forecast Base Planning  .MRP Controller : XXX Lot Size : EX .If u want to order Mini or Max order qty , u can enter that value here .

2.MRP2: Procurement Type : E/F/X based on the IH/External Prc or both , Service level Percentage : x% based on the service level of your busniess .This will be used in Safety Stock Calculation Automatically based on the setting you have done in customising in Check MRP Type -SPRO.If u tick Safety Stock in in cutomising -MRP Type , then it will calcualte the Safety Stock considering the service level percentage , MAD,Basic Values and Lead time in material master .

In MRP2 view , u have to key in Lead Time : Vendor Lead time to bring the item in store and GR processing time .It will be considered in Safety Stock Calcualtion in FBP.

3.MRP3 VIEW : Period Indicator ,:M/W based on your requirement.This will be getting copied to Forcating view in MMR

Availabilty Check Indicator: 01 , Planning Strategy : 40 or as applicable 

4.MRP4 : Individual/Collective indicator : 2 or 1 or Blank ( having relevence if it MTO )

5.Forecasting View : Forecast Model , Initializing parametrs , Smoothing factors , Consumption values, Hist Period, Period per session , Control Data .

Now , if you Sales Order Consumption is not getting considered into Consumption , please check the Movement Type and check the below :

1.OMJJ -Select the Movement type -Enter the movement type 301, 302,311 individually .In Update Control tab , you will find Consumption field .Keep the consumption field Blank .

Finally you have  to copy  the Total Forcast in MD70 after exceuting forcast in MP38 beyond your planning horizon .After coping that this demand goes down to MD62 table .U need to make it blank so that it will not come to MD04.

System will consider the consumption update (planned or un-planned ) against Sales Order , Projects , Free Issues based on the setup in OMJJ as I  have indicated  and also the set up in SPRO-MRP- Check MRP Type (FBP-VV-Should be set in Total Consumption /Obligator Forecast ).

For safety stock calculation you can use earlier reply : Safety Stock Calculation | SCN

Regards

JH


former_member184666
Active Contributor
0 Kudos

Hi Suky,

  1. Create/extend Material with forecasting view
  2. Maintain MRP Type as VV- Forecasting based planning in MRP 1 view
  3. In Forecasting view you need to enter the below
      1. History Periods - History period you want to consider for forecasting Eg : 12 months
      2. Forecasting periods - For how many months you want system to generate forecast
      3. Periods for season - Eg 12
      4. Forecast Model - Select 'J' -Automatic selection
      5. Click on consumption values tab and maintain the consumption and SAVE
  4. Run MP30 for executing the forecast
  5. Check the forecast results in MD04

Test and come back.

Read the belwo links.

https://help.sap.com/saphelp_46c/helpdata/en/fd/45bc639d6411d189b60000e829fbbd/content.htm

Consumption-Based Planning - MRP Procedures - SAP Library

http://scn.sap.com/thread/3147137

Thanks & Regards,

Ramagiri

Caetano
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Suki

There is a tab on the material master called "forecast".

You should extend your this tab to your material on MM01 and define a forecast model for this material.

After that, you can run the forecast directly from the material master or from transaction MP30.

BR

Caetano

Former Member
0 Kudos

Hi Caetano,

I cannot see the tab on the material master that is called "forecast"

Have you got a screen shot please?

Regards

     Suky

former_member184666
Active Contributor
0 Kudos

Hi Suky,

Forecasting View

Thanks & Regards,

Ramagiri