Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Currency Conversion

Former Member

‎2012 Jun 19 7:15 PM

0 Likes
2,568

Hi All,

I am trying to convert JPY amount to USD amount using BAPI_EXCHANGERATE_GETDETAIL like below.

But I am getting an error saying that

Taking the same input values in transaction EWCT like below.

I am getting the corret exchange rate for that date.

Please help me where I am doing wrong while using BAPI. Or is there some other way I need to achieve this?

Thanks,

Nani.

Preview file
9 KB
Preview file
5 KB
Preview file
6 KB
Preview file
9 KB

Hi All,

I am trying to convert JPY amount to USD amount using BAPI_EXCHANGERATE_GETDETAIL like below.

But I am getting an error saying that

Taking the same input values in transaction EWCT like below.

I am getting the corret exchange rate for that date.

Please help me where I am doing wrong while using BAPI. Or is there some other way I need to achieve this?

Thanks,

Nani.

Reply
7 REPLIES 7
Read only

Former Member

‎2012 Jun 19 7:22 PM

0 Likes
2,275

Convert the date to 20120105 (or 20120501 depending on your date format) before passing to the FM.

Rob

Read only

Former Member
In response to Former Member

‎2012 Jun 19 8:22 PM

0 Likes
2,275

Hi Rob,

The date format is correct. But still it is displaying the same error. Please advise.

Thanks,

Nani.

Read only

ThomasZloch
Active Contributor

‎2012 Jun 19 7:41 PM

0 Likes
2,275

EWCT seems to use rate type EURX for the conversion, so try that instead of M.

Check in table TCURR which rates are actually maintained.


Thomas

Read only

Former Member
In response to ThomasZloch

‎2012 Jun 19 8:24 PM

0 Likes
2,275

Hi Thomas,

Tried using EURX in FM exchange rate. Didn't work. Table TCURR does not have the exchange rate 'M'. It only has BAL, AVG and P. What is this table all about. Should this table be maintained with M excahge rate? Please advise.

Thanks,

Nani

Read only

ThomasZloch
Active Contributor
In response to ThomasZloch

‎2012 Jun 19 8:34 PM

0 Likes
2,275

No further idea at this point. Speak to a functional or business person about how the exchange rates are maintained in your organization, debug the FM and the transaction to find out where the difference is.

Thomas

Read only

Former Member
In response to ThomasZloch

‎2012 Jun 19 8:51 PM

0 Likes
2,275

If TCURR doesn't have exchange rate 'M', then I don't see how the example you used for the manual calculation would work.It used 'M' as well.

Rob

Read only

Former Member

‎2012 Jun 20 6:05 AM

0 Likes
2,275

Hi, I have checked the position of the message mentioned by you in the FM 'BAPI_EXCHRATE_GETCURRENTRATES'. This message is being populated if no records are fetched from the table TCURR. So, it appears that the TCURR table is not populated correclty with the information required for the currency conversion. You need to maintain the TCURR table.