Ansicht
Dokumentation

H99CWTR0 - Wage Type Reporter

BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Description

The wage type reporter evaluates wage types from the payroll results for a selected period. This is data from tables RT (Results Table) and WPBP (Work Place Basic Pay) for the payroll results. Other tables and data from infotypes are not evaluated.

Description of the selection parameters

Selection

The standard selection fields for the logical database PNP can be used. Note that a selection according to organizational criteria in these fields does not have to correspond to a selection of payroll results for the selected organizational entity. Retroactive changes to master data can lead to differences. We recommend that you include objects, which are used for the selection, in the object selection (see below).

Payroll Period

Together with the entries for the payroll period (example: selected period 01.01.1998 to 03.31.1998), in the Payroll Type field, you can enter the type of payroll you want to evaluate, for example:

• Regular payroll run

• Off-cycle payroll run

• Correction run

• Bonus payment

• Manual check

By entering the payroll period you can limit the amount of data to be evaluated by defining additional selection criteria for the following payroll types.

If you choose Regular Payroll, enter the following:

• Payroll area

• Payroll period

• Payroll year

If you want to compare two regular payroll runs, make the required entries for the comparison.

If you choose Off-cycle payroll, in the Special run field, enter the following:

• Payroll type

• Payroll ID

• Payment date of off-cycle payroll

If you want to compare two off-cycle payroll runs, make the required entries for the comparison.

If you have selected Perform Comparison, you can enter additional comparison parameters.

You can make the following comparisons:

• Compare one regular payroll run with another regular payroll run.

• Compare one special run with another special run from the same payroll type.

Period determination

You specify the desired view of the payroll results.

Example: selected period 01.01.1998 to 03.31.1998

For the in-period view, all results from all payroll types, which were created IN this period and correspond to the specified selection of payroll types, are selected. A payroll run IN February 1998 FOR December 1997 would be included in the example, however, a payroll run IN May 1998 FOR February 1998 would not.

For the for-period view, all results from all payroll types, that were created FOR this period and correspond to the specified selection of payroll types, are selected. A payroll run IN February 1998 FOR December 1997 would not be included in this selection. However, a payroll run IN May 1998 FOR February 1998 would.

Example: selected payroll period 11/2003

In-period view: The end date of the period is decisive for the period determination. The program takes into account all payroll results that were created IN this payroll period, depending on their payroll type. If you select a regular payroll period, then any off-cycle results that were created within the selected period are not taken into account.

For-period view: The end date of the period is decisive for the period determination. The program takes into account all results created FOR this payroll period, irrespective of their payroll type. If you select a regular payroll period, then any off-cycle results that were created for a special run within the selected period are not taken into account.

Example: selected special run A 0 12.10.2003

In-period view: Only the results created IN this special run are taken into account, irrespective of their payroll type.

For-period view: Only results created FOR this special run are taken into account, irrespective of their payroll type.

You can use this program to perform a comparison between two payroll periods of the same payroll type. The payroll areas for the periods to be compared can be different. However, the payroll areas must have the same periodicity.

Other selections

Wage type selection allows you to limit the selection to specific wage types.

Use Archived payroll results to allow access to the archived payroll results.

Use Object selection to specify which columns should appear in the output list and which objects should be hidden.

Example: You choose company code, wage type, and in-period.

The selected objects appear as columns in the output list. The objects that were not selected are hidden.

Output

You can choose from the following list displays:

• SAP List Viewer - List display with SAP List Viewer (Classic)

• SAP List Viewer - List display with SAP List Viewer (ALV) Grid Control

• Microsoft Excel

CAUTION: To use Microsoft Excel, you must at least use SAPGUI Version 4.5A, Windows 95, or NT4.0 and Excel 97.

The report is only batch-enabled if you use the SAP List Viewer.

Templates can be used. You should create templates and variants first.

List viewer

The SAP List Viewer output can be set out according to your requirements. You can move and hide columns, create totals and sort sequences, define filters and save layouts to use later. For more information, see the online documentation for the SAP List Viewer.

Caution: You should ensure that the object selection is compatible with the selected layout. It is only of limited use to use a layout with different object selections.

Excel output

We recommend the following when using the Excel output:

1. Start the report with the required selection without entering an Excel template.
   The raw data table is displayed.
2. You should first enter suitable column headers. Insert the headers as the first line.
3. Select all columns in the data area. It is not sufficient to limit the selection to the lines currently containing data since data may be entered in other lines in subsequent runs.
4. Choose the Pivot Table Wizard and create the required report. Insert this report in a new page in the table. For more information about working with pivot tables, see the Excel documentation.
   The required pivot table is displayed. To store this as a template, proceed as follows:
1. Go to the raw data table and select all data (not simply the column headers).
2. Delete the selected data
3. Set the cursor in the first column and second line (under the header).
4. Save this as the model template (.xlt).

You can now reuse this template. The object selection must be the same as when the template was created. When you start the report, the newly-filled table containing the raw data is displayed again. Select the table page with the pivot table and update it.

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 8422 Date: 20240520 Time: 085039     sap01-206 ( 121 ms )