Show TOC

Overview of FunctionsLocate this document in the navigation structure

Use

Unlike SAP Query with its broader range of functions, InfoSet Query is also suitable for end users with little experience of HR Reporting. Even beginners are quickly able to use it, thanks to its clear list of available fields and preview of output function.

Prerequisites

Object selection is switched on (see Switch Object Selection On/Off).

Note

If you start InfoSet Query from the SAP Easy Access menu, an appropriate InfoSet is used automatically in the information systems of several HR components (such as the information system for Personnel Administration). Provided that you are assigned to the appropriate user group, you can start creating queries immediately. You can also save the created queries, but you cannot transport them using the Workbench Organizer.

If you want to start InfoSet Query in this way, you must be assigned to the appropriate user group. You can set up this assignment in SAP Query (see Functions for User Group Administration).

Features

  • In the top left section of the initial screen, the current InfoSet is displayed with its field groups in an overview tree. Each field group corresponds to an HR infotype. This overview tree enables you to choose selection fields and output fields. If you require further information, see InfoSet Display.

    Note

    The InfoSet that you use determines the object type that can be selected with InfoSet Query. If you use an InfoSet from Personnel Administration (logical database PNPCE or PNP), for example, the result of a selection is always a set of persons (personnel numbers). However, if you use an InfoSet from Personnel Planning, the result of a selection is always a set of objects of a specific object type. The object type, such as business event, position or central person, is determined when the InfoSet is created. If you require further information, see HR InfoSets for InfoSet Query and InfoSets in the HR Application.

  • In the top right section of the screen, the system displays the reporting period, reporting set, list of selection fields and options, and number of hits in the hit list. This screen section is used to determine selection criteria, and execute object selections. You can open and close the Reporting period and Reporting set screen sections. If you require further information, see Selection Display.

  • Once output fields have been selected, a preview of output with example data is displayed in the lower section of the screen. You can format output at this point. For example, you can change the order of columns. Furthermore, this screen section enables you to start outputting real data. If you require further information, see Output List Display.

Activities

The following steps represent the principle of reporting using InfoSet Query with object selection. For detailed instructions, see the appropriate sections.

  1. Selection fields and output fields are chosen from field groups

  2. Values and selection options are entered for the selection fields, or a reporting period is selected

  3. All of the objects that meet the selection criteria are selected (for example, persons)

  4. Output is formatted, and output starts in this screen section if necessary

  5. The required data is output to a full screen

More Information