topic Re: Value conversion in Application Development and Automation Discussions

Value conversion

Former Member — Mon, 05 Nov 2007 06:12:09 GMT

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

Re: Value conversion

Former Member — Mon, 05 Nov 2007 06:13:17 GMT

Just try with WRITE

WRITE a TO b.

Regards,

Atish

Re: Value conversion

Former Member — Mon, 05 Nov 2007 06:16:50 GMT

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

The you use Replace to change . to ,

Regards

Shiva

Re: Value conversion

Former Member — Mon, 05 Nov 2007 06:16:58 GMT

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.

Re: Value conversion

Former Member — Mon, 05 Nov 2007 06:17:32 GMT

Try this out:

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

THanks

Vijay

Plz reward points if hlepful

Re: Value conversion

gopi_narendra — Mon, 05 Nov 2007 06:18:55 GMT

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

Re: Value conversion

Former Member — Mon, 05 Nov 2007 06:19:12 GMT

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