Currency Conversion

[Former Member]

Hi All,

I am using the function module CONVERT_TO_LOCAL_CURRENCY in the Transformation routine.

As far as I understand it should pickup the last maintained rate.

When I tried to debug and simulate the transformation rule I find its converting properly but when it comes back from the routine it gives the following message. I have not yet uploaded as some other guys are working in the system.

Please let me know how to overcome this.

Enter rate / GBP rate type ZCPP for 07.04.2009 in the system settings

Message no. SG105

Diagnosis

For the conversion of an amount into another currency, an entry is missing in the currency conversion table.

Procedure

Add the missing entry in the currency conversion table.

Execute function

You can then continue to process the commercial transaction.

[Former Member · Accepted solution]

Hi Tapan,

In which system are you verifying this FM, if in dev or Test client, then it is quiet likely that taht the exchage rate are not upto date for your excahnge rate type :ZCPP for 07.04.2009 date. Please check this in TCURR table whether the Excahnge rate value are maintianed for your desired conversion ie. Date, from currency, to currency Excahnge rate type all are maintained in TCURR table.

Hope this helps.

Regards,

Umesh

[Former Member]

Hi,

yes you are right it will take always last rate.

Have you simulate transformation for all the records ( Not 100 all entries), just check it out?

Regards,

[Former Member]

Hi,

I am checking with maximum number of errors per peck 100. How that has to do with this error in silulate update ?

Regards,

Tapan

[Former Member]

Hi Guys,

Even if the rate is not maintained then also it should return the rate from the last maintained date. You can find out this by executing the function modue stand alone.

Suppose the conversion table is maintained as follows.

Conversion Rate from EUR to GBP maintained last was on 02.04.2009 and it is 0.89 in Tcode OB08.

If you execute the function module by passing 07.04.2009 it will show the rate as 1.8 as this rate was last maintained. My Routine is working fine as expected but when I come out of the routine this gives me the given error in simulate mode. I could not upload as some other guys were working.

May be it will upload properly when I upload the data. I just wanted to know before hand if somebody had got any such error.

Regards,

Tapan

[virenp_devi]

Hi Tapan,

I am using the function module CONVERT_TO_LOCAL_CURRENCY in the Transformation routine.

As far as I understand it should pickup the last maintained rate.

- Are you not exporting date to the function module. If you are then it will always take exchange rate at that perticular date not last maintained rate.

You have to maintain 'From date'(= 07.04.2009 or anything older than 07.04.2009 ) in TCURR table.

Please let me know if you have any doubts

Regards,

Viren

[Former Member]

Hi,

Any suggestion for this??

Regards,