Can we restrict Key Figures in "Distribute with reference data"?

[Former Member]

Hi,

I'm using "distribute with reference data" function & I wanted to distribute only 1 Keyfigure & the 2nd keyfigure shouldn't be distributed but remain same for each record.

So, I restricted function with only 1st keyfigure & when I look at the distributed data, function distributed correctly but 2nd keyfigure was blank.

Let's say I've following data.

MATERIAL SGRP QTY PRC

=====================

MATERIL1 0000 100 23

where SGRP is "Sales Group" & QTY is "Quantity" & PRC is "price"

I am interested in distributing only Quantity but not the price.

After distribution, this is what I can see...

MATERIAL SGRP QTY PRC

=====================

MATERIL1 SGP1 050 000

MATERIL1 SGP2 050 000

MATERIL1 0000 000 23

But, I'm expecting the following...

MATERIAL SGRP QTY PRC

=====================

MATERIL1 SGP1 050 23

MATERIL1 SGP2 050 23

Appreciate any ideas.

[Former Member · Accepted solution]

If you want both/all resulting records to have the original value for KF2, you need to distribute 100%, preferably in a separate distribution function by key and put them in a sequence.

Hope this helps,

Mary

[Former Member · Accepted solution]

Hi Mary,

Thank you very much for your reply.

after the distribution funciton, let's say, i've following data.

MATERIAL SGRP QTY PRC

=====================

MATERIL1 SGP1 050 000

MATERIL1 SGP2 050 000

MATERIL1 0000 000 23

I created 1 more distribution by keys funciton & included this in a planning sequence along with 1st distribution function.

But, it's not helping my needs. I tried with all 3 functions, "Distribute by Key", "Distribute according to keys" & "Distribute by keys from sender to reciever".

As Sales Group is different after the 1st distribution funciton, qunatity records are not falling in the same set of data as price records for the 2nd "distribution by keys" funciton.

if i don't include Sales Group in "fields to be changed" of the above 3 "distribution by key" functions,

function is taking 2 sets of data with set1 contains 1st 2 records(records with quantity & "with SGRP1 & SGRP2") & set2 contains 3rd record (record with price & with SGRP 0000).

As they are not falling within same set of data, above 3 functions are not working for me.

If i include Sales Group in the "fields to be changed", I'll have to specify a value which incase is dynamic & varies for each material.

hope am clear & appreciate if you have any other ideas.

[Former Member · Accepted solution]

Hari,

Try playing with the distribution by key function. If you cannot get it right in 30 mins 1 hr tops, I would go to FOX. This can be easily solved by FOX.

[Former Member · Accepted solution]

Hari,

Forgot to mention that you have to be very careful and clear about what you want and expect to get. Please note that if you have 23 is each of the key figure2, then the total is n x 23 for key figure 2 if you have accumulation turned on and you aggregate at the higher level...

[Former Member · Accepted solution]

Hi Mary,

I again tried the funciton "Distribute according to keys". Like I mentioned earlier, this funciton needs a mandatory field in "fields to be changed" & is not meeting my needs.

I'm trying the same in FOX and am almost done.

anyhow, very much appreciate your help.

[Former Member · Accepted solution]

Isn't field to be changed your SGP? SGP was # before and changed to SGP1 and SGP2 but if you have more different sales groups for different things, it would not likely meet your needs.

Lets take a step back, why do you need the price on every records? Why don't you just leave the price in the # sales group? I persume you will be using FOX to calculate the amount later and you can look and pick up the material price at the # sales Group and loop through the SGPs to calculate the amount...

[Former Member · Accepted solution]

If you need some help in FOX with the loop of price as reference data, this How to Guild on "How to loop over refrence data in FOX Formula" may give you a better idea.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/how to loop over reference data in fox formulas.pdf

[Former Member · Accepted solution]

Hi Mary,

you are right. I need to include Sales Group in "fields to be changed" and in our case, Sales Groups are dynamic for the reason, it's not meeting our needs.

finally, I've done the same in FOX.

Thanks for directing me to helpful document.

[Former Member · Accepted solution]

Distribution - as I suspected.

That reference data how to is fairly good. I have used it myself over a year / 18 months ago and have sent it to some people I know when are are starting to do complex FOX with different granularity.