Show TOC

HR in InfoSet QueryLocate this document in the navigation structure


You can use InfoSet Query to report on data from Human Resources (HR) by using InfoSets based on HR logical databases (PNP, PNPCE, PCH, PAP).

InfoSet Query is used in HR to create reports to meet requirements that are not satisfied by standard reports. By selecting selection fields and output fields, you can access data stored anywhere within the Human Resources System. You do not require programming skills to create reports using the InfoSet query.

InfoSet Query supports two types of reporting:

  • Ad-hoc Reporting

  • Query development

InfoSet Query has been integrated with HR information systems to enable you to perform ad-hoc reporting; that is, you can create and save queries in the standard query area. In this context, InfoSet Query is known in HR as Ad Hoc Query.

There are two ways of using InfoSet Query in HR:

  • With object selection:

    Before data is output, a set of objects is selected for which you can output data as required. You can edit the selected set of objects before output. For example, you can display the list of objects, display details on individual objects, use the set of objects as a new reporting set, or relate two sets to each other.

    This method of working has the advantage of good system performance because objects are selected using a selection routine that is particularly suitable for Human Resources.

  • In basic mode (object selection is switched off):

    In basic mode, the report's list of results is output immediately without a hit list being generated first.

    This method of working has the advantage of enabling you to use all InfoSet fields for selection purposes. Working with object selection restricts these options.

The following sections describe how to work with object selection. Always use object selection to create reports for HR. If you require further information on how to work with InfoSet Query in basic mode, see the documentation on maintaining queries.

  • You can use InfoSet Query to continue processing and report on sets of persons selected using Manager's Desktop or HIS. You can start InfoSet Query directly from these applications. The selected set of persons is transferred to InfoSet Query as a reporting set.

  • You can branch from InfoSet Query to general reporting. In this case, you only use the first InfoSet Query level, that is, you select an object set. To report on this hit list, you use a standard report.

  • You can enhance queries created using InfoSet Query by adding features that are only supported by SAP Query. If you require further information, see InfoSet Query.


If object selection is switched on, working with InfoSet Query consists of two steps:

  1. In the first step, you select a set of objects (= hit list) in accordance with selection criteria that you can specify as required.

    You can then process the hit list. You can also use InfoSet Query to create two hit lists. You can add them together, subtract one from the other, or use them to create intersections.

  2. In the second step, you output data as required for the objects selected in the first step.

    You can display and transfer reports as follows:

    • You can select a type of output list (basic list, statistics, or ranked list).

    • You can select an output type for full screen output (such as SAP List Viewer, standard list, spreadsheet, word processing).

    On the InfoSet Query screen, data is always output to SAP List Viewer. Furthermore, the preview of output includes formatting options such as summation and sorting.