on 05-23-2005 10:07 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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...
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
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.