Value conversion

[Former Member]

Hello,

I want to convert the value 565.923.708,00 into the format 565,923,708.00. Is there ant function module, BAPI or conversion routine available for this?

Thanks

Nayan

[Former Member]

Just try with WRITE

WRITE a TO b.

Regards,

Atish

[Former Member]

what do you mean by write a to b????

I was just giving you an example...These values are not gonna be the same.

I want a general solution to this problem.

[Former Member]

Hi nayan,

It is a general solution. Actually this format is depend on the user master record and WRITE take care of it.

Regards,

Atish

[Former Member]

Hi

You need to check the number format from USR01 then only you can change

The you use Replace to change . to ,

Regards

Shiva

[Former Member]

Hi

Try this out:

<b>write <fieldname> currency <currency_variable>.</b>

THanks

Vijay

Plz reward points if hlepful

[gopi_narendra]

You can use the translate statement to change DOT's to COMMA's

Check this sample code

  select single * from USR01 where BNAME = SY-UNAME.

  case USR01-DCPFM.
    when 'X'.
      translate L_QNTY1 using ',.'.
      translate L_QNTY2 using ',.'.
    when ' ' .
      translate L_QNTY1 using '.,'.
      translate L_QNTY2 using '.,'.
    when others.

Regards

Gopi