02-16-2009 10:05 AM
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
02-16-2009 10:07 AM
02-16-2009 10:07 AM
Hi,
GOTO(Menubar)>System>User Profile>own data>Parameters tab
Or:SU01
Regards,
Gurpreet
02-16-2009 10:08 AM
hi...
THIS IS TESTED CODE....
DATA: W_CHAR(50).
WRITE <FIELD> TO W_CHAR.
WRITE: / W_CHAR.
REGARDS
02-16-2009 10:09 AM
Change the Decimal Notation in Defaults Tab of Tcode SU3.
Regards,
Jinson
02-16-2009 10:09 AM
02-16-2009 10:10 AM
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.
02-16-2009 10:11 AM
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
02-16-2009 10:12 AM
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
02-16-2009 10:20 AM
hi,
Im working on smartforms.. here fixed arithmetic s not available.
Thanks,
divya
02-16-2009 10:23 AM
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'.
02-16-2009 10:29 AM
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
02-16-2009 11:02 AM
System
-->User Profile
-->own data
-->Defaults tab
--> change decimal naotation accordingly.
Or try using thousand seperator
e.g. value(T)
02-16-2009 11:22 AM
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
02-16-2009 11:45 AM
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