Creating an Ad Hoc Query

Objectives

After completing this lesson, you will be able to:

  • Create an ad hoc query

Ad Hoc Query

Ad Hoc Query is a simple but powerful tool for reporting on HCM data. Programming skills are not required.

Watch the video to see how an Ad Hoc Query can be built.

The Ad Hoc Query reporting tool supports InfoSets, which store data in components of SAP HCM, for example:

  • Master data
  • Time management
  • Payroll
  • Personnel planning and development

Ad Hoc Query Screen: Functions

InfoSets and user groups form the basis of Ad Hoc query. InfoSets are assigned to user groups which group users together. InfoSets enable you to group infotype fields and calculated fields together to meet your reporting requirements. From the hit list displayed in the List Viewer section, you can review your report before the final output. Queries can be saved and re-used.

Ad Hoc Query Overview

To create an Ad Hoc query, select one or more Selection and Output fields from the top left-hand pane (1). The chosen Selection fields will appear in the selection area (or output area) in the top right-hand pane (2). If fields have both values and texts, you can specify whether only the text, only the value, or both are used.

In the output preview section at the bottom of the Ad Hoc Query screen (3), you can display real data in the Output fields.

Unlike other reporting tools, the selection is made directly from the database, so data is reported in real time. Personnel numbers are only selected if they meet the specified criteria and if the user has permission to see the data.

Log in to track your progress & complete quizzes