Problem with Monthly to Weekly distribution and release to ECC/DM

[former_member209252]

Hello

We have a problem with the distribution from Months to Weeks.

We have entered sales forecast in monthly view :

06.2013:  465 pcs

07.2013: 465 pcs

08.203: 465 pcs

09.2013: 589 pcs

10.2013: 589 pcs

11.2013: 589 pcs

12.2013: 589

If we look in the planning book at a weekly view for example for 07.2013

27.2013: 107

28.2013: 104

29.2013: 105

30.2013: 105

31.2013: 104

Total 525 pcs for 07/2013

This is the view from which we relesae to ECC the forecast.

If we chech the storage bucket pofile view:

01.7: 108

08.7: 104

15.7: 105

22.7: 105

29.7: 44

05.8: 60

It look that untill 29.7 we get the total of 465 pcs that was expected.

I do not understand how to make sure that what we have in the monthly view per month will also distribute correctly for this month in weeks.

We must make sure that if the demand planner compare the monthly quantities from the planning book per material he/she will see that the same when he totals the weekly forecast per month in  MRP /MD04

You can see print screens in the attached document

Please your answers are welcome

Thanks

[Former Member]

Arieh,

Month doesn't have exact weeks and weeks do not add up to exact months.

However check/ask your consultant to try fiscal buckets, where a week always ends on end of the month. You can create a time bucket profile that has fiscal periods instead of weeks. However this may have unwarranted consequences esp. if the data is not STORED in the planning area in Days and that doesn't happen in most designs.

Hope you are able to visualize. Instead of calendar weeks, you are using some other "periods" that you are calling a week.

[former_member209252]

Hello

Thanks for your replies.

Is there a way in which we can get the same distribution from M to W as we get if we use "distribution function" in Period split Profile":

I entered 465 pcs from 01.07.2013 to 31.7.2013

and get these results:

Start Date    Value 

01.07.2013 105.000

08.07.2013 105.000

15.07.2013 105.000

22.07.2013 105.000

29.07.2013 45.000

Total  465.000

We were thinking of using this function, but we get some times not round quantities, and planners do not want to see forecast like this in their SAP/ECC

Thanks

[former_member187488]

hi，you should understand that week 31 contains part of july and part of august，so sorry but your expectation does not sound reasonable ...