How to Replace ',' with '.' in workarea

[Former Member]

Hi ,

I am getting amount field from workarea wa_amount

wa_amount = 27.777,00

But I want to display output like 27,777.00 ( replace , with . & . with ,)

Please let me know the best possible way to do this

Regards

rahul

[Former Member]

Hi ,

I am getting amount field from workarea wa_amount

wa_amount = 27.777,00

But I want to display output like 27,777.00 ( replace , with . & . with ,)

Please let me know the best possible way to do this

Regards

rahul

[Former Member]

U have to do in User setings

[Former Member]

hi,

GO to transaction code su3 and change the user setting

go to defaults and changes the decimal notation.

Regards,

Himanshu Verma

[gabriel_braun]

shama,

You have to define the Decimal Notation with the transaction SU3 in the tab Defaults.

There are three different standard Decimal Notations avaiable in the SAP system.

You have to select the one that you need and hit the save key.

After that you have to log off the system and log in again.

Good Luck

Gabriel

[Former Member]

Got to System->User Profile->User Defaults .The maintain user default screen is displayed.

In decimal notation box , choose the option u wanted.

press save button on application tool bar.

Choose the menu path System->Log Off. The log off dialog box is displayed.

press yes button.you will be logged off from the systm

New user defauls will be in effect the next time you log in.

Reward If helpful

[Former Member]

hi,

do like this.

System -> User Profile -> own data -> there one tab wil be there "DEFAULTS" -> There you need to change DECIMAL NOTATION.

regards'

Sandeep REddy

[Former Member]

Hi,

to change from , to . use

translate <value> using ',.'

Regards

Jaime

Edited by: Jaime Cordeiro on May 27, 2008 5:21 PM

[Former Member]

Hello Rahul,

The best & easiest way is to use REPLACE ALL OCCURENCES OF .

This is rather more flexible ,

For Egu2026.When you have a requiremnet to replace all the commas with spaces you can use the following syntaxu2026u2026.

REPLACE ALL OCCURRENCES OF ',' IN wa_final-last_name WITH ' .' .

Or u can go using one FM

Replace the special Characters.

Try using this function - it replaces special characters:

SCP_REPLACE_STRANGE_CHARS

This function module replaces special characters like ñ,Í,ü,ú,á,é,ó etc with n,I,u,a,e,ou2026

Try it, It works

Regards

Rohini devi.