topic Re: Changing number format in Application Development and Automation Discussions

Changing number format

Former Member — Mon, 16 Feb 2009 10:05:17 GMT

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

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:07:03 GMT

go to su01 and change

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:07:42 GMT

Hi,

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

Or:SU01

Regards,

Gurpreet

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:08:56 GMT

hi...

THIS IS TESTED CODE....

DATA: W_CHAR(50).

WRITE <FIELD> TO W_CHAR.

WRITE: / W_CHAR.

REGARDS

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:09:04 GMT

Change the Decimal Notation in Defaults Tab of Tcode SU3.

Regards,

Jinson

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:09:31 GMT

hello

CURRENCY_CONVERT this FM

Thnak u,

santhosh

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:10:03 GMT

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.

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:11:01 GMT

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

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:12:30 GMT

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

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:20:21 GMT

hi,

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

Thanks,

divya

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:23:44 GMT

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'.

Re: Changing number format

Former Member — Mon, 16 Feb 2009 10:29:41 GMT

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

Re: Changing number format

Former Member — Mon, 16 Feb 2009 11:02:20 GMT

System

-->User Profile

-->own data

-->Defaults tab

--> change decimal naotation accordingly.

Or try using thousand seperator

e.g. value(T)

Re: Changing number format

Former Member — Mon, 16 Feb 2009 11:22:26 GMT

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

Re: Changing number format

Former Member — Mon, 16 Feb 2009 11:45:04 GMT

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