SAP Query Reporting

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.