Planning Function to Copy/Distribute Data Equally

[Former Member]

In my layout I have key figures in the rows and fiscal period in the columns. If users enter a number in the first period and click on the function it will copy the same number to all the periods of that quarter. Which planning function should i use for the same and can you explain step by step how to build that

planning function. In the function how do i define the relationship between period and quarter (in my BI backend quarter is a attribute of period)

Thanks

Rashmi.

[Former Member · Accepted solution]

Hi Rashmi,

you have to use 'Distribute by Keys from Sender to Receipient' function to accompolish your stated requirement.

Fields to be changed: Fiscyear/Period

Fields for condition: Quarter

In the parameter group, you should enter the following values:

Conditions:

Quarter: 1

From Fiscal: 001.2008 (whichever year you plan or in case you dont want to enter the fiscper manually create a variable)

By Values:

Fisc/per: 001.2008 Dist factor: 1

Fisc/per: 002.2008 Dist factor: 1

Fisc/per: 003.2008 Dist factor: 1

Similarly for the next quarters too.

Next create a Manual planning layout with 'Key figures in data columns' and Fiscyear/period in 'Lead column'.

Finally, enter the quarter the used want to input the values and click the function just created, it will distribute automatically.

Best of luck. Revert in case of any trouble

Regards,

Manoj

[Former Member]

Hi,

Is the issue solved.

Also, pls assign, if found helpful.

[Former Member]

Hi Manoj,

From where can I get help regarding use of 'Distribute by Keys from Sender to Receipient ??

Regards,

Jasmi

[former_member215589]

Hi Jasmi,

For 'Distribute by Keys from Sender to Receipient you can use the following link

http://help.sap.com/saphelp_sem60ep1/helpdata/en/0a/242537cedf2056e10000009b38f936/frameset.htm

Regards,

Priyanka Singh

[Former Member]

Thank you