Use
The Wage Type Distribution report enables you to display wage types for several payroll periods. It does not take into consideration differences resulting from retroactive payroll. The report shows the current values (number and amount) for each wage type. The report evaluates the payroll records that are marked with update indicator ‘A’ when the report is run. Subsequent reporting runs may not give the same result if - in the intervening period - retroactive payroll has taken place for the evaluation period. The wage type distribution uses the data from the results table RT for the relevant payroll result. The employee’s organizational assignment is also evaluated from the payroll result. This data is taken from the
Work Center Basic Pay
table (WPBP).
The wage type distribution offers you the following options for evaluation:
Individual reporting for a specific personnel number or name.
Totals evaluation without specifying a personnel number or name.
Note
You cannot use wage type distribution to run a report for several countries. You can only select payroll areas from one country for reporting.
You use the following parameters to determine how the appearance of the wage type statement:
Wage type for evaluation
Enter all wage types that are to be evaluated. If you do not make an entry here, the system selects all wage types. Note that you can only select wage types that occur in the RT table.
Evaluation start date
Evaluation start date and evaluation end date define the evaluation period. Enter the year and payroll period for the start of the evaluation.
Evaluation end date
This parameter delimits the evaluation period. If you do not make an entry here, only the period from the period from the parameter Evaluation start date is evaluated.
Sorting sequence
This parameter determines the sorting sequence in the display. You can control the display using the following selection criteria:
Company codes
Personnel areas
Personnel subarea
Cost center
Employee group
Employee subgroup
Organizational unit
The values for the sort criteria are taken from the WPBP table.
If you sort and evaluate by cost center, the employees most recent work center data (WPBP table) is relevant for the assignment of wage types. There is no evaluation of cost accounting data. The report does not consider cost distribution or cost assignment. It only considers the employee’s last master cost center in the evaluation period.
Sort names
The employees’ names are printed in the case of individual evaluation. These are sorted by personnel number in ascending order. If you flag this parameter, the data is sorted by surname.
Evaluation type
The following evaluation types are available:
Individual evaluation
Number and amount per wage type are displayed.
Totals evaluation
Only the selected wage types are displayed for all selected personnel numbers. The totals evaluation displays a compact version of the individual evaluation without specifying the personnel numbers or name of employees.
Totals formation
This parameter enables you to change the standard display by changing the sort criteria. You have the following options:
Total per sort group
Total after change of wage type
Total after change of personnel number
Note
The wage type statement requires the following programs or includes:
RPCLGV00 Run Wage Type Statement
RPCLGA10 Read Routines
RPCLGA20 Print Routines
RPCLGA30 Main Routines
RPCLGAx0 Read Program for Database PCL2 (Payroll Cluster)
The Read Program for Database PCL2 is different for each country version. For example, for the USA, the program RPCLGAU0 is used, for Germany RPCLGAD0.
The wage type statement writes the imported payroll results (RT, CRT, WPBP) to a sequential dataset. This is saved as an extract. The following formula represents the memory requirements:
Memory in bytes = Number of personnel numbers
x number of wage types
x number of imported payroll results
x record length (approx. 100 bytes)
Example: You want to run the wage type distribution for 3,000 employees for one period. For each employee there are about 500 wage types. For this extract, you require memory space of approx. 150 MByte (3 000 x 500 x 1 x 100).