Write 2 records with different currencies into 1 and load in info cube

Hi ABAP guru's,

I need to find for 'CAD'(Lcurrc) the same record with the amount (Gamount) in 'USD' (Gcurrc), write the amount in the record with 'CAD' under Gamount and delete the old record.

e.g. (currently)

cust., account, comp., Lcurr, Gcurr, Lamount, Gamount

10045, 5005500, 2200, CAD, USD , <b>0.00</b>, 522.00

10045, 5005500, 2200, USD, USD , 374.00, <b>0.00</b>

(wish to have)

cust., account, comp., Lcurr, Gcurr, Lamount, Gamount

10045, 5005500, 2200, CAD, USD , <b>374.00, 522.00</b>

I'm writing a routine in my update rule for 'LAmount' while loading the data in my info cube. Every advise would be greatly appreciated.

Thanks, Ramona