Special Features of Functional Areas in the Human Resources Application (HR) 

You can use ABAP Query in Human Resources (HR) to request reports for data from Personnel Administration (PA-PA), Recruitment (PA-RC), Personnel Development (PA-PD), Organizational Management (PA-OS), Time Management (PT), and Training and Event Management (PE). You maintain queries as described in Creating Queries, which also mentions a number of the special features involved.

The logical databases PNP, PAP and PCH are available in HR for the creation of functional areas. Your choice of database depends on what components you want to carry out reporting for. The table below tells you what logical HR database (LDB) is assigned to what component:


Logical database

Organizational Management


Personnel Administration




Personnel Development


Time Management


Training and Event Management


On the infotype level, this means that

Since you most probably want to perform reporting for infotypes from multiple components in your functional areas, the database/component assignment displayed here is not adequate to help you decide which logical database to use.

The following five scenarios are possible:

Scenario 1:

You want to create a functional area for HR Master Data (Personnel Administration) and/or Time Management. You use the logical database PNP in this case.

Scenario 2:

You want to create a functional area for data from Organizational Management, Personnel Development, and/or Training and Event Management (infotypes 1000 to 1999). You use the logical database PCH in this case.

Scenario 3:

You want to create a functional area for data from Personnel Administration, Organizational Management, Personnel Development, and Training and Event Management. You use the logical database PCH, since it can reference the PNP database.

Scenario 4:

You want to create a functional area to report on data from Personnel Administration. In addition, you want access to the personal data that is stored in infotypes 1000 to 1999, such as a person's qualifications.

In this case, you use the logical database PNP.

The difference between this and scenario 3 is that this functional area can also be used in the Ad Hoc Query. Personal data from the logical database PCH can only be used as output fields, not as selection fields.

Scenario 5:

You want to create a functional area to report on data from Recruitment only. You use the logical database PAP.

In addition to the assignment of logical databases to components, there is also a dependency between the logical databases and the reporting tools that can be used for the functional areas.

LDB Used

Infotypes Used

Use in ABAP Query

Use in Ad Hoc Query


Administration and Time infotypes




Administration and Time infotypes and certain infotypes (from the name range 1000 to 1999) that store personal data

(see also scenario 3)



(person-related infotypes between 1000 and 1999 only as output fields


No relevance




No relevance



Creating Functional Areas

Maintenance of functional areas for HR differs from the procedure described in the rest of this section. The data fields in HR are already grouped on the basis of infotypes. To create a functional area for HR, proceed as follows:

  1. On the initial screen of Functional Area Maintenance enter a name for the functional area and choose Create.
  2. On the next screen, enter a description for the functional area and select the logical database in accordance with the information above.
  3. Note:

    You always create functional areas for HR components via logical databases. In other words, the option Functional area without logical database has no relevance here.

    Since customer infotypes (9000 to 9999) can be stored in either database, you may have to decide in certain cases which database to use to report on customer-specific infotypes.

    The HR Query: Functional Area Generator screen appears.

  4. Select the infotypes you want to have in your functional area and choose Program ® Execute. The Change Functional Area <Name of your functional area> screen appears.
  5. You can find general information on the subject of functional group maintenance in Assigning Fields to a Functional Group.

    All of the infotypes you selected for inclusion in the functional area are listed. In the second sub-tree (of the logical database), specify what fields should be contained in the functional groups of the functional area. To do so, select the name of an infotype and choose Expand sub-tree. All of the fields of this infotype are listed in the lower half of the screen.

    You should assign fields of an infotype (with the exception of key fields) to one functional group only.

    As far as the selection of key fields is concerned, we recommend for the logical database PNP that you define the personnel number from an infotype with time constraint 1 (such as infotype 0000 or 0001) as a key field. These infotypes always exist when a person is created. Similarly, the Object field from infotype 1000 should always be used for the logical database PCH.

    Do not include reserve fields or fields that you do not intend to use in the query in the functional groups of the functional area.

    In the standard system, the following functional groups are automatically proposed:

    the functional group Key fields

    one functional group per infotype that you included in the functional area (each infotype corresponds to a functional group).

    In the standard system, the specific fields of the infotypes are already assigned to the functional groups. You may not change this assignment.

    On the functional group creation screen, you can reactivate the report for generating a functional area. You do so by choosing Goto ® Add infotypes. This lets you add new infotypes to a functional area.

  6. Choose Functional area ® Save functional area.
  7. Choose Functional area ® Generate.
    You return to the Functional Area Maintenance initial screen
  8. Choose Goto ® Assign Functional Area to User Group. Select a user group and save your entries.