[go: up one dir, main page]
Scribd
Upload
543 views7 pages

SAP Ad-Hoc Query

This document provides instructions for using the SAP Ad Hoc Query tool to build reports and queries on employee data. It describes the three main steps: 1) Entering the transaction code to access the tool, 2) Selecting the data area, user group, and infoset, and 3) Using the various sections of the working panel to choose input fields, output fields, selections, and restrictions to execute and view the query results. Key aspects covered include accessing time, organizational, compensation, and training management data, setting the reporting period, and applying AND links between multiple selections.

Uploaded by

susant kumat mandal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
543 views7 pages

SAP Ad-Hoc Query

This document provides instructions for using the SAP Ad Hoc Query tool to build reports and queries on employee data. It describes the three main steps: 1) Entering the transaction code to access the tool, 2) Selecting the data area, user group, and infoset, and 3) Using the various sections of the working panel to choose input fields, output fields, selections, and restrictions to execute and view the query results. Key aspects covered include accessing time, organizational, compensation, and training management data, setting the reporting period, and applying AND links between multiple selections.

Uploaded by

susant kumat mandal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

SAP AD HOC Query Tutorial (S_PH0_48000513)

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.

Step 1) In the SAP Command prompt , Enter transaction S_PH0_48000513

Step 2) In the next SAP screen,

1. Select a Work Area - queries linked to a specific client or to all clients


2. Choose a User Group - to access available infosets
3. Choose an Infoset - In the list select the desired infoset
4. Click the Check Mark Button
Step 3) The SAP Ad-hoc query working panel is shown-
Overview of the various sections

1. Field group/field=Where you define the selections and output fields


2. Reporting Period =This is where you define the period for which the
selected objects are to be retrieved.
3. 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
4. Testing the selections = to update the number of "hits" obtained by the
query
5. Functions=Some layout functionalities are accessible simply by using
your mouse or via buttons located in the "Preview of Output"
6. Main functions = create a new query, open existing query, execute a
query

Executing 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
Choosing Input
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.

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
Above example will produce a list of women (Gender Key = 2) AND born in
1976

Results
Click on output.

Results are displayed

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

You might also like