Skip to Content
author's profile photo Former Member
Former Member

Currency conversion from USD to JPY overstated by a factor of 100

Hi Experts,

I have read several threads on currency conversion related to currencies with zero decimal places like JPY. The TCURX table and TCode: OY04 have zero entry for JPY currency in my system.

I am converting the Net Value in Doc Curr (for Billing Item datasource) to Net Value in Loc Curr in the transformation by using the exchange rate field from the extractor/datasource. When displaying the results in the query all currency conversion work accurately except the conversion from USD (Doc Curr) to JPY (Loc Curr). The value is overstated by a factor of 100.

Example in the report:

Net Value in Doc Curr: $100 (USD)

Net Value in Loc Curr: 768,500 JPY

Exchange Rate: 76.85

The Net Value in Loc Curr should be 7,685 JPY and is therefore overstated by a factor of 100. I understand that the system settings for JPY are correct but the issue comes because I am doing the conversion directly in the transformation via a formula. Any suggestions how I can resolve this issue?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 24, 2011 at 01:06 PM

    Hi Alnick,

    It looks like you probably have an entry for JPY in your TCURX table (decimal places for currencies). Possibly an entry of 4, which would be odd. If this is the case, then your values will show up properly in queries but will look like they are multiplied when you look in SE16 or LISTCUBE.

    Just one of those little joys of the Netweaver platform 😊

    Cheers,

    Ethan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ethan Jewett

      Thanks Ethen. This is exactly what I was looking for. The CURRENCY_CONVERTING_FACTOR FM will give me the correct factor to divide the converted loc curr amt based on the Loc Curr that it is being converted to. Also I don't think I need to use the RSW_CURRENCY_TRANSLATION FM as it seems complex with multiple input values and also because I am doing a simple calculation for conversion from doc to loc based on the exchange rate from the extractor directly. Thanks again for the solution.

      Regards,

      Alnick

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 04:18 AM

    Hi,

    I think formula should not be a problem, there might be some issue with currency conversion rate.

    Select your source system from RSA1 and from context menu choose, transfer global settings, and then transfer exchange rates form source system and check in the source system if exchange rates are maintained properly.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your reply Durgesh. I already transferred the global settings and exchange rates. I did a rebuild of tables in BW to replicate everthing from ECC. Also the exchange rate of 76.85 is accurate. It is just the X100 multiplier effect thats causing the issue.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.