HCM Report Custom development ALV report

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.

TableRoleJoinSystem
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 datePA0003-PERNR = PA0009-PERNRECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Name and payroll areaPA0001-PERNR = PA0009-PERNRECC + S/4
T549QPayroll PeriodsPayroll period start and end datesT549Q-PERMO = T549A-PERMO AND T549A-ABKRS = PA0001-ABKRSECC + S/4
PCL4HR Cluster 4 (PCL4)Infotype change log (if active): previous bank keyPCL4-RELID = 'LA' AND PCL4-SRTFD = PA0009-PERNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_ABKRSPayroll areaRange / multiplePA0001-ABKRSYesTM
S_PERNRPersonnel numberRange / multiplePA0009-PERNRNo00001024
S_SUBTYBank details typeRange / multiplePA0009-SUBTYNo0
S_AEDTMChange dateRange / multiplePA0009-AEDTMNo01.11.2026 – 17.11.2026
S_UNAMEChanged byRange / multiplePA0009-UNAMENoIK_BORDRO2
P_LASTPYChanges after the last payrollCheckbox—NoX

Output columns

#ColumnSource
1Pers. no.PA0009-PERNR
2NamePA0001-ENAME
3Payroll areaPA0001-ABKRS
4Bank typePA0009-SUBTY
5Valid fromPA0009-BEGDA
6Changed onPA0009-AEDTM
7Changed byPA0009-UNAME
8Bank countryPA0009-BANKS
9Bank keyPA0009-BANKL
10Account (masked)Calculated PA0009-IBAN or BANKN, masked except the last 4 characters
11Previous bank keyCalculated From the PCL4 change log (if active)
12Payroll accounted toPA0003-ABRDT
13Check before paymentCalculated X if PA0009-AEDTM > PA0003-ABRDT

Sample output

Pers. no.NamePayroll areaBank typeValid fromChanged onChanged byBank countryBank keyAccount (masked)Previous bank keyPayroll accounted toCheck before payment
00001024Deniz ArıkanTM011/10/202611/10/2026IK_BORDRO2TR00099**** **** 44170006210/31/2026X
00001071Burak TezcanTM011/01/202611/12/2026ESS_USERTR00064**** **** 903210/31/2026X
00001057Selin OkyayTM211/05/202611/05/2026IK_BORDRO1TR00046**** **** 118810/31/2026X
A view built with fictional sample data; not real system data.

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.

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

HCM Package Custom

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, …

4 components · v1.0

Related reports

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: Employee Bank Details Changed Since Last Payroll Report