topic ABAP Query - Sorting Issue in Basic List (SQ03) in Application Development and Automation Discussions

ABAP Query - Sorting Issue in Basic List (SQ03)

Former Member — Thu, 03 Dec 2009 04:58:56 GMT

Hi,

I have developed a ABAP Query. I want to sort some of the fields, for which I need to add some output fields to the sort sequence box in the Basic List page in SQ03/SQ01. But, I am not able to drag and drop the fields directly. Please suggest how can this be done? Thanks in advance.

Best Regards,

Tejas Savla

Re: ABAP Query - Sorting Issue in Basic List (SQ03)

Former Member — Thu, 03 Dec 2009 05:20:59 GMT

Hi,

You can sort fields in query.

Go to tcode sq01 than go to the option infoset query.

In infoset query you can sort fields in descending or ascending order.

You can also select fields which you want to sort.

Regrds,

Nikhil.

Re: ABAP Query - Sorting Issue in Basic List (SQ03)

Former Member — Thu, 03 Dec 2009 05:32:32 GMT

Hi Abhishek,

There are three things related to Query.

1) You have to create the USER GROUP in SQ03.

2) You have to create the Infoset in SQ02. In this infoset you can write the logic of the program/Query what ever you want to perform.So you can sort the table in the infoset in the program logic.you have to create the output table of the query.

3) you have to create the Query in SQ01 and you have to associate the User group and infoset . you have to design the layput of the output you want to have.this output fields would be same as you have defined in infoset(step 2).

hope this will help you.

thanks

Tanmaya

Re: ABAP Query - Sorting Issue in Basic List (SQ03)

Former Member — Thu, 03 Dec 2009 06:36:42 GMT

Hi,

You can give the sort order of the fields while creating various listes , Basic , Static and ranked in SQ01.