To access data stored in the system, InfoSet Query uses an InfoSet. It provides you with a view of data in specific parts of HR that is structured by infotype. On the initial InfoSet Query screen, the InfoSet is displayed with its field groups as an overview tree. This overview tree enables you to choose selection fields and output fields.
The InfoSets used in InfoSet Query are created and managed in SAP Query. When you create an InfoSet, you select a logical database on which the InfoSet is based, and determine which infotypes are included in the InfoSet. They are displayed in the InfoSet as field groups. After you have selected the infotypes, you can determine which fields are included in the field groups for each infotype.
In the standard system, all infotype-specific fields of the selected infotypes are included in the InfoSet. You are advised to check the selection of fields carefully, and adapt the selection to your reporting concept. Appropriately adjusted InfoSets are user-friendly, which makes working with InfoSet Query much simpler.
The InfoSet determines the objects that you can select with InfoSet Query. The following scenarios are possible:
The InfoSet is based on logical database PNP (or PNPCE)
InfoSets based on this logical database enable you to use InfoSet Query to select employees. You can use data from Personnel Administration and Time Management and payroll infotypes as selection criteria. From a technical perspective, this means you can use fields from infotypes 0000 to 0999 and 2000 to 2999 and payroll infotypes as selection criteria. For example, you can use the InfoSet to run a report that determines which employees have a particular place of residence.
Furthermore, you can create InfoSets on the basis of this logical database that enable you to report on the infotypes of related objects using InfoSet Query. For example, you can select persons who participated in a particular business event, and output the qualifications of the persons selected. To do this, you must select infotypes from Personnel Planning as well as infotypes from Personnel Administration when you create the InfoSet.
The InfoSet is based on logical database PAP
InfoSets based on this database enable you to use InfoSet Query to select applicants. You can use data from Recruitment as selection criteria and for output. From a technical perspective, this means you can use fields from specific Personnel Administration infotypes (such as 0001 and 0002) and fields from infotypes 4000 to 4999 as selection and output fields.
The InfoSet is based on logical database PCH
Provided that object selection is switched on, InfoSets based on this database enable you to use InfoSet Query to select objects of one object type, such as business events, qualifications, and positions. You can use all of the fields of infotypes allowed for the object in question, and all of the object types and their allowed infotypes that can be related with the selected object type, as selection criteria and for output.
When you create an InfoSet, you determine the object type that you can select using an InfoSet. The generated InfoSet can only be used to select this particular object type. If you want to create reports for business events, qualifications, or positions, for example, you must create three separate InfoSets. This means the reports can only be executed separately.
If you do not select an object type when you create the InfoSet, you can only use the InfoSet for InfoSet Query if object selection has been switched off.