Hi,
I really need urgent help with this....
I am using characteristics: Customer group, Customer, Material Level 1 and 2 (amoung the usual time and planning chars like year, month, version....).
I need to distribute this data in the "Commission" KF according to Quantity KF.
The data is like that:
CGrp | Cst | ML1 | ML2 | Qty | Comm
===============================================
A1 | 106 | 00001 |--
#
-|
-----| 100K
A1 | 106 | 00001 | 00003 | 100 | 20K
A1 | 106 | 00001 | 00006 | 300 | 50K
-
A1 | 342 | 00001 |--
#
-|
-----| 150K
A1 | 342 | 00001 | 00003 | 100 | 10K
A1 | 342 | 00001 | 00005 | 200 |
A1 | 342 | 00001 | 00006 | 300 | 60K
-
A2 | 100 | 00001 |--
#
-|
----| 60K
A2 | 100 | 00001 | 00003 | 80 | 5K
A2 | 100 | 00001 | 00006 | 20 |
The results I want:
CstGrp | Cst | ML1 | ML2 | Qty | Comm
=======================================================
A1 | 106 | 00001 |--
#
-|
-----|
A1 | 106 | 00001 | 00003 | 100 | 20K + 25K = 45K
A1 | 106 | 00001 | 00006 | 300 | 50K + 75K = 125K
-
A1 | 342 | 00001 |--
#
-|
-----|
A1 | 342 | 00001 | 00003 | 100 | 10K + 25K = 35K
A1 | 342 | 00001 | 00005 | 200 | 00K + 50K = 50K
A1 | 342 | 00001 | 00006 | 300 | 60K + 75K = 135K
-
A2 | 100 | 00001 |--
#
-|
----|
A2 | 100 | 00001 | 00003 | 80 | 5K + 48K = 53K
A2 | 100 | 00001 | 00006 | 20 | 0K + 12K = 12K
I thought I should use Distribute with Reference Data but I got errors.
Please advise what to put on F.T.B.Changed, Char for Condition and Ref Chars.
Should I have to pay attention on the level\package parameters?
Thanks in Advance,
Daphna