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

Distribution via reference data

Hello all,

we would like to distribute 'person days' for 2010 across all periods in 2010. Currently we have planned only on the level of fiscal year 2010. Now we like to distribute this value equally across all periods via top-down distribution.

So the key figure we are using is quantity (person days), the characteristic to change is fiscal-period.

However, when we execute the sequence with trace, the reference data is found " 1 records found", but nothing is distributed.

We get a message "cannot find sub-process 1".

Has anybody any ideas?

Thanks,

M

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2009 at 09:36 AM

    Hi,

    distribution by reference means that the system needs reference data to distribute. This could be e.g. reference data from the year 2009. Now distribution by reference data means that the system should distribute your current 2010 data according to the 2009 reference data. Please check if you have reference data in the system on fiscal period level (e.g. by using listcube).

    http://help.sap.com/saphelp_nw70/helpdata/EN/44/2109287641648fe10000000a1553f7/frameset.htm

    Your description sounds more like distribution by key.

    http://help.sap.com/saphelp_nw70/helpdata/EN/44/21f75f7641648fe10000000a1553f7/frameset.htm

    Regards Matthias

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2009 at 10:14 AM

    Hi Michael,

    If the distribution function doesn't works out, try fox function. The coding should be simple.

    {Fiscper, Fiscyear, Quantity}

    {2010001, 2010, quantity} = { #, 2010, quantity}/12.

    {2010002, 2010, quantity} = { #, 2010, quantity}/12.

    etc.

    Regards,

    T-Bird.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2009 at 10:22 AM

    Hello,

    can anybody give me some advice on how to customize a planning function "distribution by reference data" in BI IP? There is no useful example in the training material and the documentation also leaves room for improvement.

    How do I have to select the fields that are changed and the block characteristics?

    I want to distribute planned sales data for the plan year to each posting period of the plan year. The reference data is the actual sales data for each posting period of the actual year.

    Does anybody have a small fox coding which does the same?

    Thanks and best regards

    Nina

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      In your case you can copy the data from actual sales of actual year to plan sales of plan year. Create a new aggregation level same as the planning query aggregation level and include the posting period also in that aggregation level and create a distribution planning function by reference on that aggregation level mark the 'posting period' alone as the to be changed characteristic.

      Give the 'plan sales key figure' as the reference key figure as you are already copying the actual sales data from actual year to plan sales key figure in plan year. It should work

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2009 at 09:23 PM

    Reference data is required to distribute the data. In your case for distributing 2010 data you should have some existing data at the posting period level which will be the reference for distribution.

    Once you have the reference data, create a new aggregation level same as the planning query aggregation level and include the posting period also in that aggregation level, build your distribution planning function on this aggregation level and mark posting period as the 'to be changed' characteristic. It should work.

    Add a comment
    10|10000 characters needed characters exceeded

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.