Skip to Content
author's profile photo Former Member
Former Member

How to change order of columns in SAP Query

Hi,

I am working on SAP Query for first time using txn SQ01. Have some doubts on it.

-> If i want to change the order of the fields in the output in an existing sap query, i could not find any

way other than deselecting the fields and again selecting them in the order they want to be. Is there any

other way for this ? By the way, can we create an SAP query without an info set.

Thanks in Advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 09, 2009 at 03:46 PM

    Hi Prasad,

    if you chose ALV Grid output, you can rearrange the fields with the mouse and save it as default layout.

    Regards,

    Clemens

    By the way, we can not create an SAP query without an info set, but info set may be just a table or table join. You can create a quickview and then convert it to query.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2009 at 03:38 PM

    Hi Prasad,

    This blog will help you greatly.

    [Change of Query;

    Regards

    Abhii...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2009 at 03:47 PM

    solved it.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Prasad,

      Please take notice of the [Forum Rules of Engagement |https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement] ]

      here you can read

      Step 3: Provide Feedback and an Update

      Finally, it's nice to follow up with a brief update if you found the solution. People may try to help not because they know the answer, but because they are interested in solving the same problem; or people may just encounter the same issue in the future and be searching the archives. It's a good way to give back to the community, irrespective of whether you are a beginner or an expert.

      We are interested not so much that but much more how you solved your question.

      Thank you for cooperation.

      Clemens

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.