02-27-2009 5:51 AM
Hi all,
Iam displaying by grid using classes.
Requrement is to get the sum of a partcular column and i used the following code
to populate the fieldcat.
clear wa_fieldcat.
wa_fieldcat-fieldname = 'SUM'.
wa_fieldcat-do_sum = 'X'.
wa_fieldcat-inttype = 'P' .
wa_fieldcat-key = space.
wa_fieldcat-col_pos = v_f_count.
wa_fieldcat-coltext = ' Total Spend '.
append wa_fieldcat to i_fieldcat.
Iam getting the sum value but syntax is like 1.000,00 , 3.300,00
mean ',' in place of '.' .
please help me out.
02-27-2009 5:55 AM
Hi,
open any session and then system - User profile - own data.
it will open a new session where you can maintain the defaults, date formats, currency formats,
now go to defaults tab,
decimal notification field will be there. you can select the exact format there. and save it
Now run the program and see the o/p
Regards,
Venkatesh
02-27-2009 5:53 AM
Hi,
Check the Amount formart selected in the Tcode SU01 userprofile.
02-27-2009 5:56 AM
oops!
I dont have the authorization to run that tcode.
r u sure that problem is in the format only...
thanks,
Anil.
02-27-2009 5:55 AM
Hi,
open any session and then system - User profile - own data.
it will open a new session where you can maintain the defaults, date formats, currency formats,
now go to defaults tab,
decimal notification field will be there. you can select the exact format there. and save it
Now run the program and see the o/p
Regards,
Venkatesh
02-27-2009 5:59 AM
Hi,
Check these settings.
SPRO->SAP Ref IMg->SAP Netweaver->General Settings->Define Contires In mySAP Systems
There find out the country from which the records are coming.
Check the decimal point format.
Regards,
Surendar Reddy.
02-27-2009 6:12 AM