Summary
In this hour, you reviewed how to perform the configuration necessary for the query tools and how to use each query tool. The skills learned in this hour might be the most meaningful to you as an end user because they will empower you with the skills to extract data from your own SAP system. Keep in mind that trial and error is usually the best method for getting accustomed to working with queries in SAP. To this end, seek to “test” your queries in nonproduction systems.
You have also read how to create Ad Hoc queries, truly valuable to those who otherwise must rely on the system administration and programming staff to generate reports from the system. Using the simple InfoSet tool, you can pose complex questions and enjoy the output you need in just minutes. You also have the capability to perform further analysis of the data within the query or by saving or downloading the report to a local spreadsheet.
Q&A
| Q | Do users or System Administrators generally regulate the creation of Query Groups, InfoSets, and queries? |
| A | The use of different tools in SAP largely depends on the customer. In general, Query Groups and InfoSets are maintained by your company’s technical users, although the creation of queries varies. In some organizations, users see it as a great means of creating their own reports without seeking the assistance of the technical users. On the other hand, depending on your company’s security configuration, the creation of queries and QuickViews might be restricted to technical or super functional users only. |
| Q | What are the three main components of the Query family? |
| A | Query Groups, InfoSets, and administrative decisions (which are company specific) are the three main components of the Query family. |
| Q | When creating InfoSets in the Human Capital Management module, what is different about the configuration? |
| A | Unlike all other modules, the Field groups that are automatically created in your InfoSet contain fields based on InfoTypes automatically without the users having to add them. |
| Q | Out of the three query tools, which is the most robust reporting tool with the most features? |
| A | The SAP Query is the most robust. |
| Q | Does security restrict access in Query reporting? |
| A | There are several ways that security can influence the availability of data in Query reporting. Security depends on your company’s security configuration, but if you use logical databases, the security is built-in and uses your standard security profile when determining what data you have access to. |