Payroll Wage Type Period Comparison and Variance Report
Short answer: A custom ALV report that compares the payroll results of one period with the previous period per employee and wage type, and lists variances above a percentage or amount threshold as well as wage types that appear or disappear. The payroll owner checks unusual changes in one list before the payment file and the posting to accounting.
- Estimated effort
- M · 4–7 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PC00_M99_CWTR lists wage type amounts period by period, but it does not put two periods side by side, calculate the difference and percentage, or isolate variances above a threshold. Teams match the output of two periods in Excel; retroactive calculations make that matching even harder.
Who uses it? Payroll specialists, payroll managers and internal control teams.
Closest standard alternatives
- PC00_M99_CWTR Wage Type Reporter. Lists wage type amounts; does not compare two periods or calculate variances.
- PC00_M99_CALC International Payroll. Runs or simulates payroll; produces no variance list between periods.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| HRPY_RGDIRDirectory for Payroll Results | Payroll results directory: period, sequence number, current result and retro information (driving table) | — | ECC + S/4 |
| PCL2HR Cluster 2 (PCL2) | Payroll results cluster (RT wage type table), read through the read function | PCL2-RELID = T500L-RELID AND PCL2-SRTFD = HRPY_RGDIR-PERNR + HRPY_RGDIR-SEQNR | ECC + S/4 |
| T500LPersonnel Country Grouping | Cluster ID per country grouping | T500L-MOLGA = T001P-MOLGA | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Name, org unit, cost center and payroll area | PA0001-PERNR = HRPY_RGDIR-PERNR | ECC + S/4 |
| T512TWage Type Texts | Wage type text | T512T-SPRSL = SY-LANGU AND T512T-MOLGA = T500L-MOLGA | ECC + S/4 |
BAPIs and functions used
- PYXX_READ_PAYROLL_RESULTRead Payroll Result. Reads the payroll result for each period from the cluster
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_ABKRS | Payroll area | Range / multiple | PA0001-ABKRS | Yes | TM |
| P_CURPER | Current period (YYYYPP) | Single value | HRPY_RGDIR-FPPER | Yes | 202611 |
| P_PRVPER | Comparison period (blank = previous period) | Single value | HRPY_RGDIR-FPPER | No | 202610 |
| S_PERNR | Personnel number | Range / multiple | PA0001-PERNR | No | 00001024 |
| S_ORGEH | Org unit | Range / multiple | PA0001-ORGEH | No | 50000120 |
| S_LGART | Wage type | Range / multiple | T512T-LGART | No | /101 |
| P_PCT | Variance threshold (%) | Single value | — | No | 15 |
| P_AMT | Variance threshold (amount) | Single value | — | No | 2500 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Pers. no. | HRPY_RGDIR-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Org unit | PA0001-ORGEH |
| 4 | Cost center | PA0001-KOSTL |
| 5 | Wage type | T512T-LGART |
| 6 | Wage type text | T512T-LGTXT |
| 7 | Previous period | Calculated Sum of RT-BETRG in the comparison period |
| 8 | Current period | Calculated Sum of RT-BETRG in the current period |
| 9 | Difference | Calculated Current period − previous period |
| 10 | Difference (%) | Calculated Difference ÷ |previous period| × 100 |
| 11 | Flag | Calculated New, dropped or above threshold |
| 12 | Retro | Calculated X when the current period has a result with HRPY_RGDIR-INPER ≠ FPPER |
Sample output
| Pers. no. | Name | Org unit | Cost center | Wage type | Wage type text | Previous period | Current period | Difference | Difference (%) | Flag | Retro |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001024 | Deniz Aksoy | 50000120 | 4100 | /101 | Total gross | 48,500 | 61,200 | 12,700 | 26.20 | Above threshold | |
| 00001024 | Deniz Aksoy | 50000120 | 4100 | 2010 | Overtime 50% | 0 | 9,800 | 9,800 | – | New | |
| 00001187 | Mert Yalçın | 50000134 | 4200 | 1500 | Meal allowance | 3,200 | 0 | -3,200 | -100 | Dropped | X |
| 00001233 | Elif Karaca | 50000134 | 4200 | /560 | Amount paid | 38,900 | 31,400 | -7,500 | -19.30 | Above threshold |
How does the report work?
- For the selected payroll area and employee selection, the valid results of the two periods to compare are found in HRPY_RGDIR (the latest result for each period, SRTZA = ‘A’).
- Each result is read with PYXX_READ_PAYROLL_RESULT; the cluster ID of the country comes from T500L. Amounts of the selected wage types are summed from the RT table per employee and wage type.
- Difference = current period amount − previous period amount; percentage = difference ÷ |previous period amount| × 100. A wage type missing in the previous period is flagged ’new’, one missing in the current period ‘dropped’.
- Lines whose absolute difference is below the amount threshold and whose percentage is below the percentage threshold are removed. If the current period contains a retroactive run (INPER ≠ FPPER), the line gets a note.
- Org unit, cost center and name come from PA0001, the wage type text from T512T; the result is shown with subtotals per employee.
Performance notes
Because the cluster is read per employee, run the report in the background for large payroll areas and limit the wage type selection to the ones on the control list (gross, net, statutory deductions, additional payments).
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a line opens the payroll result in PC_PAYRESULT.
- Export to Excel
- Runs as a background job
- Send the result by email Can be sent to the payroll manager before payroll is exited.
Authorization objects
- P_ORGINAuthorization to read personnel data by organizational assignment
- P_PCLXRead authorization for the payroll results cluster (PCL2)
- P_ABAPSimplified authorization check for the report (optional)
Frequently asked questions
Can simulation results be compared?
Simulation results are not saved in the cluster. The comparison is therefore done after the payroll run and before exit, which still leaves time to check before the payment file.
How are retroactive calculations handled?
The latest valid result of each period is compared. If the current period includes a retroactive recalculation, the line shows the Retro flag; part of the difference may belong to an earlier period.
Which wage types should be compared?
Total gross, net pay, statutory deductions and additional payment wage types are usually enough. The wage type list is stored in a selection variant and agreed with the payroll team during installation.
Packages that include this solution
Salary Review and Pay Equity Pack
A three-component pack that supports the periodic salary review from start to finish: gender pay gap analysis by pay grade and job, mass upload of …
Related reports
Mass Additional Payment (Infotype 0015) Upload Program
A custom program that posts bonuses, sales commissions, premiums and similar one-time payments from an Excel or CSV file to infotype 0015 in bulk. It …
Employee Bank Details Changed Since Last Payroll Report
A custom ALV control report that lists employees whose bank details (infotype 0009) were created or changed after the last payroll run or within a …
Employee Master Data Consistency Check Before Payroll Report
A custom ALV report that shows, before the payroll run, missing mandatory infotypes, gaps in the organizational assignment, overlapping actions on the …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.