Skip to Content
author's profile photo
Former Member

Order changes in Monthly and Weekly Data View

Hi,

I need some of your suggestions for my problem below:

I have a planning book with two data views (1 with monthly bucket and other with weekly bucket).Now I create three forecast orders in the weekly data view as below:

Quantity Date

10 05.11.2007

20 12.11.2007

30 19.11.2007

So I can see the sum as 60 in the monthly data view. Now I try to modify (deduct by 5) the forecast order from the monthly data view. So the sum 60 changes to 55 but when I see the details of the order it looks strange to me.

11 26.11.2007

13 19.11.2007

13 12.11.2007

13 05.11.2007

5 01.11.2007

Please let me know what is the logic behind this?

But if I perform the above calculation for the category 'HG' as above I get the result like this.

Weekly Buckets

10 05.11.2007

20 12.11.2007

30 19.11.2007

Monthly Buckets

55 01.11.2007

Thanks,

Siva.

Message was edited by:

sivaprakash pandian

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Posted on Sep 26, 2007 at 09:21 PM

    Hi siva

    This is possibly because of the settings in the planning area for the time disaggregation of the Key figure

    Can you go Planning area administration and see what the setting is in the key figure disaggregation tab?

    I think it needs to be P for proportional distribution and will use previously existing proportions for new quantities.

    instead in your case it is ignoring previously exsisting proportions and distributing afresh. Am not sure what type that is (K?)

    the F1 on the time based disaggregation field will give you a better idea.

    if you want to know why the 11 and 5 are there at the ends and 13 is in the middle buckets, it is because the storage buckets for the weeks have 6, 7,7,7 and 2 days and 55/30 multiplied by these days is how the number are calculated.

    there is also some help here

    http://help.sap.com/saphelp_scm50/helpdata/en/73/3e1167347111d398290000e8a49608/frameset.htm

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:52 AM

    Hi Harish,

    Thx for your reply.

    Your calculation exactly fits forecast key figure but not for Distribution Receipt (Planned) key figure. When I try to modify the order (HG) it returns me a single order.

    Key Figure Calculation Type Time Based Disagg.

    9APSHIP S P

    9ADFCST S P

    Both the key figure has got the same properties but different in behavior. Pls let me know ur feedback on this.

    Thanks,

    Siva.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:00 AM

    Hi All,

    Any feedbacks for the above issue are welcome.

    Thanks in advance.

    Regards,

    Siva.

    Add comment
    10|10000 characters needed characters exceeded