topic Re: jpy currency problem in Application Development and Automation Discussions

jpy currency problem

Former Member — Fri, 29 Jul 2011 05:57:50 GMT

Hello,

I am workin as a abap programmer

I recently got a mini project in which i had to maintain the flight details. i did the project in module pool programming trhere i encountered a problem with the japanese yen currency, the price when saved in the database gets divided by 100(eg 8 gets stored as 0.08) and when i retreive it gets multuiplied by 100. Now the problem is tht whenever i press enter or anything the price on the screen keeps on getting multiplied by 100. How can i avert this situation. Pls help.

P.S i am not geting the above said problem for my total field

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 06:07:20 GMT

Hi,

Dont do the manual calculation like multiply by 100. use the function module CURRENCY_AMOUNT_SAP_TO_DISPLAY pass the currency key and amount you can correct amount.


CALL FUNCTION 'CURRENCY_AMOUNT_SAP_TO_DISPLAY' "
EXPORTING
currency =  tcurc-waers " example 'JPY'
amount_internal =  wmto_s-amount "100
IMPORTING
amount_display =  wmto_s-amount "10000
EXCEPTIONS
INTERNAL_ERROR = 1 "

or use 'BAPI_CURRENCY_CONV_TO_EXTERNAL' pass the currency key and amount you can get correct amount.

Regards,

Dhina..

Edited by: Dhina DMD on Jul 29, 2011 8:10 AM

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 06:10:53 GMT

Hi,

currencies like jpy are stored divided by 100 at the frontend.

But are stored with there actual values at backend.

Are you multiplying the amounts by 100 before displaying? then its possible that the operation repeats everytime you press enter, owing to the event at which you are performing the operation.You can debug and clarify the same.

i would suggest use the FM as mentioned above.

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 06:47:38 GMT

try validating the fields in such a way that currency should be validated first then price. So once if currency got validated, fare will be entered according to currency.

Thanks

Varun.

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 06:48:11 GMT

no i am not multiplying the price field by 100. i am using a table control nd in tht when the price field is displayed it gets multiplied by 100

Re: jpy currency problem

nandakumar_sasidharan — Fri, 29 Jul 2011 06:56:42 GMT

Hi,

Since u are using table control u mite be displaying the price field before the currency field

in ur PAI try validating the currency field before u display the price field

thanks & regards.

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 06:59:35 GMT

thanks it proved helpful

Re: jpy currency problem

Former Member — Fri, 29 Jul 2011 07:01:13 GMT

Hi ,

in your Table control Structure ,maintain field for Currency ,and assign this currency field as a Currecy key field to the amount field.

so system will do the amount converion based on the currency key attached to it...

regards

Prabhu