Some tips on ABAP query (SQ01) Part 2
This is the sequel of the previous document I posted earlier.
Here I’m gonna explain some more tips about how to make your ABAP query to look more professional like a ABAP program report.
If you want to remove a table in the table join from infoset, you first need to delete it in the query.
Now on the selection screen if you want to change description of the fields, the order in which they appear, show hide intervals, etc you can do it in the query itself.
Below is an example
The selection screen changes like below:
Now you want to include your own conditions, rescrict the report to run only for certain values, hide fields, for that you just need to create a variant (shown above).
Now I create a variant with following conditions.
If you check the box Only display in catalog, users cannot see the variant, so they cannot change it themselves.
Now after the variant is applied,
Now you may want this report to start with this variant as default. So that users don’t have to input the values every time.
You’d have to assign the default variant in change query mode as shown below.
Your query is ready but it still not as user friendly as a program with transaction code so we assign the tcode to it.
Now click on the In background push button to know the program name of the query.
Go to SE93 and create a transaction of type report, assign the above program to the tcode.