Show TOC

 Wage Type Distribution (Report RPCLGV00)

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 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.

End of the note.

Scope of Function

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 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).

End of the note.