Application of Logical Database for Payroll (SAP Library

Application of Logical Database for Payroll

Use

As of 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 simply and quickly.

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

You can access the payroll results more quickly and 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 process model. 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.

Recommendation

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 evaluation data. All the data of a payroll record is made available in the subobjects of a complex structure at a specified 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.

Example

On the selection screen of the evaluation report you can select employees according to organizational criteria; for example, you can select all employees in a payroll area, so that the selection is made using only 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)
Data retrieval event	There is just one data retrieval event: The GET PERNR event ensures that all infotype records are retrieved for a personnel number in an internal table (infotype table).	There are several data retrieval events: The GET PERNR event ensures that all infotype records are retrieved for a personnel number in an internal table (infotype table). The GET PAYROLL event ensures that the payroll results are retrieved for a personnel number in a complex structure. If all GET PAYROLL events have run for a personnel number, the GET PERNR LATE event is triggered
Retrieval of payroll data for the evaluation programs	Each internal table and field string (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.