Adhoc Query

[Former Member]

Hi Gurus,

Can someone help me with some practical scenarios for which you have used the adhoc query like what type of reports you have generated?

Thanks

Avy

[Former Member · Accepted solution]

Hi Avy,

Some example business scenarios:

Personal data list for employees in a particular organizational unit

Birthday list, marital status list, nationality list, etc.

Attendance/Absence list for employees in a particular employee subgroup

Annual leaves of all executive personnel, etc.

Address list for employees in a particular personnel area/subarea

Primary address for the employees residing in personnel area Istanbul, etc.

In addition to these, you can have any flat report from ant infotype of the personnel using Adhoc query.

Regards,

Dilek

[Former Member]

Thank you for your response Dilek & Sikindar

[sikindar_a]

Reporting tool :Standard reports

Purpose :Provide solutions for your most frequent reporting requirements

Advantages :Can be used immediately

No developments required

Limitations :Limited flexibility

Output fields cannot be selected as required

HIS

Purpose :Hierarchies are displayed as graphics

Reports are executed using selected structures or substructures, that is, using preselected sets of objects

Advantages :User-friendly method of displaying hierarchical structures

Integration with InfoSet Query and standard reports

No need to switch from one HR application to another if you want to execute reports from different applications

Little training required

Limitations : Limited flexibility

Tool is used to execute standard reports and customer reports

It cannot be used to create reports

InfoSet Query

Purpose :Intuitive, general SAP reporting tool used to create customer reports

Enables you to create reports for all areas of HR

When InfoSet Query is accessed from Human Resources (HR), the Query area and User group parameters already contain values and you can only perform ad hoc reporting. If InfoSet Query is accessed this way, it is called Ad Hoc Query in HR (see HR in InfoSet Query).

Advantages :User-friendly interface

Very easy to use

No programming required

If integrated with SAP Query, you can continue processing queries using SAP Query

Set operations enable you to create sets of objects as required for which data must be output

Can be included in roles using a suitable InfoSet

Limitations :InfoSets and user groups must be defined in SAP Query before you can use InfoSet Query

Multiline lists cannot be displayed

SAP Query

Purpose :General SAP reporting tool used to create customer reports

Individual definition of user groups, InfoSets, and queries

Advantages :Extremely flexible

No programming required

Queries can be provided in the SAP Easy Access menu

Includes numerous options for aggregating data, performing calculations, and displaying graphics

Enables you to display multiline lists

Enables you to define one basic list and several statistics and ranked lists for each query

Limitations :Restricted to data from the R/3 System

Each HR query can process data from just one HR logical database:

PNP: Administration, Time Management, and Payroll

PCH: Generally for all areas, but particularly suitable for reporting on data from Personnel Planning

PAP: Recruitment

Requires much more training than other options

Limitations:Data is extracted from OLTP systems, that is, real-time data is not accessed

Business Information Warehouse

Purpose :Analytical reporting tool used for information and decision-making purposes

Advantages : Extremely flexible

Facilitates complex calculations (calculation of averages, time series comparisons)

Enables you to access non-SAP data

Easy to use

Uses OLAP technology

Includes detailed Business Content (HR extractors, InfoCubes, key figures, and standard queries