Showing results for 
Search instead for 
Did you mean: 

Ad Hoc Query

Former Member
0 Kudos

Hello All,

I want to know that what is Ad Hoc Query and Info Set and how to use that?

Accepted Solutions (1)

Accepted Solutions (1)

Answers (4)

Answers (4)

Former Member
0 Kudos


Active Contributor
0 Kudos

Here is a step by step tutorial on how to create ad-hoc queries and create infoset /people/shafiq.rehman3/blog/2008/06/16/sap-adhoc-query-sq01-sq02-sq03

Active Contributor
0 Kudos

Ad Hoc Query is a simple and efficient tool for selecting and processing HR data.

Ad Hoc Query has the following advantages:

­ No time-consuming report definition

­ Selection fields and output fields are selected as required

­ Data is supplied on detailed report design

­ Results are determined very quickly because the database is accessed directly

­ The resulting set is displayed before output

­ Preview of output

Former Member
0 Kudos


Adhoc Query:

SAP reporting tools; SAP Query, InfoSet Query, Ad Hoc Query

Which logical database do we need data from? PNP u2013 HR Master and time data, PCH u2013 Personnel Development, PAP u2013 Applicant Master data or other

Ad Hoc Query Project is to create a process that will allow HRIS users to extract

HR data to satisfy standard business requirements without including AMS resources


This means that you can evaluate sequential datasets just as easily as SAP databases. An InfoSet not only allows you to restrict the number of fields and group them together in meaningful units, but also to define auxiliary fields and then process them like database fields.

Which infotypes do we need to include in the functional area?

PNP includes infotypes 0000 to 0999 and 2000 to 2999,

PCH includes infotypes 1000 to 1999 and

PAP includes infotypes 4000 u2013 4005 (as well as some PA infotypes)

For reference follow the links