Hierarchy
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR⤷
PA-OS (Application Component) Organizational Structure⤷
PP0C (Package) Organization and Planning - Customizing
IMG Activity
| ID | OHIX0701 | Create InfoSets for HR |
| Transaction Code | S_AHR_61010454 | IMG Activity: OHIX0701 |
| Created on | 19981221 | |
| Customizing Attributes | OHIX0701 | Maintain InfoSets |
| Customizing Activity | OHIX0701 | Maintain InfoSets |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | OHIX0701 |
Overview
This Customizing activity enables you to create InfoSets using HR logical databases. (From a technical point of view, this Customizing activity corresponds to the Customizing activity for the administration function of SAP Query, namely "Create InfoSets", transaction SQ02.)
In most cases, and to satisfy most requirements, the information and procedures described under 1. (General information and references) and 2. (Creating InfoSets) are sufficient.
Sections 3. (Settings for HR InfoSets) and 4. (Making InfoSet-specific settings) are only relevant if you need to make special demands on query generator logic.
1. General information and references
This section provides you with general information on how to create InfoSets, and references to additional relevant documentation.
2. Creating InfoSets
This section provides you with step-by-step instructions on how to create InfoSets.
3. Description of InfoSet-specific customizing options for HR InfoSets (that is, for logical databases PNPCE, PNP, PCH, and PAP)
This section provides you with general information on the customizing options for query generator logic, and a description of all available switches.
4. Making InfoSet-specific settings
This section provides you with step-by-step instructions on how to make query generator logic settings for an InfoSet.
1. General information and references
SAP Query and InfoSet Query (which is called Ad Hoc Query in HR) enable you to report on data in the SAP System. This system consists of several hundred thousand fields in logical databases and tables alone. It would therefore be impractical to allow you to select from all of these fields when queries are created. To restrict the set of fields and put them in a user-friendly structure, InfoSets (which used to be called functional areas) are created. They determine the fields which the user can report on in a query. InfoSets are therefore created before queries.
InfoSet maintenance in HR differs from the general procedure because data fields in HR are already grouped together in infotypes.
If you create an InfoSet in HR, you must note the following:
In the first step, you select an HR logical database. To create InfoSets for HR, you can use logical databases PNPCE, PNP, PAP, and PCH. To report on travel data, you can use Travel Management's logical database PTRVP, which enables you to access a mini HR master record. The database you use to create your InfoSet is determined by the component whose data you want to report on. Customer-specific infotypes (9000 to 9999) can be stored on all logical databases, which means that if you want to report on customer-specific infotypes, you must decide each time which database to access.
The reports that you can run using InfoSets may be similar, but are different with respect to the objects that can be selected. The following text describes the connection between the logical database, the objects that can be selected, and the infotypes you can include in an InfoSet.
Logical databases PNPCE and PNP
InfoSets based on logical database PNP enable you to select persons in your query. The following infotypes are available for PNP:
- Personnel Administration (0000-0999)
- Time Management (2000-2999)
- Payroll infotypes
- Infotypes for Personnel Planning objects that can be related with persons
- Customer-specific infotypes
Example: Select all persons who participated in a particular business event, output the business event prices.
Logical database PCH
You can specify an object type for InfoSets based on logical database PCH. The object type can then be selected in the query. In this case, the following infotypes are available for PCH:
- All infotypes for the object type
- All infotypes for objects that can be related with the specified object type
- Customer-specific infotypes for the object
- Customer-specific infotypes for related objects
If you do not specify an object type, you can access all of the infotypes in Human Resources.
Logical database PAP
InfoSets based on logical database PAP enable you to select applicants in your query. The following infotypes are available for PAP:
- Recruitment (4000-4999)
- Specific infotypes in Personnel Administration (such as 0001 and 0002)
- Customer-specific infotypes
Example: Select all applicants who were hired last year to work on special projects. Output the addresses of selected applicants.
Recommendation
When you create HR InfoSets, select the infotypes you want to include in the InfoSet. A field group containing infotype-specific and available additional fields is then created for each infotype.
To ensure that working with the InfoSet is as easy as possible, you are advised to adjust the InfoSet so that it meets your requirements as accurately as possible. This means:
- Only include infotypes in an InfoSet if they contain fields that are required for reporting
- Only use fields in a field group if they are required for reporting, and remove fields that are not required
Activities
To create an InfoSet, proceed as follows:
- On the InfoSet: Initial Screen, enter a name for the InfoSet and choose Create.
This takes you to the following screen: InfoSet <NAME>: Title and Database.
- Enter a name for the InfoSet.
When the user creates a query, the InfoSet name is displayed as a long text.
- Enter an authorization group, if necessary. All of the queries created using this InfoSet can only be executed by persons with this authorization group.
- In the Data Source group box, select Logical database and then enter the HR logical database that you require. Do not specify a selection screen version. It could cause errors later.
- Choose Continue.
- This takes you to the following dialog box: Infotype Selection for InfoSet <InfoSet name>. It lists all of the infotypes that you can access via the selected logical database.
- If you use logical database PCH to create an InfoSet so that you can select objects in InfoSet Query, select the object type first.
- After you have selected the object type, you can select infotypes for the object type. Furthermore, all of the object types that can be related with the selected object type are listed under Infotypes of related objects. On the next level of this tree, all of the relationships are output that can exist between the object type in question and the selectable object type. 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, infotypes from Personnel Administration are retrieved. They are grouped in accordance with the current user group in Personnel Administration (SET/GET parameter UGR (user group (HR master)).
- Furthermore, all of the object types that can be related with the Persons object are listed under Infotypes of related objects. On the next level of this tree, all of the relationships are output that can exist between the object type in question and the Person object type. For example, the following relationships 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, infotypes from Recruitment and specific infotypes from Personnel Administration are retrieved.
- Choose Continue.
This takes you to the following screen: Change InfoSet <name>.
All of the infotypes that you included in the InfoSet are displayed on the left of the screen. Infotype fields that are already contained in field groups are displayed in a different color, and the field group ID is displayed. The InfoSet that already contains a field group per infotype is displayed on the right of the screen. The name of a field group matches the name of the infotype or consists of the name of the object, relationship, and infotype (such as Qualification/fulfils/object).
When an InfoSet is created, the following fields are included in the first field group automatically:
- Logical database PNP: personnel number
- Logical database PAP: applicant number
- Logical database PCH: object ID, plan version, and object type
- Determine the fields that the field groups of your InfoSet must contain. If you want to change the default sequence of field groups and fields, use Drag&Drop.
On the Change InfoSet <InfoSet name> screen, you can choose Edit --> Change infotype selection to enhance the InfoSet with additional infotypes or remove infotypes from the InfoSet. Remember to
Business Attributes
| ASAP Roadmap ID | 203 | Establish Master Data |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | OHIX0701 | 0 | HLA0100341 O HLA0009704 |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| DWBDUMMY | D - Dummy object | SQ02 | 404 | ABAP/4 Query: Maintain InfoSets |
History
| Last changed by/on | SAP | 20020506 |
| SAP Release Created in |
