Changing number format

[Former Member]

Hi ,

I need to change number format . for example if its 1 lakh 1,00,000.56 (56 paise) its displaying as

1.00.000,56.

how to convert it to 1,00,000.56

[Former Member]

Number format depends on your personal settings. You can change it by going to tcode SU01 and editing your profile or by following the path in the SAP menu System -> User Profile -> Own data and from there to Defaults tab.

[Former Member]

go to su01 and change

[Former Member]

Hi,

GOTO(Menubar)>System>User Profile>own data>Parameters tab

Or:SU01

Regards,

Gurpreet

[Former Member]

hi...

THIS IS TESTED CODE....

DATA: W_CHAR(50).

WRITE <FIELD> TO W_CHAR.

WRITE: / W_CHAR.

REGARDS

[Former Member]

Change the Decimal Notation in Defaults Tab of Tcode SU3.

Regards,

Jinson

[Former Member]

hello

CURRENCY_CONVERT this FM

Thnak u,

santhosh

[Former Member]

Number format depends on your personal settings. You can change it by going to tcode SU01 and editing your profile or by following the path in the SAP menu System -> User Profile -> Own data and from there to Defaults tab.

[Former Member]

hi,

is there any option other than su01. since i suggested su01 but its not been accepted since notation will vary server server . kindly suggest me solution other than su01.

Thanks,

divya

[Former Member]

Hello,

Just check whether 'Fixed Point Arithemetic ' (Attributes->Fixed Point Arithmetic ) is checked or not, if it isn't then you may face this kind of problem.

Thanks: Zahack

[Former Member]

hi,

Im working on smartforms.. here fixed arithmetic s not available.

Thanks,

divya

[Former Member]

Hi,

It'll solve ur problem.

v_1 = '1.00.000,56'.

TRANSLATE v_dat1 USING '.,,.' .

U'll get v_1 = '1,00,000.56'.

[Former Member]

Hi,

In Menu:- System --->User Profile --->Own data and there the ---> Defaults tab

This will definately help.

Please let know if i am wrong

Thanks and regards

Suraj

[Former Member]

System

-->User Profile

-->own data

-->Defaults tab

--> change decimal naotation accordingly.

Or try using thousand seperator

e.g. value(T)

[Former Member]

hi ,

i tried thousand separator (T) and changed decimal notation in su1.

But still its not working.

Edited by: Contact Abaper on Feb 16, 2009 4:52 PM

[Former Member]

y don u try this logic:

V_VAR = 1.00.000,56.

keep .56 in a variable.V_VAR1 = ,56

now use SPLIT.

SPLIT V_VAR AT ','

so V_VAR now has 1.00.000

REPLACE ALL OCCURENCES OF '.' IN V_VAR WITH ','

V_VAR will hve 1,00,000

REPLACE ALL OCCURENCES OF ',' IN V_VAR1 WITH '.'

v_var1 will have .56

now, concatenate v_var v_var1 into v_var.

v_var iwill now have 1,00,000.56