All About Ad-Hoc Query

The Ad Hoc Query is a tool for building reports and queries on basic data of an employee.It offers access to data of all SAP infotypes. This tool can process data linked to: o Time management o Organizational management o Compensation management o Training etc. In the SAP Command prompt , Enter transaction S_PH0_48000513.

All About Ad-Hoc Query

In the next SAP screen,

  1. Select a Work Area – queries linked to a specific client or to all clients
    1. Choose a User Group – to access available infosets
  2. Choose an Infoset – In the list select the desired infoset
  3. Click the Check Mark Button

All About Ad-Hoc Query

The SAP Ad-hoc query working panel is shown-

All About Ad-Hoc Query

Overview of the various sections

  • Field group/field=Where you define the selections and output fields
  • Reporting Period =This is where you define the period for which the selected objects are to be retrieved.
  • Selections = Once you have ticked a field in the “Selection” column in the “Field Group/Fields” section, it will appear in the “Selections” section where you can restrict the employees selected
  • Testing the selections = to update the number of “hits” obtained by the query
  • Functions=Some layout functionalities are accessible simply by using your mouse or via buttons located in the “Preview of Output”
  • Main functions = create a new query, open existing query, execute a queryExecuting a Query:Choosing Output
  1. The section field / group fields shows list of all available infotypes
  2. Select the Infotye whose data you want in output
  3. Select the Infotype field by checking “output”
  4. Data is displayed at the bottom of the working panel

All About Ad-Hoc Query

Choosing Inpu
It is possible to restrict or limit the population selected, by using any element. Once you have ticked a field in the “Selection” column in the “Field Group/Fields” section, it will appear in the “Selections” section from where you can set the restrictions.

All About Ad-Hoc Query

  1. For Example , check the Selection Column for Year of Birth
  2. It appears in the Selection Section
  3. You may choose to restrict values via a pattern , single value , etc
  4. Enter the restriction value
    In case of multiple selections , the link between the selections is automatically AND

All About Ad-Hoc Query

Above example will produce a list of women (Gender Key = 2) AND born in 1976

Results
Click on output.

All About Ad-Hoc Query

Results are displayed

All About Ad-Hoc Query

Note: Make sure you select correct Reporting Period for your Query

All About Ad-Hoc Query

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.