Skip to Content
0
Former Member
Nov 12, 2004 at 06:13 PM

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

25 Views

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