# Employee Bank Details Changed Since Last Payroll Report

> A custom ALV control report that lists employees whose bank details (infotype 0009) were created or changed after the last payroll run or within a selected date range, with the changing user and date. A four-eyes check is done before the payment file is created; the account number is masked.

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/employee-bank-details-changed-since-last-payroll-report/


## Why is the standard not enough?

The logged infotype changes report (S_AHR_61016380) lists changes of all infotypes in a generic, multi-line format; isolating bank details, filtering by the last payroll date and showing whether the change was made by the employee or by HR needs extra work. The payment program (PC00_M99_CDTA) creates the payment file without this check.

### Closest standard alternatives

- S_AHR_61016380: Lists changes of all infotypes in a generic format; does not isolate bank details against the last payroll date.
- PC00_M99_CDTA: Creates the payment file; does no pre-check for recently changed bank details.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PA0009 | Bank details: bank type, country, key, change date and user (driving table) | Read | - | ECC + S/4 |
| PA0003 | Payroll status: payroll accounted-to date | Read | PA0003-PERNR = PA0009-PERNR | ECC + S/4 |
| PA0001 | Name and payroll area | Read | PA0001-PERNR = PA0009-PERNR | ECC + S/4 |
| T549Q | Payroll period start and end dates | Read | T549Q-PERMO = T549A-PERMO AND T549A-ABKRS = PA0001-ABKRS | ECC + S/4 |
| PCL4 | Infotype change log (if active): previous bank key | Read | PCL4-RELID = 'LA' AND PCL4-SRTFD = PA0009-PERNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_ABKRS | Payroll area | Range / multiple | PA0001-ABKRS | Yes |
| S_PERNR | Personnel number | Range / multiple | PA0009-PERNR | No |
| S_SUBTY | Bank details type | Range / multiple | PA0009-SUBTY | No |
| S_AEDTM | Change date | Range / multiple | PA0009-AEDTM | No |
| S_UNAME | Changed by | Range / multiple | PA0009-UNAME | No |
| P_LASTPY | Changes after the last payroll | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Pers. no. | PA0009-PERNR |
| Name | PA0001-ENAME |
| Payroll area | PA0001-ABKRS |
| Bank type | PA0009-SUBTY |
| Valid from | PA0009-BEGDA |
| Changed on | PA0009-AEDTM |
| Changed by | PA0009-UNAME |
| Bank country | PA0009-BANKS |
| Bank key | PA0009-BANKL |
| Account (masked) | Calculated: PA0009-IBAN or BANKN, masked except the last 4 characters |
| Previous bank key | Calculated: From the PCL4 change log (if active) |
| Payroll accounted to | PA0003-ABRDT |
| Check before payment | Calculated: X if PA0009-AEDTM > PA0003-ABRDT |

## How does the report work?

1. For the selected payroll area, the end date of the last closed payroll period is found in T549Q; if a date range is entered on the selection screen, that range is used.
2. Records in PA0009 whose last change date (AEDTM) is after that date are read; bank type (SUBTY: main bank, other banks), bank country and key, and the changing user (UNAME) are taken.
3. If infotype change logging is active, the previous bank key is read from PCL4; it is determined whether this is a new record or a change.
4. The account number or IBAN is masked so that only the last four characters are visible; the full value is not shown in the report.
5. The payroll accounted-to date from PA0003, and name and payroll area from PA0001 are added. If the change was made after the payroll accounted-to date, a "Check before payment" flag is set.

## Authorization objects

- P_ORGIN: Read authorization for personnel data, infotype 0009
- P_PCLX: Access authorization for the PCL4 change log cluster

## Frequently asked questions

### Why is the previous bank detail not always shown?

The previous value is read from PCL4 when change logging is active for infotype 0009. If logging is off, the report shows only the current record and the change date; enabling logging is recommended at installation.

### Why is the account number masked?

The report is for control; having the full account number or IBAN in the list and Excel export spreads personal data unnecessarily. Authorized users can see the full value in PA20.

### Can self-service changes be seen separately?

Yes. The changed-by (UNAME) column shows whether the change came from an employee self-service user or an HR user; the selection screen can filter by these users.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-bank-details-changed-control
