Distribution via reference data

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[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

[Former Member]

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.

[Former Member]

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