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.
Hi,
Thanks for sharing such a valuable information.
Regards,
Alok Tiwari
Hi,
Thanks for sharing.
Regards
Sandip Shrivas
Hello Jeevan,
It's a good contribution to SCN forums and thanks for the knowledge sharing.
Regards
Mangalraj.S
Hi,
Thanx for sharing such a good information.
Regd.
PNU
Hi,
Thanks for Sharing ...Good information.
Syam.
Thanks for sharing.Very good documentation.
Regards,
Muthu Ganapathy
Hi Jeevan,
Valuable reference.
Appreciating your contributions.
Hi Jeevan,
Thank you and appreciate for the valuable inputs and information you are providing in this forum are really helpful.
good document, thanks for sharing, it helps me.
Thanks for this guide
This is a very helpful guid !!!