Creating InfoSets

Objective

After completing this lesson, you will be able to create a new InfoSet to include the information required for reporting

InfoSet Maintenance Screens

The maintenance interface for an InfoSet is set up as follows:

You select infotypes for an InfoSet using the checkboxes in a tree control.
If you create an InfoSet using HR master data, such as the logical database PNPCE or PNP, the HR infotypes are grouped according to the selected user group. You can set the user group through the Change User Group View function. In the infotypes of related objects group, use allowed relationships to select the objects from personnel planning and related infotypes.
You can define the sequence of field groups within an InfoSet and the sequence of fields in a field group. You can rename field groups and fields. The InfoSet is displayed in the InfoSet Query according to the settings that were made when it was created.
You can add additional infotypes or delete existing ones. You can only delete an infotype if none of its fields are used in a query.

Initial Maintenance Screen for Reporting on Personnel Planning Objects

If you use the logical database PCH to create an InfoSet to select objects in the InfoSet query, first select the object type.

The infotypes are then available for selection. In addition, all object types with which the selected object type can be related are listed under Infotypes of related objects. The next level of this hierarchy display shows all relationships that can exist between the relevant object type and the object type that can be selected.

The next level of display shows the infotypes for the selected objects.

Maintenance Interface

The InfoSet maintenance interface is divided into the following sections:

Data field management:
The complete left-hand side of the screen displays data field management in a tree structure.
Field group management:
This section is located at the top right corner in a tree structure.
Technical details management:
This section is located at the bottom right of the screen and displays the details of a field for detailed processing when you double-click the field. The data field is displayed in two different formats, with or without text field. If the data field is displayed with text field, it means that the system has found a text for this field, for example, in another table. You can find the link through a foreign key in the dictionary. When you process the query, specify in the settings whether the system outputs the value of the data field or the value of the text field.

Note

To see the context menu of functions for the nodes in the tree structure, right-click an object. For example, to assign a data field to a field group, right-click the relevant field group. In the query, you can only select fields that you have assigned to a field group.

Create an InfoSet

ExerciseStart Exercise

Business Example

As the HR Analyst, you must provide various reports for managers. You have received a request for reports based on the PNPCE and PCH databases. You need to set up infosets to create the requested reports.

Steps

Define and generate an InfoSet for Personnel Administration using the logical database PNPCE. The InfoSet is to contain infotypes 0000-0004 and 0006-0008. Name the new InfoSet:PA##. Assign the InfoSet to your user group.
1. On the SAP Easy Access screen, choose Tools → ABAP Workbench → Utilities → SAP Query → nfoSets (SQ02).
  Note
  Alternatively, you can choose Human Resources → Information System → Settings → Current → Settings → SAP Query: Maintain InfoSets.
