05-21-2008 11:19 AM
Hi All,
I have a problem while displaying the currency value with currency format of HUF ( HUF is having 0 decimals in TCURX table).
I am entering the value of 10000 in an input box (The input box is having the reference data type of currency with lenth 13 and decimal 2)
I am entering the amount 10000 to that box in HUF currency format. So while displaying it should display as 10000 (ten thousand) only (without decimals). Instead of that its showing as 1.000.000 (10 lacs)
For all other currency type other than HUF like USD,SGD the format is showing correctly.
For Example
If i am entering 12345 in the input box it is displaying correctly for USD format as 12,345.00
But while displaying the same 12345 value in HUF format it is displaying as 1,234,500
The problem is while displaying the amount based on the corresponding format it is taking the 2 decimals in the input box data type format with the entered amount as a whole value.
For example,
if we enters 123 means its taking it as 12300 while displaying.
Can any of you please help me on this?
05-21-2008 11:31 AM
11-11-2009 10:12 AM
Hi,
When you store Amount for a particular currency in the table it gets stored in the internal format.But while displaying the amount for the same currency it will display in the external format.Whenever we fetch the data it will be fetched in the internal format.For example when we store 100 HUF in a table using SM30 the 100HUF will be the external format.
Internally it will be stored as 1HUF(Internal format) where as in the display it will appear as 100HUF.For the currency USD and many other currencies Both external and internal format have the same value.This difference in Internal and external format could be seen in many currencies like Japanese(JPY),Hungarian(HUF) etc.
This can be handled by using the following BAPIu2019s which converts internal format to external and vice-versa.
BAPI_CURRENCY_CONV_TO_INTERNAL(converts to internal format)
BAPI_CURRENCY_CONV_TO_EXTERNAL(converts to External format)
Kind Regards,
Prathvi.
09-25-2011 1:46 PM
Hi,
I have tried by using BAPI but it is not working.Can you give any better solution for this?
05-21-2008 12:01 PM
If it is a Module pool Program screen.
In the field Characteristic give field type as currency and reference field as the other field which is having Currency unit.
Dont forget to pupolate reference field.
Regards,
Kiran
06-25-2008 4:20 PM
Hi,
I'm facing the same problem. Did you managed to solve the problem?
Thanks a lot.
Best Regards,
Shiva
06-25-2008 5:16 PM
Hi Shiva,
Still i am facing the same problem. I have not get any solution on this.
Hi Abap guru's,
Any of you have faced the same problem please help me.
Regards,
Navaneeth
02-17-2009 9:16 AM
Hi,
I am also having same problem. The only difference is that I am getting in a table maintenance for a custom table and also when I see through SE11(in detailed view of any row).
eg: I am getting 15.624.185.000 instead of 156.241.850
If your problem got solved. Kindly reply what solution did you use for your problem.
Thanks,
Devtara
Edited by: Devtara Sinha on Feb 17, 2009 10:18 AM
09-25-2011 2:32 PM
Hi Navaneetha Kri,
as fasr as I understand, the values are entered in a screen field.
But I could not find where the (wrong) output appears.
Also for output, the field must have the correct and valid currency reference.
Regards
Clemens