Ad Hoc Query

[Former Member]

Hello All,

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

[sikindar_a · Accepted solution]

https://forums.sdn.sap.com/click.jspa?searchID=24198246&messageID=5107230

https://forums.sdn.sap.com/click.jspa?searchID=24198246&messageID=6385628

https://forums.sdn.sap.com/click.jspa?searchID=24198246&messageID=6917398

https://forums.sdn.sap.com/click.jspa?searchID=24198246&messageID=4946733

Check this threads..........

[Former Member]

Answered

[shafiq_rehman3]

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

[former_member47879]

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]

Hi,

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

InfoSET:

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

http://www.insightcp.com/res_15.htm

http://www.ams.utoronto.ca/Assets/output/assets/adhoc_2990830.pdf.pdf

Regards

Devi