Mass Salary Increase Upload Program (Basic Pay, Infotype 0008)
Short answer: A custom upload program that loads periodic salary increases from an Excel file into infotype 0008 in bulk, accepts either a new amount or an increase percentage, compares old and new pay and stops increases outside limits. The existing record is delimited one day before the increase date and the new record is created with a change reason.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PA30 changes basic pay one employee at a time; PA70 fast entry has a limited field layout, does not calculate an increase percentage and does not compare old and new pay. The standard pay scale increase changes pay scale amounts but does not apply to individual (non-scale) pay. For individual raises done once or twice a year, keying hundreds of records takes time and carries an error risk.
Who uses it? Compensation and benefits specialists, payroll teams and HR operations managers.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| PA0008HR Master Record: Infotype 0008 (Basic Pay) | Basic pay: the old record is delimited, the new record is created | Write | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Organizational assignment and personnel area check | Read | ECC + S/4 |
| T511Wage Types | Wage type allowed for the country grouping | Read | ECC + S/4 |
| T510Pay Scale Groups | Pay scale group and level check | Read | ECC + S/4 |
BAPIs and functions used
- BAPI_EMPLOYEE_ENQUEUELock Employee. Locks the personnel number before the update
- HR_INFOTYPE_OPERATIONMaintain HR Infotype Record. Creates the new infotype 0008 record
- BAPI_EMPLOYEE_DEQUEUEUnlock Employee. Releases the personnel number lock
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Raise file (XLSX or CSV) | Single value | — | Yes | C:\temp\zam_2027_01.xlsx |
| P_MINPCT | Minimum increase percentage | Single value | — | No | 0 |
| P_MAXPCT | Maximum increase percentage (above is held for approval) | Single value | — | No | 60 |
| P_ROUND | Rounding unit | Single value | — | No | 10 |
| P_TEST | Test mode (check without saving) | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Personnel no. | PA0008-PERNR | Yes |
| 2 | Valid from | PA0008-BEGDA | Yes |
| 3 | Change reason | PA0008-PREAS | Yes |
| 4 | Pay scale group | PA0008-TRFGR | No |
| 5 | Pay scale level | PA0008-TRFST | No |
| 6 | Wage type | PA0008-LGA01 | Yes |
| 7 | New amount | PA0008-BET01 | No |
| 8 | Increase % | By rule Used when new amount is blank: new amount = old PA0008-BET01 × (1 + percentage ÷ 100) | No |
| 9 | Currency | PA0008-WAERS | No |
Sample upload file
| 1 | Personnel no. * | Valid from * | Change reason * | Pay scale group | Pay scale level | Wage type * | New amount | Increase % | Currency |
|---|---|---|---|---|---|---|---|---|---|
| 2 | 00012045 | 01.01.2027 | 01 | 1000 | 78,500 | TRY | |||
| 3 | 00012311 | 01.01.2027 | 01 | 1000 | 32.50 | TRY | |||
| 4 | 00013107 | 01.01.2027 | 02 | C2 | 03 | 1000 | 18 | TRY |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Personnel no. | PA0008-PERNR |
| 3 | Name | PA0001-ENAME |
| 4 | Valid from | PA0008-BEGDA |
| 5 | Old amount | Calculated PA0008-BET01 valid before the increase date |
| 6 | New amount | PA0008-BET01 |
| 7 | Increase % | Calculated (New amount − old amount) ÷ old amount × 100 |
| 8 | Status | Calculated Saved, held for approval or error |
| 9 | Message | Calculated Limit check result or return message from HR_INFOTYPE_OPERATION |
Sample result list
| Row | Personnel no. | Name | Valid from | Old amount | New amount | Increase % | Status | Message |
|---|---|---|---|---|---|---|---|---|
| 2 | 00012045 | Selin Karamanlı | 01/01/2027 | 61,200 | 78,500 | 28.30 | Saved | Infotype 0008 record created |
| 3 | 00012311 | Burak Tekinalp | 01/01/2027 | 54,000 | 71,550 | 32.50 | Saved | Infotype 0008 record created |
| 4 | 00013107 | Derya Ulukaya | 01/01/2027 | 48,300 | Error | No valid T510 amount for pay scale group C2 level 03 |
How does the program work?
- The file (XLSX or CSV) is read; each row is expected to hold personnel number, start date, change reason, wage type and either a new amount or an increase percentage.
- The employee’s organizational assignment on the key date is read from PA0001 and the current basic pay record from PA0008; T511 is checked to confirm the wage type is allowed for the country grouping.
- When a percentage is given, new amount = old amount × (1 + percentage ÷ 100), rounded as selected. For pay scale employees the new pay scale group and level are checked in T510.
- When the increase percentage is outside the minimum and maximum limits on the selection screen, the row is held for approval and not written.
- The employee is locked with BAPI_EMPLOYEE_ENQUEUE; the new 0008 record is created with HR_INFOTYPE_OPERATION and the previous record is delimited automatically by the time constraint; then the lock is released with BAPI_EMPLOYEE_DEQUEUE.
- In test mode nothing is saved; old and new amount, percentage and check results are listed. Failed rows can be downloaded as a separate file.
Performance notes
Read PA0001 and PA0008 for all personnel numbers in the file in one query; call HR_INFOTYPE_OPERATION per row and always release the lock. A raise file with a few thousand rows is processed in minutes in the background.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- Download failed lines as a separate file Failed and held rows are downloaded as a separate file.
- Export to Excel An empty raise template can be downloaded as Excel.
- Runs as a background job
Authorization objects
- P_ORGINWrite authorization for infotype 0008 (personnel area, employee group)
- P_PERNRPrevents users from changing their own personnel record
Frequently asked questions
Can a retroactive raise be uploaded?
Yes. The start date can be in the past; payroll recalculates back to the earliest retroactive date in the control record. The program stops dates before this limit with a warning.
Can several wage types (e.g. basic pay and a fixed allowance) be increased at once?
Yes. A column pair per wage type is added to the file; the program updates the matching wage type lines in the 0008 record and carries the others over unchanged.
Is the pay data in the raise file safe?
The program reads the file only during the run and does not store its content. In the log, amounts are shown only to users with write authorization for infotype 0008.
Packages that include this solution
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 …
Related reports
Mass Additional Payment (Infotype 0015) Upload Program
A custom program that posts bonuses, sales commissions, premiums and similar one-time payments from an Excel or CSV file to infotype 0015 in bulk. It …
Payroll Wage Type Period Comparison and Variance Report
A custom ALV report that compares the payroll results of one period with the previous period per employee and wage type, and lists variances above a …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.