HCM Report Custom development ALV report

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.

TableRoleJoinSystem
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 datePA0000-PERNR = PA0001-PERNRECC + S/4
PA0002HR Master Record: Infotype 0002 (Personal Data)GenderPA0002-PERNR = PA0001-PERNRECC + S/4
PA0008HR Master Record: Infotype 0008 (Basic Pay)Basic pay, pay scale key and capacity utilization levelPA0008-PERNR = PA0001-PERNRECC + S/4
T510Pay Scale GroupsPay scale amount for indirectly valuated wage typesT510-TRFAR = PA0008-TRFAR AND T510-TRFGB = PA0008-TRFGB AND T510-TRFGR = PA0008-TRFGR AND T510-TRFST = PA0008-TRFSTECC + S/4
PA0014HR Master Record: Infotype 0014 (Recurring Payments/Deductions)Optional: recurring payments and deductionsPA0014-PERNR = PA0001-PERNRECC + S/4
T513SJob TitlesJob nameT513S-STELL = PA0001-STELL AND T513S-SPRSL = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KEYDTKey dateSingle valueSY-DATUMYes31.10.2026
S_BUKRSCompany codeRange / multiplePA0001-BUKRSYes1000
S_WERKSPersonnel areaRange / multiplePA0001-WERKSNo1000
S_PERSGEmployee groupRange / multiplePA0001-PERSGNo1
R_GRADEGroup by pay gradeRadio button—NoX
R_JOBGroup by jobRadio button—No—
R_ORGGroup by organizational unitRadio button—No—
P_MINGRPMinimum group size (confidentiality)Single value—No5
P_IT14Include recurring payments (infotype 0014)Checkbox—No—

Output columns

#ColumnSource
1Company codePA0001-BUKRS
2Pay scale typePA0008-TRFAR
3Pay scale groupPA0008-TRFGR
4JobT513S-STLTX
5WomenCalculated Active employees in the group with PA0002-GESCH = female
6MenCalculated Active employees in the group with PA0002-GESCH = male
7Share of women %Calculated Women ÷ (women + men) × 100
8Female mean payCalculated Mean FTE basic pay of women (PA0008 amounts ÷ BSGRD × 100)
9Male mean payCalculated Mean FTE basic pay of men
10Female median payCalculated Median FTE basic pay of women
11Male median payCalculated Median FTE basic pay of men
12Mean gap %Calculated (Male mean − female mean) ÷ male mean × 100
13Median gap %Calculated (Male median − female median) ÷ male median × 100
14CurrencyPA0008-WAERS

Sample output

Company codePay scale typePay scale groupJobWomenMenShare of women %Female mean payMale mean payFemale median payMale median payMean gap %Median gap %Currency
100001B3Accounting specialist14115658,40060,15057,90059,8002.903.20TRY
100001C1Production engineer9272571,20076,80070,50077,1007.308.60TRY
100002D2Department manager3827.30TRY
A view built with fictional sample data; not real system data.

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.

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

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 Report Custom ALV report

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 …

PA0000 · PA0001 · T529T · T527X

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: Gender Pay Gap Analysis Report by Pay Grade and Job