topic Re: Selection query problem in Application Development and Automation Discussions

Selection query problem

Former Member — Mon, 29 Jun 2009 07:26:19 GMT

Hi,

I am selecting line items based on an invoice. But after selection, line items are not sequentially. But if I go to SE16 and view those data, they are coming in correct sequence( ascending order ). I checked with the fields' positions in the table level also. Query has the same sequence. But still it is in mis order. What may be the reason. How can I get in ascending order while selection itself.

Thanks and regards,

Venkat

Re: Selection query problem

Former Member — Mon, 29 Jun 2009 07:29:23 GMT

Please use statement SORT on Required fileds after SELECT.

Regards,

Re: Selection query problem

Former Member — Mon, 29 Jun 2009 07:29:28 GMT

Hi,

Use ORDER BY addition in your select statement with the fields you want to be in order

Do F1 on select to get more information about order by

check this link [ORDER BY|http://help.sap.com/erp2005_ehp_04/helpdata/EN/fc/eb3a53358411d1829f0000e829fbfe/frameset.htm]

Regards

Sarves

Re: Selection query problem

alex_m — Mon, 29 Jun 2009 07:29:59 GMT

Ideally the select statement picks the records in order which the where clause condition matches, you are using QUERY for your report or a custom program?. Try to sort the table after the select by invoice and item number.

Re: Selection query problem

Former Member — Mon, 29 Jun 2009 07:31:37 GMT

Hi Venkat,

If you are not geting item number in sequence then you can sort internal table according to item number after selection. But if you want it in your select query itselft then put key work ASCENDING in select query.

Regards,

Vijay