Skip to Content
0
Former Member
Sep 12, 2007 at 02:17 PM

Distribute with Reference Data

31 Views

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