Security for the InfoSet (Ad Hoc) Query and QuickViewer Tools


Security for the InfoSet (Ad Hoc) Query and QuickViewer Tools

You can use two methods to ensure security for the InfoSet (Ad Hoc) Query tool and the QuickViewer tool: query groups and roles. The following sections describe these two methods.

Using Query Groups to Provide Security for the InfoSet (Ad Hoc) Query and QuickViewer Tools

You control access rights to the InfoSet (Ad Hoc) Query and QuickViewer tools by using query groups exactly the same way as you do with the SAP Query tool, as described earlier in this chapter, in the section "Using Query Groups to Provide Security for the SAP Query Tool."

Using Roles to Provide Security for the InfoSet (Ad Hoc) Query and QuickViewer Tools

Exactly one query group (with InfoSets assigned) must be assigned to a role. It is not required to enter or select individual usernames in the query group, because they are assigned in the role assignment. This means that a user who is assigned to a role is automatically copied into the query group assigned to the role. This assignment functions only when the user uses the role to navigate to (that is, call) the InfoSet (Ad Hoc) Query or QuickViewer tools. If the InfoSet (Ad Hoc) Query or QuickViewer tools are accessed via another method, the traditional access authorization implemented using SAP query groups is applicable. For a user to be able to save InfoSet queries or QuickViews, he or she needs authorization object S_QUERY, with the field ACTVT set to 02. If the user does not have this authorization, he or she can execute the available InfoSets and queries within the role, but he or she cannot save queries.



Things to Remember

  • The configuration of security for any area within SAP should be performed by a trained SAP security administrator.

  • Options for SAP Query tool authorizations are based on query groups and authorizations.

  • Restricting users based on query groups is an easy way of limiting their access.

  • Options for InfoSet (Ad Hoc) Query tool and QuickViewer tool authorizations are based on query groups and roles.

  • A special security authorization is required for users to be able to use the language translation facility.



Chapter 19. Creating Basic Reports with the InfoSet (Ad Hoc) Query Tool

In this chapter

Creating a Basic Query with the InfoSet (Ad Hoc) Query Tool 232

The Options Available on the InfoSet (Ad Hoc) Query Tool Screen 235

Modifying an InfoSet (Ad Hoc) Query 238

Saving an InfoSet (Ad Hoc) Query 238

Restrictions with the InfoSet (Ad Hoc) Query Tool 239

Security Considerations for Using the InfoSet (Ad Hoc) Query Tool 240

This chapter outlines how to create basic queries by using the InfoSet (Ad Hoc) Query tool. If you are looking to use the InfoSet (Ad Hoc) Query tool for reporting in the Human Capital Management (HCM) module only, you should review Chapter 15, "HR and Payroll Reporting Options in the HCM Module," before proceeding with this chapter.

Helpful Hint

Although it is recommended that you create SAP query reports live in your production environment, it is important while you are learning and training to practice in your test or quality assurance client so as not to have any impact on production while you are learning.


Unlike the SAP Query tool, covered in earlier chapters, the InfoSet (Ad Hoc) Query tool is a reporting utility that users can use to retrieve simple single-use lists of SAP R/3 data. The InfoSet (Ad Hoc) Query tool is a reporting tool delivered with SAP version 4.6 and above that is based on the functionality of the SAP Query tool and the Ad Hoc Query tool from earlier versions of SAP R/3.

Note

The Ad Hoc Query tool was a simple reporting utility designed for the HCM module in SAP's earliest versions. The Ad Hoc Query tool was renamed the InfoSet Query tool in version 4.6, and it was expanded for use in all modules (although when it is executed from within the HCM module, it is still referred to as the Ad Hoc Query tool). I refer to the tool throughout as the InfoSet (Ad Hoc) Query tool.


Unlike the SAP Query tool (which has multiple screens), with the InfoSet (Ad Hoc) Query tool, all query information, including the selection criteria for InfoSet (Ad Hoc) Query reporting, is available on a single screen. The InfoSet (Ad Hoc) Query tool is designed so that you can pose questions to the SAP system and receive real-time answers.