HCM Program Custom development Mass upload

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

  • PA30 Maintain HR Master Data. Changes basic pay employee by employee; no bulk upload and no increase check.
  • PA70 Fast Entry. Offers fast entry; does not calculate an increase percentage or compare old and new pay.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
PA0008HR Master Record: Infotype 0008 (Basic Pay)Basic pay: the old record is delimited, the new record is createdWriteECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Organizational assignment and personnel area checkReadECC + S/4
T511Wage TypesWage type allowed for the country groupingReadECC + S/4
T510Pay Scale GroupsPay scale group and level checkReadECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_FILERaise file (XLSX or CSV)Single value—YesC:\temp\zam_2027_01.xlsx
P_MINPCTMinimum increase percentageSingle value—No0
P_MAXPCTMaximum increase percentage (above is held for approval)Single value—No60
P_ROUNDRounding unitSingle value—No10
P_TESTTest mode (check without saving)Checkbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Personnel no.PA0008-PERNRYes
2Valid fromPA0008-BEGDAYes
3Change reasonPA0008-PREASYes
4Pay scale groupPA0008-TRFGRNo
5Pay scale levelPA0008-TRFSTNo
6Wage typePA0008-LGA01Yes
7New amountPA0008-BET01No
8Increase %By rule Used when new amount is blank: new amount = old PA0008-BET01 × (1 + percentage ÷ 100)No
9CurrencyPA0008-WAERSNo

Sample upload file

1Personnel no. *Valid from *Change reason *Pay scale groupPay scale levelWage type *New amountIncrease %Currency
20001204501.01.202701100078,500TRY
30001231101.01.202701100032.50TRY
40001310701.01.202702C203100018TRY
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2Personnel no.PA0008-PERNR
3NamePA0001-ENAME
4Valid fromPA0008-BEGDA
5Old amountCalculated PA0008-BET01 valid before the increase date
6New amountPA0008-BET01
7Increase %Calculated (New amount − old amount) ÷ old amount × 100
8StatusCalculated Saved, held for approval or error
9MessageCalculated Limit check result or return message from HR_INFOTYPE_OPERATION

Sample result list

RowPersonnel no.NameValid fromOld amountNew amountIncrease %StatusMessage
200012045Selin Karamanlı01/01/202761,20078,50028.30SavedInfotype 0008 record created
300012311Burak Tekinalp01/01/202754,00071,55032.50SavedInfotype 0008 record created
400013107Derya Ulukaya01/01/202748,300ErrorNo valid T510 amount for pay scale group C2 level 03
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. 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.
  3. 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.
  4. When the increase percentage is outside the minimum and maximum limits on the selection screen, the row is held for approval and not written.
  5. 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.
  6. 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

HCM Package Custom

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 …

3 components · v1.0

Related reports

HCM Program Custom Mass upload

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 …

PA0015 · PA0001 · PA0003 · T512Z

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.

Related report: Mass Salary Increase Upload Program (Basic Pay, Infotype 0008)