You can use SAP Query in HR to report on HR data. Queries are maintained as described in Creating Queries . The special features of queries created for HR are described in Maintaining Queries in the Human Resources Application . The maintenance procedure for HR InfoSets differs from the described procedure inasmuch as HR data fields are grouped together in infotypes.
InfoSet management in SAP Query is also used for InfoSet Query. For further information, see Functions for Managing InfoSets .
If you want to create InfoSets for HR, you can use logical databases PNP, PNPCE, PAP, and PCH (see HR Logical Databases ). The database you must use to create your InfoSet depends on the component in which the data you want to report on is stored.
The reports you can execute using InfoSets based on logical databases PNP (or PNPCE) or PCH are similar, but differ in that they can select different objects. The following table describes the connection between the logical database, and the infotypes you can include in an InfoSet. It also provides you with one or two examples of reports that you can execute using the appropriate InfoSets.
Logical database |
PNP/PNPCE* |
PCH |
PAP |
Selection of |
Persons |
Objects from Personnel Planning |
Applicants |
Infotypes that can be included in the InfoSet |
Infotypes for
|
If the object type is specified:
If the object type is not specified:
|
|
|
|||
Reporting examples |
|
|
|
* Logical database PNPCE (PNP Concurrent Employment) functions just like logical database PNP. The procedure for creating InfoSets is also the same. It only becomes significant if you work with Concurrent Employment.
The maintenance procedure for HR InfoSets differs from the procedure described so far in this section inasmuch as HR data fields are grouped together in infotypes. To set up an InfoSet for the HR application, proceed as follows:
On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose
Create
.
On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements.
Note
Customer infotypes can be created on all HR logical databases. In each individual case, therefore, you must decide which database to select so that you can report on customer infotypes.
This screen enables you to enter an authorization group . All of the queries that are subsequently created using this InfoSet can only be executed by persons who have this authorization group.
Choose .
This takes you to the
Infotype Selection for InfoSet <InfoSet name>
dialog box. It contains all of the infotypes that you can access using the selected logical database.
If you use logical database PCH to create an InfoSet with which to select objects in InfoSet Query, select the object type first.
Once you have selected the object type, you can select the object type's infotypes. Furthermore, all of the object types that can be related to the selected object type are listed below
Infotypes of related objects
. The next level in this tree outputs all of the relationships that can exist between the object type in question and the object type that can be selected. All of the selected object type’s infotypes are displayed on the last level.
If you use logical database PNPCE or PNP to create an InfoSet, you can use the infotypes from Personnel Administration. They are grouped together according to the current user group in Personnel Administration.
Furthermore, all of the object types that can be related to the
person
object are listed below
Infotypes of related objects
. The next level in this tree outputs all of the relationships that can exist between the respective object type and the
person
object type. The following relationships, for example, can exist between persons and qualifications:
fulfils
,
has potential for
,
interests and preferences
, and
dislikes
. All of the selected object type’s infotypes are displayed on the last level.
If you use logical database PAP to create an InfoSet, you can use the infotypes from Recruitment and some infotypes from Personnel Administration.
Choose the infotypes that are required in the InfoSet.
A field group is created in the InfoSet for each infotype that you select. The name of the field groups corresponds to the name of the infotype or consists of the object name, relationship name, and infotype name (for example,
qualification/fulfils/object
).
Choose .
This takes you to the
Change Infoset <InfoSet name>
screen. You now have the option of creating field groups and assigning fields as required for non-HR InfoSets. Field groups that correspond to infotypes and already contain fields, however, are always created for HR InfoSets. The field groups are displayed in an overview tree in the top right section of the screen.
The infotypes that you included in the InfoSet are displayed in an overview tree on the left of the screen. The infotype fields that are already included in field groups are displayed in a different color, and the corresponding field group ID is displayed.
Note
In the standard system, a field group is created automatically for each infotype that you included in the InfoSet (a field group corresponds to an infotype).
In the standard system, each field group contains the infotype-specific fields. To ensure that working with the InfoSet is as easy as possible, you are advised to restrict your use of fields in each field group to those you really require. This means you should remove fields that are not required.
An infotype's fields must only be assigned to the pertinent field group. Make sure this assignment is correct. If the assignment is incorrect, the InfoSet could be rendered unusable.
When an InfoSet is created, the following fields are transferred automatically to the first field group:
Logical database PNPCE or PNP
Personnel number
Logical database PAP
Applicant number
Logical database PCH
Object ID, plan version
, and
object type
Determine the fields that must be included in the field groups of your InfoSet. If you require further information, see Assigning Fields to a Field Group .
Note
If you want, you can change the default sequence of field groups and fields as required using Drag&Drop.
To save the InfoSet, choose .
To generate the InfoSet, choose .
On the
Change InfoSet (InfoSet name)
screen, you can choose
to add more infotypes to the InfoSet, or to remove infotypes from the InfoSet. Remember to regenerate the InfoSet afterwards.
This screen also enables you to update InfoSets if, for example, the system contains new additional fields for specific key values. To do so, choose
.Go back to the initial screen for InfoSet maintenance.
Choose
User group assignment
.
Select a user group, and save your entry.