2. On the InfoSet: Initial screen, in the InfoSet field, enter PA## and choose Create. The InfoSet: Title and Databasescreen displays.
3. Enter PA## in the Name field.
4. In the Data Source section, select Logical database, enter PNPCE, and choose Continue. The Infotype selection for InfoSet PA_## (Logical database PNPCE) screen displays.
5. From the Infotype column, choose the infotypes for the InfoSet (infotypes 0000-0004 and 0006 - 0008). If necessary, use the search icon to find the required infotypes.
6. Choose Continue. The InfoSet is created and displayed in a selection tree.
7. Choose Generate and return to the InfoSet: Initial screen.
8. Choose the Role/User Group Assignmentpushbutton.
9. Select your user group S4HR58## and save your entries.
10. Return to the SAP Easy Access screen
Define and generate an InfoSet for Training and Event Management using the logical database PCH (name the new InfoSet PE_##). Use the object type Course Type (D) (or business event type) and infotypes 1000 to 1002. Assign the InfoSet to your user group.
1. On the SAP Easy Access screen, choose Tools → ABAP Workbench → Utilities → SAP Query → InfoSets.
  Note
  Alternatively, you can choose Human Resources → Information System → Settings → Current Settings → SAP Query: Maintain InfoSets.
2. On the InfoSet: Initial screen, enter PE## in the InfoSet field.
3. Choose Create.
4. In the InfoSet: Title and Database screen, enter PE##.
5. In the Data Source section, select Logical database and enter PCH in the field.
6. Choose Continue.
7. In the Infotype selection for InfoSetPE## (Logical database PCH) screen, choose the Determine object type pushbutton. Choose the object type Course Type and the infotypes 1000 to 1002. Choose Continue. The InfoSet is created and displayed in a selection tree.
8. On the Change InfoSet PE## screen, choose Generate and return to the InfoSet: Initial screen.
9. Choose the Role/User Group Assignment pushbutton, select your user group S4HR58##, and save your entries.
  Return to the SAP Easy Access screen.
Define an InfoSet using the logical database PNPCE that enables you to report on Personnel Administration data (infotypes 0000-0002) and output the qualifications held by a person (the name of the new InfoSet is PAQ##). Assign the InfoSet to your user group.
1. On the SAP Easy Access screen, choose Tools → ABAP Workbench → Utilities → SAP Query → InfoSets.
  Note
  Alternatively, you can choose Human Resources → Information System → Settings → Current Settings → SAP Query: Maintain InfoSets.
2. In the InfoSet: Initial screen, in the InfoSet field, enter PAQ_##, and choose Create.
3. In the InfoSet: Title and Database screen, enter PAQ_##.
4. In the Data Source section, select Logical database and enter PNPCE.
5. Choose Continue.
6. In the Infotype selection for InfoSet PAQ## (Logical database PNPCE), choose infotypes 0000 to 0002 from the Core Employee Info folder. Open the Infotypes of related objects folder and open the Qualification folder.
7. From the Qualification folder, open Fulfils and select Object (1000).
8. Choose Continue. The InfoSet is created and displayed in a selection tree.
9. On the Change InfoSet PAQ## screen, choose Generate and return to the InfoSet: Initial screen.
10. Choose the Role/User Group Assignment pushbutton, select your user group S4HR58##, and save your entries.
  Return to the SAP Easy Access screen.

Copy an InfoSet

ExerciseStart Exercise

Business Example

You need to generate a new report which is to be based on a copy of an existing InfoSet.

You need to make a copy of an InfoSet and then add infotypes to it.

Steps

Make a copy of InfoSet PA##and rename it PA2_##. Add infotypes 0009-0012 to it. Assign the InfoSet to your user group.
1. On the SAP Easy Access screen, choose Tools → ABAP Workbench → Utilities → SAP Query → InfoSets(SQ02).
  Note
  Alternatively, you can choose Human Resources → Information System → Settings → Current Settings → SAP Query: Maintain InfoSets.
2. On the InfoSet: Initial screen, in the InfoSet field, enter PA_## and choose Copy.
3. In the To field of the Copy an InfoSet dialog box, enter PA2_## and choose Continue.
4. Select the copied InfoSet PA2_## and choose Change.
5. On the Change InfoSet PA2_## screen, choose Edit → Change Info-type Selection.
6. On the Infotype selection for InfoSet PA2_## (Logical database PNPCE)screen, choose the infotypes that you want to add (0009 to 0012).
7. Choose Continue. The InfoSet is enhanced by the selected infotypes.
8. On the Change InfoSet PA2_## screen, choose Generateand return to the InfoSet Initial screen.
9. Choose the Role/User Group Assignment pushbutton and select your user group S4HR58##. Save your entries.
Change the names of some of the field groups by including the infotype numbers in the name of the field group.
1. Return to the InfoSet: Initial screen.
2. Choose InfoSet PA2_## and then choose Change.
3. In the Field Group data fields section of the screen, choose the field group that you want to change.
4. Right-click the field group and choose Change Field Group. On the Changing Field Groups screen, add the infotype numbers to the required infotypes in the Description field.
  Choose Continue.
5. Save your entries.
6. Choose Generate.
  Return to the SAP Easy Access screen.

Next lesson