decimal places in Query generator
I am observing a weird behavior in Query generator's execution of a simple sql query. the query is :
now, in the general settings - display - amounts , I put the decimal value as 4 or 6, then only it prints 0.0028 or 0.002834.
else it prints 0.00 (if the decimal place is 2). it should ideally have nothing to do with the display of amount. any idea?
(the effect is shown only after you change the decimal display, update it and close and reopen the SAP application.
Edited by: Binita Joshi on Apr 12, 2010 4:03 PM
You can try converting your sql result to char like this:
Select CAST(0.002834 AS CHAR)