cancel
Showing results for 
Search instead for 
Did you mean: 

format problem

Former Member
0 Kudos

Hi

i want to display the format coming in 55,192 to 55.192,.

kindly suggest.

Accepted Solutions (1)

Accepted Solutions (1)

gopi_narendra
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

u can use <b>replace all occurences of</b> statement

hope it helps

Former Member
0 Kudos

Hi,

For changing the format you have to change the country code to 'DE'.

The relevent field is as given.

vbpla-land1 = 'DE'.

This will change the output in the script as you desire.

Deserve Reward.

regards.