conversion program

[Former Member]

hi guys,

I am a functional guy breaking my head over one program.know the logic but unable to find a way to turn into code.Can any one help me with this?

we have currency conversion rates stored in one database table in SAP BW.This table has four columns CALMONTH,CURR,X,Y.CURR column datatype is CHAR and contains the local currency short name like INR,GBP ...etc...X,Y columns contains some numbers which will be used in calculations to convert CURR local currencies to USD.Everymonth,this table will be get latest currency conversion rates..So this table contains currency conversion rates for local currencies on a monthly basis from 2004.

we convert a value in GBP like this....Januari monthly value(USD)= {monthly value(GBP)/X} / and after this calculate YTD value also. YTD value(USD) = jANUARI monthly value(USD) for febaruari MONTHLY VALUE(USD)= {monthly febrauri(local currenc)/X } / .

YTD Febrauri (USD) = jAN MONTHLY(USD) +Feb monthly(USD).

.like this every month,we read X,Y values from that table for that corresponding currencies AND corresponding month and do the conversions.we have one ABAP program for this in system.

so when my manager chooses YTD value,he sees YTD value for current month in USD eventhough most of data is reported in local currencies.

Now my manager wants to see YTD value on Quarterly rate basis.

In januari 2010...he wanna YTD value on first quarter 2010 rate(which will be januari 2010 rate read from table)

In feb 2010.....he wanna see YTD...its still first quarter 2010 rate(which will be average of januari and febrauri 2010 rate calculated from table)

In April 2010...he wanna see YTD value..it will be Second Quarter 2010 rate(which will be April 2010 rate read from table)

In May 2010...he wanna see YTD value...it will be Second quarter 2010 rate(which will be average of April and May 2010 rate calculated from table)

Can anyone help with how to write this code....I will be thankful.

Regards,

Haywards.

[Former Member]

can any one please help me....

[Former Member]

Moderator message - Please do not post your requirements and ask the forum to do your work for you - post locked Rob