Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Changing number format

Former Member
0 Likes
66,530

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

14 REPLIES 14
Read only

Former Member
0 Likes
21,382

go to su01 and change

Read only

Former Member
0 Likes
21,382

Hi,

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

Or:SU01

Regards,

Gurpreet

Read only

Former Member
0 Likes
21,382

hi...

THIS IS TESTED CODE....

DATA: W_CHAR(50).

WRITE <FIELD> TO W_CHAR.

WRITE: / W_CHAR.

REGARDS

Read only

Former Member
0 Likes
21,382

Change the Decimal Notation in Defaults Tab of Tcode SU3.

Regards,

Jinson

Read only

Former Member
0 Likes
21,382

hello

CURRENCY_CONVERT this FM

Thnak u,

santhosh

Read only

Former Member
21,382

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.

Read only

Former Member
0 Likes
21,382

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

Read only

Former Member
0 Likes
21,382

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

Read only

0 Likes
21,382

hi,

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

Thanks,

divya

Read only

Former Member
0 Likes
21,382

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

Read only

Former Member
0 Likes
21,382

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

Read only

Former Member
0 Likes
21,382

System

-->User Profile

-->own data

-->Defaults tab

--> change decimal naotation accordingly.

Or try using thousand seperator

e.g. value(T)

Read only

0 Likes
21,382

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

Read only

Former Member
0 Likes
21,382

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