cancel
Showing results for 
Search instead for 
Did you mean: 

Forecast Consumption

Former Member
0 Kudos

Hello all,

We have a forecast in DP for a product with qty 3000 and in the release to SNP, system has distribute this qty in tcode RRP3 (tab Forecast; Planned qty) 1400 or 1600 for every day.

The forecast was consumed for this month based in this forecast, so we had:

date Qty Planned Withdrawal Alloc Rem Pln Qty

01.04.2009 1400 1.400 0 0

02.04.2009 1400 1.400 0 0

03.04.2009 1400 1.400 0 0

06.04.2009 1400 1.400 0 0

07.04.2009 1400 1.400 0 0

08.04.2009 1600 1.600 0 0

09.04.2009 1600 1.600 0 0

...

The problem is that this week, the demand Planner has adjusted the forecast in DP to 15132, so the qty planned for a day is moreless half than it was. But the Withdrawal is of course the same, and the problem is that the Rem Pln Qty for the month is almost the double that we should be. If SNP planning book we should see +- 4500 left in forecast and we see 9000.

now we have:

date Qty Planned Withdrawal Alloc Rem Pln Qty

01.04.2009 706 1.400 0 0

02.04.2009 706 1.400 0 0

03.04.2009 706 1.400 0 0

06.04.2009 706 1.400 0 0

07.04.2009 707 1.400 0 0

08.04.2009 807 1.600 0 0

09.04.2009 807 1.600 0 0

13.04.2009 807 360 0 447

14.04.2009 807 0 0 807

15.04.2009 807 0 0 807

...

In this cases is there anything we can do to correct the consumed forecast in RRP3? when the demand planner changes the forecast how can he redistribute the Withdrawal with this new Planned values per day?

Thanks and regards,

Teresa Lopes

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Teresa lopes,

Goto transaction code /sapapo/rrp3, enter planning version, product and location and press enter.

Select "Forecast" tab, you will see the dates displayed as per forecast how it is consumed. If the dates falling on weekly breaks, then your buckets are planned weekly. If it is daily, then your buckets are getting planned daily.

Regards

R. Senthil Mareeswaran.

Former Member
0 Kudos

Hi Teresa,

As per my understanding, the consumption takes place in buckets as how we defined in forecasting. If there is some consumption happening in one bucket as per forecast and then when forecast gets reduced subsequently, the consumed quantity will not get distributed automatically by system. Because, when system moves to next bucket(it can be daily, or weekly), it checks the forecast at that point of time and start consumption accordingly.

If you want to match your consumption exactly based on your forecast, you need to delete withdrawals done so far on daily basis(as in your case, there is change in forecast daily). If withdrawals are not available before the start of next bucket, then the consumption will begin as per the reduced forecast available.

There is no SAP std report for deleting withdrawal qty. You need to develop a customised report for this activity.

Regards

R. Senthil Mareeswaran.

Former Member
0 Kudos

Hi Senthi,

thank you for your answer.

how can I now if the bucket is daily or weekly?

Thanks and Regards,

Teresa

Former Member
0 Kudos

I need a bit more clarification on your issue

1. The planning strategy that is maintained in the product master.

Assuming it is 20 (Plng With Final Assembly) here is the explanation of the Qts you see in RRP3

Qty Planned-->Forecast released from DP to SNP (say 1400)

Allocated Qty--> Qty of Sales Orders consumed the Fcst (say 200)

Remaining Qty--> Diiferece of the above two (i.e 1400-200=1200)

Withdrawal Qty--> Qty for which PGI is done

2. DP Fcst Qty 3000--Is it a weekly number or monthly number

Whatever Fcst Qty you release to SNP will be seen as Qty Planned in RRP3 for that specific bucket

Former Member
0 Kudos

Hi Sai,

The planning strategy is maintained in the product master and is 20.

My question is, if we reduce the forecast in 2ª week of the month will the system regenerate the quantities consumed in 1ª week?

in 1ª week we had

Plan qty withdrawal

day 1 1400 1400

...

if we reduce forecast in 2ª week in DP, in SNP we get about 700 each day (montly forecast reduced to half in DP), shouldn´t the consumed qty be redistributed again for the other days of the week?

We have a daily forecast release. The system in 1º day of the 2ª week when doing the forecast release shouldn´t see that was consumed 1400 and consumed that qty in withdrawal for more 2 days?

like this?

Plan qty withdrawal

day 1 700 700

day 2 700 700

or system does not redistribute qty in the past that were already consumed?

Former Member
0 Kudos

Normally Qty Planned and the withdrawal Qty should match..I guess you cannot have the with drawal Qty more than the Qty Planned. If you have more sales orders coming in than the forecast that you have..then the consumption will happen based on the consumption mode that you set in the product master.Even after consuming the forecast based on the consumption mode if you have more sales orders then you will see a new column "Shortage" in the forecast tab of RRP3.

In your case since there is some change in the release for the second week, the requirements have to be re-adjusted. So please go to the Tcode /SAPAPO/MD74, enter your product and location and mention the start date (tomorrows date) and end date, check the boxes "create list" and "delete orders". Initially run with the test mode option and check the situation in RRP3. If it looks good then uncheck the test mode box and execute it. This process will re adjust forecast in SNP.

"

Former Member
0 Kudos

Hi Sai,

I've already did what you said, the problem is that in readjust, the qty Planned and the withdrawal Qty match but only until today and the problem is if we once had more in withdrawal that planned, the system readjust should happen for all the withdrawal Qty, meaning it will have to consume to days in the future.

Ex: qty plan withdrawal

day1 700 1400

with /SAPAPO/MD74 it should do

qty plan withdrawal

day1 700 700

day2 700 700 (700 left consumed in day 1), so we wiil need more forecast days to consumed all withdrawal qty, and system is not doing it, and the remain qty will be the double.