Application of Logical Database for Payroll (SAP Library

Using the Logical Database for Payroll

Use

From Release 4.6A, the evaluation of payroll results is supported by a logical database that is integrated in the logical database PNP for HR master data. This tool enables you to create programs for the evaluation of payroll results both simply and quickly.

Using the logical database for payroll results has the following advantages for the user:

You can access the payroll results faster and more easily.

It is a simple and standardized way of evaluating the payroll results.

Evaluation reports use this standardized interface and have a standard appearance.

The performance of the evaluation reports is improved by using transparent tables for data selection.

The number of coding lines in the evaluation programs (reports) is reduced by up to 60 percent.

An evaluation report can be created in less time.

The logical database supports use of the HR process workbench. This improves integration in the whole payroll process.

The selection screen can be customized. To do this, you use the new report categories

Different sort variants (all the fields for WPBP and RGDIR can currently be sorted)

It is not necessary to customize the payroll infotypes.

Use the logical database for payroll for new reports that evaluate the payroll results.

Scope of Function

The most important functions are:

Data Retrieval

The logical database consists of special ABAP programs that also provide the programs in Payroll with the evaluation data. All the data in a payroll record is provided in the subobjects for a complex structure at a selected time. To evaluate the payroll results, you can use reports from the standard system or create your own reports.

Data Selection

The logical database provides a particular view of the database tables for Personnel Administration (PA-PA) or Payroll (PY) and enables you to select and evaluate payroll results according to particular criteria.

Employees can now be selected on the selection screen of the evaluation report according to organizational criteria, for example, you can select all employees in a payroll area, however, the selection is made using exclusively the payroll results.

Authorization

The system checks whether the user who started the evaluation has the correct authorization for this evaluation. The authorization concept corresponds to the concept of the previous PNP report.

Comparison of the Logical Database for HR Master Data and the Logical Database for Payroll

Technical Criteria or Enhancements	Logical Database for HR Master Data (PNP)	Logical Database for Payroll (PNP with Screen 900)
Time of data retrieval	There is only one date available for data retrieval: At the time of GET PERNR, all infotype records are placed in an internal table for one personnel number	Several data retrieval events exist: At the time of GET PERNR, all the infotype records are made available in an internal table (infotype table) for one personnel number At the time of GET PAYROLL, the payroll results for a personnel number are made available in a complex structure If all GET PAYROLL events have run for a personnel number, the event GET PERNR LATE is triggered
Retrieval of payroll data for the evaluation programs	Each internal table and field string (for example, RT, BT, SV, and so on) must be sorted and processed individually	A complex structure containing all tables (WPBP, SV, BT, and so on) for each country
Selection	According to infotypes Extends to the HR master data	According to payroll results Extends to the HR master data and payroll results
Evaluation report	Uses import macros (for example, RP-IMP-C2-RX) Sorting required	Uses complex structures You can use all fields in the internal tables HRPY_RGDIR and HRPY_WPBP and sort them as required Selection of required sort sequence using the Sort function in the report
Modifying the selection screen	In Customizing for Personnel Management under Human Resources Information System ® Reporting using: Report categories ( selection criteria)	In Customizing (when creating a report) using: Report categories The fields on the selection screen for the evaluation report are controlled using the new report categories. The main procedure for customizing the selection screen corresponds to the familiar procedure for customizing the PNP report categories.