HCM Report Custom development ALV report

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.

TableRoleJoinSystem
HRPY_RGDIRDirectory for Payroll ResultsPayroll 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 functionPCL2-RELID = T500L-RELID AND PCL2-SRTFD = HRPY_RGDIR-PERNR + HRPY_RGDIR-SEQNRECC + S/4
T500LPersonnel Country GroupingCluster ID per country groupingT500L-MOLGA = T001P-MOLGAECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Name, org unit, cost center and payroll areaPA0001-PERNR = HRPY_RGDIR-PERNRECC + S/4
T512TWage Type TextsWage type textT512T-SPRSL = SY-LANGU AND T512T-MOLGA = T500L-MOLGAECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_ABKRSPayroll areaRange / multiplePA0001-ABKRSYesTM
P_CURPERCurrent period (YYYYPP)Single valueHRPY_RGDIR-FPPERYes202611
P_PRVPERComparison period (blank = previous period)Single valueHRPY_RGDIR-FPPERNo202610
S_PERNRPersonnel numberRange / multiplePA0001-PERNRNo00001024
S_ORGEHOrg unitRange / multiplePA0001-ORGEHNo50000120
S_LGARTWage typeRange / multipleT512T-LGARTNo/101
P_PCTVariance threshold (%)Single value—No15
P_AMTVariance threshold (amount)Single value—No2500

Output columns

#ColumnSource
1Pers. no.HRPY_RGDIR-PERNR
2NamePA0001-ENAME
3Org unitPA0001-ORGEH
4Cost centerPA0001-KOSTL
5Wage typeT512T-LGART
6Wage type textT512T-LGTXT
7Previous periodCalculated Sum of RT-BETRG in the comparison period
8Current periodCalculated Sum of RT-BETRG in the current period
9DifferenceCalculated Current period − previous period
10Difference (%)Calculated Difference ÷ |previous period| × 100
11FlagCalculated New, dropped or above threshold
12RetroCalculated X when the current period has a result with HRPY_RGDIR-INPER ≠ FPPER

Sample output

Pers. no.NameOrg unitCost centerWage typeWage type textPrevious periodCurrent periodDifferenceDifference (%)FlagRetro
00001024Deniz Aksoy500001204100/101Total gross48,50061,20012,70026.20Above threshold
00001024Deniz Aksoy5000012041002010Overtime 50%09,8009,800–New
00001187Mert Yalçın5000013442001500Meal allowance3,2000-3,200-100DroppedX
00001233Elif Karaca500001344200/560Amount paid38,90031,400-7,500-19.30Above threshold
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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’).
  2. 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.
  3. 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’.
  4. 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.
  5. 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

HCM Package Custom

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 …

3 components · v1.0

Related reports

HCM Program Custom Mass upload

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 …

PA0015 · PA0001 · PA0003 · T512Z

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.

Related report: Payroll Wage Type Period Comparison and Variance Report