# 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 same day and payroll status (infotype 0003) inconsistencies for active and recently terminated employees in one list. Payroll errors and the need for recalculation are caught before the payroll runs.

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/employee-master-data-consistency-check-before-payroll-report/


## Why is the standard not enough?

PA20 shows one employee; inconsistent actions or missing infotypes are usually noticed when the payroll driver (PC00_M99_CALC) fails. PU03 corrects the payroll status one by one but does not list which employees need it. There is no single list that lets teams check the whole population before the payroll cutoff.

### Closest standard alternatives

- PA20: Shows the infotypes of one employee; does no consistency check across the population.
- PU03: Changes the payroll status one by one; does not list employees that need correction.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA0000 | Actions: action type, reason, employment status, sequence number (driving table) | Read | - | ECC + S/4 |
| PA0001 | Organizational assignment: company code, personnel area, payroll area, cost center, name | Read | PA0001-PERNR = PA0000-PERNR | ECC + S/4 |
| PA0003 | Payroll status: payroll lock, accounted-to date, earliest retro date | Read | PA0003-PERNR = PA0000-PERNR | ECC + S/4 |
| PA0002 | Existence of the personal data record | Read | PA0002-PERNR = PA0000-PERNR | ECC + S/4 |
| PA0007 | Existence of the planned working time record | Read | PA0007-PERNR = PA0000-PERNR | ECC + S/4 |
| PA0008 | Existence of the basic pay record | Read | PA0008-PERNR = PA0000-PERNR | ECC + S/4 |
| PA0009 | Existence of the bank details record | Read | PA0009-PERNR = PA0000-PERNR | ECC + S/4 |
| T001P | Country grouping of the personnel area/subarea | Read | T001P-WERKS = PA0001-WERKS AND T001P-BTRTL = PA0001-BTRTL | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_ABKRS | Payroll area | Range / multiple | PA0001-ABKRS | Yes |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | No |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No |
| S_PERNR | Personnel number | Range / multiple | PA0000-PERNR | No |
| P_KEYDT | Key date (default: period end) | Single value | SY-DATUM | Yes |
| P_CHKIT | Check missing infotypes | Checkbox | - | No |
| P_CHKACT | Check actions and organizational assignment | Checkbox | - | No |
| P_CHKPAY | Check payroll status (IT0003) | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Pers. no. | PA0000-PERNR |
| Name | PA0001-ENAME |
| Personnel area | PA0001-WERKS |
| Payroll area | PA0001-ABKRS |
| Employment status | PA0000-STAT2 |
| Action | PA0000-MASSN |
| Action start | PA0000-BEGDA |
| Accounted to | PA0003-ABRDT |
| Check code | Calculated: Check group and number (e.g. IT-01, ORG-02, PAY-03) |
| Infotype | Calculated: Infotype the finding refers to |
| Finding | Calculated: Description from the check rule |
| Severity | Calculated: Stops payroll: error; may affect the result: warning |

## How does the report work?

1. For the selected payroll area and company code, PA0000 and PA0001 records valid on the key date are read; employees with an active employment status (STAT2) and those who left in the selected period are included.
2. Missing infotype check: for active employees a PA0002, PA0007, PA0008 and PA0009 record valid on the key date is required; missing ones are reported as 'mandatory infotype missing'.
3. Organizational assignment check: PA0001 records with a blank payroll area or cost center and date gaps between hire date and today; an error if the personnel area/subarea has no country grouping (MOLGA) in T001P.
4. Action check: more than one action with the same start date in PA0000 (SEQNR > 0) and an active status again after a leaving action.
5. Payroll status check: PA0003 records with the payroll lock (ABRSP) set; new hires whose hire date is before the accounted-to date (ABRDT), meaning a past period may not be calculated; leavers whose leaving date has passed but whose accounted-to date is still before it. Each finding is listed with a check code, description and severity.

## Authorization objects

- P_ORGIN: Read authorization for infotypes 0000, 0001, 0002, 0003, 0007, 0008, 0009
- P_ABAP: Simplified authorization check for the report (optional)

## Frequently asked questions

### Can the check list be extended?

Yes. Checks are designed like a rule table; country-specific infotypes (for example tax and social insurance data) or company-specific rules can be added as extra checks.

### Does the report correct the data?

No, it only reads. Corrections are made by an authorized user in PA30 or PU03; you can jump to the relevant transaction from a line.

### Does it run on S/4HANA?

Yes. HCM on S/4HANA (including H4S4) uses the same PA infotype tables, so the report runs unchanged.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-master-data-consistency-before-payroll
