Things to Remember

Things to Remember

  • The configuration of the SAP R/3 Query tools specific to the HCM module is not significantly different from the configuration for other SAP modules.

  • Three logical databases are designed for reporting in the HCM module: PnP, PcH, and PaP. PnP is the most common; it includes all infotypes from the Personnel Administration submodule.

  • You should create as few InfoSets as possible to eliminate redundancy. You should create one master InfoSet for each logical database.

  • The ability to access infotypes from the Personnel Administration submodule by using the logical database PnP is a special feature made available in SAP version 4.0.

  • When reporting based on Personnel Administration and Personnel Development data within the same SAP query, on the selection screen, you specify an object type and enter an evaluation path.

Chapter 17. Special Considerations for HR and Payroll Reporting in the HCM Module

In this chapter

Payroll Result Reporting with the SAP Query Tool 212

Eliminating Duplicate-Line Reporting in the HCM Module 213

Understanding Selection Period Fields on the Selection Screens of HCM Reports 217

Auditing Query Execution 219

Configuring HR Actions/Events to Improve Reporting Capabilities 220

Chapter 16, "Special Considerations for Configuring HR and Payroll Reporting in the HCM Module," provided a good deal of information on the special considerations required in the one-time configuration of the SAP Query tool for reporting in the Human Capital Management (HCM) module. This chapter provides tips and tricks on how best to design and execute human resources (HR) and payroll reports within the HCM module to maximize your success. If you are not using the HCM module of SAP, you can skip this chapter.

Payroll Result Reporting with the SAP Query Tool

The data that is reported when you use the SAP Query tool is primarily stored/displayed in infotypes. The traditional challenge with reporting on payroll results is that they are not stored in infotypes; rather, they are stored in payroll clusters. However, SAP recognizes this challenge and makes it possible for you to report on payroll results by using the SAP Query tool. You do so by having the data from the payroll clusters update infotypes that are designed to store the payroll results such that you can simply pick and choose the infotypes and fields you want to include in your reports to easily evaluate payroll results.

SAP R/3 provides a handful of predefined infotypes for this purpose. The wage types required for the evaluation can be entered in the infotypes listed in Table 17.1.

Table 17.1. Payroll Results Infotypes

Infotype Number

Infotype Name


Payroll Results: Period Values


Payroll Results: Period Values (not required at present)


Payroll Results: Monthly Accumulation


Payroll Results: Quarterly Accumulation


Payroll Results: Annual Accumulation

You can either activate these predefined infotypes via the Implementation Guide or create your own infotypes by using the same structures. You can enhance these infotypes by using additional wage types and then activating the infotypes. Turning on these infotypes for use makes the necessary data from the payroll result clusters available in the Personnel Administration submodule PnP logical database for reporting.


A number of tables are used to populate the infotypes used for payroll result reporting. Trained ABAP programmers who will likely be involved in the decision about whether to turn on these payroll results infotypes will be curious about which tables to use. It is safe to say that the decision about what and where to store varies by organization. However, the following notes are can guide trained payroll-specific ABAP programmers through the configuration:

  • Infotype 0402 needs the RT data for the current period results.

  • Infotypes 0458, 0459, and 0460 need a combination of CRT and TCRT.

  • You should use TCRT for any tax-related information (for example, /401, /403/406 (FICA), and so on).

  • You should use CRT for any company-specific wage types, but any wage types that are used for W2 purposes should be stored in the TCRT table as well.