12-11-2009 6:35 AM
hi all,
if this is my value 69936.57
i want to disply with thousand seperator 69.936,57
can any one plz help me
Thanks
vamsee
12-11-2009 6:44 AM
12-11-2009 6:38 AM
12-11-2009 6:43 AM
USR01 Table stores Decimal notation for USER, the notation is based on the user profile..
USR01-DCPFM is the field, which holds that setting, if you can change it as per your requirement that is the solution.
Values are:
1.234.567,89
X 1,234,567.89
Y 1 234 567,89
12-11-2009 6:48 AM
12-11-2009 6:54 AM
if this is my value 69936.57 you value is not in any of the format neither 1 X or Y... so check the value.
as per your user setting it might be correct, but the person who is testing might be in some other format... so based on this condition of 1 x or Y you need to make up a logic to replace . with , or , with . as per the setting.
12-11-2009 7:05 AM
Sometime it will take the format from company code (or) County setting.
Please check the corresponding Company code 's and the respective Countries currency format.
12-11-2009 7:06 AM
hi..
It is easy for you to use the BAPI that Karthik has given.
Here is the sample code.
DATA: l_value_in(6) TYPE p DECIMALS 2,
l_value_out TYPE bapicurr-bapicurr.
l_value_in = '69936.57'.
CALL FUNCTION 'BAPI_CURRENCY_CONV_TO_EXTERNAL'
EXPORTING
currency = 'INR'
amount_internal = l_value_in
IMPORTING
amount_external = l_value_out
.
WRITE:/ l_value_out.
thanks,
Padma
12-11-2009 6:44 AM