Copy Reference material into plan cube using FOX formula

Hello Gurus,

Please can any one give idea how to solve the following scenario. I have tired all options and lost.

I have plan cube and reference cube. In Plan cube I have 0material and key_figure and in reference cube I have Omaterial and Zmaterial, Key_figure. My requirement is I want to copy all 0Material which is present in reference cube in plan cube with reference to the Zmaterial.I have to loop through the reference cube and copy 0Material in plan cube and take corresponding Zmaterial and search this Zmaterial in plan cube and copy the keyfigure (Which present in Plan cube) of Zmaterial into Omaterial in plan cube.

Here is the explanation.

Plan Cube
Omaterial     Key_Figure
1                   10
2                   50
3                   40

Reference cube
Omaterial    Zmaterial        Key_Figire
15               2                  1
16               1                  1
17               2                  1

Final Plan cube should look like 

Plan Cube
Omaterial     Key_Figure
1                   10
2                   50
3                   40
15                  50
16                  10
17                  50

Hope I have explain clearly.

Thanks.

With regards,

Anand Kumar