‎2009 Nov 27 6:49 PM
Hi
i am functional guy &I have created the infoset query .for inspection results.it is working good
but the output dispaly is like 2.1110000E+7 but actual result suppose to be display like this 21111000(user recorded like this only and want to see same)
how can i change this .....
Thanks
Sami
‎2009 Nov 29 2:58 PM
Hi Sami,
This is because data type of the field is numeric.
But you will not be able to make is character type as it is taking type from the database table field.
You can create an extra field in your query of character type and populate it with the value of this quantity field.
and then you will get the desired output.
Hope you understand it.
‎2009 Nov 29 1:43 PM
Hi Sami,
You have to declare a character variable of length same as the quantity field.
And then display the character value.
Regards,
Nisha Vengal.
‎2009 Nov 29 2:58 PM
Hi Sami,
This is because data type of the field is numeric.
But you will not be able to make is character type as it is taking type from the database table field.
You can create an extra field in your query of character type and populate it with the value of this quantity field.
and then you will get the desired output.
Hope you understand it.
‎2009 Nov 29 4:25 PM
thanks Nisha & Bhala,
Can you please guide how to create extra field in my query and how to populate
if possible tell me step by step
thanks
Sami
‎2009 Nov 29 4:45 PM
Hi Sami,
Check this
http://help.sap.com/printdocu/core/Print46c/EN/data/pdf/BCSRVQUE/BCSRVQUE.pdf
Edited by: Harsh Bhalla on Nov 29, 2009 10:16 PM