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”.

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.

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

changed to

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.

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

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

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

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