SAP Query Reporting Switches

Hello.

I believe you’ve had some experience with SAP Query Reporting. It’s a powerful tool when you know how to use it and utilize its all features and functionality. It’s not just about SAP InfoSets and Ad-Hoc reports, but more about powerful tool to create flexible reports in MS Excel format.

Frequently we meet issues with Queries when there are empty cells, missed rows, double rows and etc. There is a good explanation why this happens. If you look into the code SAP generates for every InfoSet and then for every Query, there are some provide loops and unions. To manage the logic SAP uses to generate code for report there are some useful switches.

Here is an old document from SAP explaining when and how to use these switches.

SAP HR QUERY GENERATOR SWITCHES


Watching SAP Query

I think you’ve read SAP courses very carefully with attention. And you know SAP Query logging abilities for sure. I didn’t know that. I’ve read some courses and have found curious things I’d like to share with you.

For example, we can log everything user runs in ad-hoc query or SAP Query. Let’s set it up.
Open SQ02, menu Extras – Set Logs.
sq02 logging

Here we add infosets and info areas (like standard and global). The first column is for the area (space for standard and G for global). Second is for Infoset or asterisk.

Read More