Employee Bank Details Changed Since Last Payroll Report
Short answer: 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.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Payroll specialists, internal control and internal audit teams.
Closest standard alternatives
- S_AHR_61016380 Logged Changes in Infotype Data. Lists changes of all infotypes in a generic format; does not isolate bank details against the last payroll date.
- PC00_M99_CDTA Bank Transfer Preliminary Program (DME, International). Creates the payment file; does no pre-check for recently changed bank details.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PA0009HR Master Record: Infotype 0009 (Bank Details) | Bank details: bank type, country, key, change date and user (driving table) | — | ECC + S/4 |
| PA0003HR Master Record: Infotype 0003 (Payroll Status) | Payroll status: payroll accounted-to date | PA0003-PERNR = PA0009-PERNR | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Name and payroll area | PA0001-PERNR = PA0009-PERNR | ECC + S/4 |
| T549QPayroll Periods | Payroll period start and end dates | T549Q-PERMO = T549A-PERMO AND T549A-ABKRS = PA0001-ABKRS | ECC + S/4 |
| PCL4HR Cluster 4 (PCL4) | Infotype change log (if active): previous bank key | PCL4-RELID = 'LA' AND PCL4-SRTFD = PA0009-PERNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_ABKRS | Payroll area | Range / multiple | PA0001-ABKRS | Yes | TM |
| S_PERNR | Personnel number | Range / multiple | PA0009-PERNR | No | 00001024 |
| S_SUBTY | Bank details type | Range / multiple | PA0009-SUBTY | No | 0 |
| S_AEDTM | Change date | Range / multiple | PA0009-AEDTM | No | 01.11.2026 – 17.11.2026 |
| S_UNAME | Changed by | Range / multiple | PA0009-UNAME | No | IK_BORDRO2 |
| P_LASTPY | Changes after the last payroll | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Pers. no. | PA0009-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Payroll area | PA0001-ABKRS |
| 4 | Bank type | PA0009-SUBTY |
| 5 | Valid from | PA0009-BEGDA |
| 6 | Changed on | PA0009-AEDTM |
| 7 | Changed by | PA0009-UNAME |
| 8 | Bank country | PA0009-BANKS |
| 9 | Bank key | PA0009-BANKL |
| 10 | Account (masked) | Calculated PA0009-IBAN or BANKN, masked except the last 4 characters |
| 11 | Previous bank key | Calculated From the PCL4 change log (if active) |
| 12 | Payroll accounted to | PA0003-ABRDT |
| 13 | Check before payment | Calculated X if PA0009-AEDTM > PA0003-ABRDT |
Sample output
| Pers. no. | Name | Payroll area | Bank type | Valid from | Changed on | Changed by | Bank country | Bank key | Account (masked) | Previous bank key | Payroll accounted to | Check before payment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001024 | Deniz Arıkan | TM | 0 | 11/10/2026 | 11/10/2026 | IK_BORDRO2 | TR | 00099 | **** **** 4417 | 00062 | 10/31/2026 | X |
| 00001071 | Burak Tezcan | TM | 0 | 11/01/2026 | 11/12/2026 | ESS_USER | TR | 00064 | **** **** 9032 | 10/31/2026 | X | |
| 00001057 | Selin Okyay | TM | 2 | 11/05/2026 | 11/05/2026 | IK_BORDRO1 | TR | 00046 | **** **** 1188 | 10/31/2026 | X |
How does the report work?
- 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.
- 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.
- 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.
- 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.
- 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.
Performance notes
Read PA0009 with the change date (AEDTM) range; the number of changed records is usually small. Read the PCL4 log only for the employees found. Schedule the report as a background job in the payroll calendar before the payment program.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the personnel number displays infotype 0009 in PA20.
- Runs as a background job
- Send the result by email Can be sent to the payroll owner and internal control before the payment program.
Authorization objects
- P_ORGINRead authorization for personnel data, infotype 0009
- P_PCLXAccess 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.
Packages that include this solution
Pre-Payroll Check and Upload Pack
A pack that brings together the work done before every payroll run: bulk upload of additional payments and absence and attendance records from Excel, …
Related reports
Employees Missing Cost Center or Organizational Assignment Report
A custom ALV check report that finds, before payroll runs, active employees with an empty or invalid cost center, assignments left on the default …
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.