Skip to Content
Author's profile photo Jeevan Sagar

Some tips on ABAP query (SQ01) Part 1

This document is to give some tips to community members about ABAP querying.

The reason I created it as document rather than blog is because I would like other members of the community to add their tips and tricks by editing this document. Please feel share your knowledge by adding content, screenshots etc to this document.

I’m not gonna go into the basics of query writing as I think most of you know how to create a query using SQ01/SQ02/SQ03 tcode.

The following are some of the tips:

In SQ01 >> Go to layout design by click on “Basic List”.

3-27-2012 12-58-38 PM.png

1. In ABAP query, you don’t need to add tables of text fields, like you would do in ABAP programming, the system automatically adds them for you as shown in the screenshot below.

3-27-2012 12-32-02 PM.png

2. You can change the description of any field by clicking on it like this

3-27-2012 12-43-18 PM.png

changed to

3-27-2012 12-45-22 PM.png

3. You can apply color to any field, the process is shown below.

First click on the field in the right pane, then on the left pane lower half, you will see the field attributes.

3-27-2012 12-48-35 PM.png

Click Apply . After you apply you will see the assigned color like this.

3-27-2012 1-14-17 PM.png

4. You can change the order of the fields in the output just by dragging and dropping them here on the right pane.

3-27-2012 1-04-06 PM.png

3-27-2012 1-08-05 PM.png

When you execute the report you will see the output as shown below.

3-27-2012 1-18-13 PM.png

Your rating / liking / bookmarking / commenting is appreciated in advance.

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Alok Kumar Tiwari
      Alok Kumar Tiwari

      Hi,

      Thanks for sharing such a valuable information.

      Regards,

      Alok Tiwari

      Author's profile photo Sandip Shrivas
      Sandip Shrivas

      Hi,

      Thanks for sharing.

      Regards

      Sandip Shrivas

      Author's profile photo Mangalraj Senthamaraikannan
      Mangalraj Senthamaraikannan

      Hello Jeevan,

      It's a good contribution to SCN forums and thanks for the knowledge sharing.

      Regards

      Mangalraj.S

      Author's profile photo Former Member
      Former Member

      Hi,

      Thanx for sharing such a good information.

      Regd.

      PNU

      Author's profile photo Syam Babu
      Syam Babu

      Hi,

      Thanks for Sharing ...Good information.

      Syam.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.Very good documentation.

      Regards,

      Muthu Ganapathy

      Author's profile photo Former Member
      Former Member

      Hi Jeevan,

      Valuable reference.

      Appreciating your contributions.

      Author's profile photo Sharat Sugur
      Sharat Sugur

      Hi Jeevan,

      Thank you and appreciate for the valuable inputs and information you are providing in this forum are really helpful.

      Author's profile photo Eric Chen
      Eric Chen

      good document, thanks for sharing, it helps me.

      Author's profile photo Al Mahdi BENABDESSELAM
      Al Mahdi BENABDESSELAM

      Thanks for this guide

      Author's profile photo Edison Siason
      Edison Siason

      This is a very helpful guid !!!