# Gender Pay Gap Analysis Report by Pay Grade and Job

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

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: M (6–9 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/gender-pay-gap-analysis-report/


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

### Closest standard alternatives

- S_PH0_48000513: Ad Hoc Query can list pay and gender fields; it does not calculate medians, full-time equivalents or gap percentages.
- S_AHR_61016369: Gives an employee list; does not compare pay.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA0001 | Organizational assignment: company code, employee group, organizational unit, job (driving table) | Read | - | ECC + S/4 |
| PA0000 | Employment status on the key date | Read | PA0000-PERNR = PA0001-PERNR | ECC + S/4 |
| PA0002 | Gender | Read | PA0002-PERNR = PA0001-PERNR | ECC + S/4 |
| PA0008 | Basic pay, pay scale key and capacity utilization level | Read | PA0008-PERNR = PA0001-PERNR | ECC + S/4 |
| T510 | Pay scale amount for indirectly valuated wage types | Read | T510-TRFAR = PA0008-TRFAR AND T510-TRFGB = PA0008-TRFGB AND T510-TRFGR = PA0008-TRFGR AND T510-TRFST = PA0008-TRFST | ECC + S/4 |
| PA0014 | Optional: recurring payments and deductions | Read | PA0014-PERNR = PA0001-PERNR | ECC + S/4 |
| T513S | Job name | Read | T513S-STELL = PA0001-STELL AND T513S-SPRSL = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No |
| S_PERSG | Employee group | Range / multiple | PA0001-PERSG | No |
| R_GRADE | Group by pay grade | Radio button | - | No |
| 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 |
| P_IT14 | Include recurring payments (infotype 0014) | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | PA0001-BUKRS |
| Pay scale type | PA0008-TRFAR |
| Pay scale group | PA0008-TRFGR |
| Job | T513S-STLTX |
| Women | Calculated: Active employees in the group with PA0002-GESCH = female |
| Men | Calculated: Active employees in the group with PA0002-GESCH = male |
| Share of women % | Calculated: Women ÷ (women + men) × 100 |
| Female mean pay | Calculated: Mean FTE basic pay of women (PA0008 amounts ÷ BSGRD × 100) |
| Male mean pay | Calculated: Mean FTE basic pay of men |
| Female median pay | Calculated: Median FTE basic pay of women |
| Male median pay | Calculated: Median FTE basic pay of men |
| Mean gap % | Calculated: (Male mean − female mean) ÷ male mean × 100 |
| Median gap % | Calculated: (Male median − female median) ÷ male median × 100 |
| Currency | PA0008-WAERS |

## How does the report work?

1. 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.
2. Gender is taken from PA0002-GESCH; names and dates of birth are not included in the report.
3. 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.
4. The amount is divided by the capacity utilization level (PA0008-BSGRD) to convert it to the full-time equivalent.
5. 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.
6. 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.

## Authorization objects

- P_ORGIN: Read authorization for infotypes 0001, 0002 and 0008 (personnel area, employee group)
- P_ABAP: Report 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-gender-pay-gap-by-grade
