InfoSets in the HR Application 

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, 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 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

PCH

PAP

Selection of

Persons

Objects from Personnel Planning

Applicants

Infotypes that can be included in the InfoSet

Infotypes for

  • Personnel Administration (0000-0999)
  • Time Management (2000-2999)
  • Payroll infotypes
  • Infotypes for Personnel Planning objects that can be related to persons

If the object type is specified:

  • Infotypes for the object type
  • Infotypes for objects that can be related to the specified object type

If the object type is not specified:

  • All infotypes
  • Infotypes for Recruitment (4000-4999)
  • Some infotypes for Personnel Administration (such as 0001 and 0002)
  • Customer infotypes

Reporting examples

  • Selection of all persons who participated in a specific business event, output of prices for reserved business events
  • Selection of all persons assigned to a specific personnel area, output of qualifications held by these persons
  • Selection of all business events held in London in March, output of all persons who participated in these business events
  • Selection of all positions assigned to a specific organizational unit, output of all persons assigned to the positions
  • Selection of all applicants hired last year to work on special projects, output of addresses for the applicants selected

 

Creating InfoSets

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:

  1. On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose Create.
  1. On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements.

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.

  1. 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.

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.

Furthermore, all of the object types that can be related to the persons 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.

  1. 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).

  1. 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 field group ID is displayed.

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:

  1. 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.

If you want, you can change the default sequence of field groups and fields as required using drag & drop.

  1. To save the InfoSet, choose .
  2. To generate the InfoSet, choose .
  3. On the Change InfoSet (InfoSet name) screen, you can choose Edit ® Change infotype selection 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 InfoSet ® Additional functions ® Update additional HR fields.

  4. Go back to the initial screen for InfoSet maintenance.
  5. Choose User group assignment.
  6. Select a user group, and save your entry.