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

Output display

Former Member
0 Likes
549

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
513

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.

4 REPLIES 4
Read only

Former Member
0 Likes
513

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.

Read only

Former Member
0 Likes
514

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.

Read only

0 Likes
513

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

Read only

0 Likes
513

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