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
0402	Payroll Results: Period Values
0403	Payroll Results: Period Values (not required at present)
0458	Payroll Results: Monthly Accumulation
0459	Payroll Results: Quarterly Accumulation
0460	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.

Note

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.