thousand seperator required in value

[Former Member]

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

[former_member205763]

USe this BAPI BAPI_CURRENCY_CONV_TO_EXTERNAL.

кu03B1ятu03B9к

[former_member156446]

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

[Former Member]

i checked it

it is 1 but also not coming

,,,,,,,,,,,vamsee

[former_member156446]

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.

[Former Member]

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.

[Former Member]

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

[former_member206377]

Use WRITE statement with CURRENCY addition