Gender Pay Gap Analysis Report by Pay Grade and Job
Short answer: A custom ALV report that compares the full-time-equivalent basic pay of active employees for female and male groups by pay grade, job and organizational unit. Mean and median pay gap are calculated as percentages; groups with few people are hidden for confidentiality. It is used for pay transparency reporting and internal equity reviews.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_AHR_61016369 gives an employee list and S_PH0_48000513 (Ad Hoc Query) lists pay fields one by one; neither converts to full-time equivalent, calculates medians, the gap percentage between gender groups or hides small groups. The analysis is usually done in Excel with exported personal data, which creates a data protection risk.
Who uses it? HR directors, compensation and benefits specialists, diversity and inclusion teams and compliance units.
Closest standard alternatives
- S_PH0_48000513 Ad Hoc Query (HR Information System). Ad Hoc Query can list pay and gender fields; it does not calculate medians, full-time equivalents or gap percentages.
- S_AHR_61016369 Employee List. Gives an employee list; does not compare pay.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Organizational assignment: company code, employee group, organizational unit, job (driving table) | — | ECC + S/4 |
| PA0000HR Master Record: Infotype 0000 (Actions) | Employment status on the key date | PA0000-PERNR = PA0001-PERNR | ECC + S/4 |
| PA0002HR Master Record: Infotype 0002 (Personal Data) | Gender | PA0002-PERNR = PA0001-PERNR | ECC + S/4 |
| PA0008HR Master Record: Infotype 0008 (Basic Pay) | Basic pay, pay scale key and capacity utilization level | PA0008-PERNR = PA0001-PERNR | ECC + S/4 |
| T510Pay Scale Groups | Pay scale amount for indirectly valuated wage types | T510-TRFAR = PA0008-TRFAR AND T510-TRFGB = PA0008-TRFGB AND T510-TRFGR = PA0008-TRFGR AND T510-TRFST = PA0008-TRFST | ECC + S/4 |
| PA0014HR Master Record: Infotype 0014 (Recurring Payments/Deductions) | Optional: recurring payments and deductions | PA0014-PERNR = PA0001-PERNR | ECC + S/4 |
| T513SJob Titles | Job name | T513S-STELL = PA0001-STELL AND T513S-SPRSL = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 31.10.2026 |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No | 1000 |
| S_PERSG | Employee group | Range / multiple | PA0001-PERSG | No | 1 |
| R_GRADE | Group by pay grade | Radio button | — | No | X |
| R_JOB | Group by job | Radio button | — | No | — |
| R_ORG | Group by organizational unit | Radio button | — | No | — |
| P_MINGRP | Minimum group size (confidentiality) | Single value | — | No | 5 |
| P_IT14 | Include recurring payments (infotype 0014) | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | PA0001-BUKRS |
| 2 | Pay scale type | PA0008-TRFAR |
| 3 | Pay scale group | PA0008-TRFGR |
| 4 | Job | T513S-STLTX |
| 5 | Women | Calculated Active employees in the group with PA0002-GESCH = female |
| 6 | Men | Calculated Active employees in the group with PA0002-GESCH = male |
| 7 | Share of women % | Calculated Women ÷ (women + men) × 100 |
| 8 | Female mean pay | Calculated Mean FTE basic pay of women (PA0008 amounts ÷ BSGRD × 100) |
| 9 | Male mean pay | Calculated Mean FTE basic pay of men |
| 10 | Female median pay | Calculated Median FTE basic pay of women |
| 11 | Male median pay | Calculated Median FTE basic pay of men |
| 12 | Mean gap % | Calculated (Male mean − female mean) ÷ male mean × 100 |
| 13 | Median gap % | Calculated (Male median − female median) ÷ male median × 100 |
| 14 | Currency | PA0008-WAERS |
Sample output
| Company code | Pay scale type | Pay scale group | Job | Women | Men | Share of women % | Female mean pay | Male mean pay | Female median pay | Male median pay | Mean gap % | Median gap % | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 01 | B3 | Accounting specialist | 14 | 11 | 56 | 58,400 | 60,150 | 57,900 | 59,800 | 2.90 | 3.20 | TRY |
| 1000 | 01 | C1 | Production engineer | 9 | 27 | 25 | 71,200 | 76,800 | 70,500 | 77,100 | 7.30 | 8.60 | TRY |
| 1000 | 02 | D2 | Department manager | 3 | 8 | 27.30 | TRY |
How does the report work?
- Employees with active employment status (STAT2 = 3) on the key date are read from PA0000, and company code, personnel area, employee group and subgroup, organizational unit and job key from PA0001.
- Gender is taken from PA0002-GESCH; names and dates of birth are not included in the report.
- Basic pay is the sum of the wage type amounts in the PA0008 record valid on the key date; indirectly valuated wage types are calculated from the T510 pay scale amounts. Recurring payments from PA0014 can be added optionally.
- The amount is divided by the capacity utilization level (PA0008-BSGRD) to convert it to the full-time equivalent.
- Grouping is by pay grade (TRFAR, TRFGB, TRFGR), job (T513S text) or organizational unit as selected; for each group the number of women and men and the mean and median pay are calculated.
- Gap = (male median − female median) ÷ male median × 100. When either gender group is below the minimum group size, amounts are hidden and only the counts stay on the line.
Performance notes
Read the infotype tables directly with the key date and the selected personnel areas; cache T510 amounts per pay scale key for indirect valuation. Even with tens of thousands of employees the report runs in minutes; results are kept at group level, not per person.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Export to Excel The export contains group-level results only.
- Runs as a background job
Authorization objects
- P_ORGINRead authorization for infotypes 0001, 0002 and 0008 (personnel area, employee group)
- P_ABAPReport authorization for simplified authorization checks in mass reporting
Frequently asked questions
Does the report show individual pay?
No. Results are at group level, and amounts are hidden for groups below the minimum group size. If a person-level review is needed, a detail view behind a separate authorization can be added.
Does it produce the official report required by pay transparency rules?
The report produces the core indicators used in pay transparency reporting (mean and median gap, gender distribution). Because the scope and format of official reporting differ by country, they are checked against current regulation at installation and extra indicators are added if needed.
Can variable pay (bonuses) be included?
Yes. Recurring payments are added from infotype 0014 on request. Bonuses paid during the year can be read from payroll results and shown in separate columns; this requires reading the payroll cluster and increases the effort range.
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
Headcount Movement and Turnover Report by Department
A custom ALV report that gives, for the selected period and per organizational unit, opening headcount, hires, transfers between units, voluntary and …
Payroll Wage Type Period Comparison and Variance Report
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 …
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.