LSMW – SAP HR
How to upload bulk data in SAP HR System
Shaumya Koner (shaumya.koner@accenture.com)
9/29/2016
Page 1 of 25
LSMW – SAP HR
Table of Content
I. Summary…………………………………………………………………………………………………………3
II. Scenario………………………………………………………………………………………………………....3
III. Steps……………………………………………………………………………………………………………….3
Publication Record:
Business Version Date Author Description
1.0 29-September- Shaumya Koner Initial Draft
2016
Page 2 of 25 Internal Use Only
LSMW – SAP HR
1. Summary
Sometimes there is a requirement from the business to upload the mass data in SAP system, this
activity can be done thru the Legacy System Migration Workbench (LSMW), it is a handy tool for
data uploads.
It would be real handy for a functional consultant to know LSMW and it would help them to
successfully complete the task. Hope this document would help.
2. Scenario
Business has asked to update the Date of birth for 100 employees in IT 0002
3. Steps
Go to Transaction Code "LSMW" and follow the following steps:
Click on Create button and give the name of the Project, Subproject and Object
Page 3 of 25 Internal Use Only
LSMW – SAP HR
Give the name of the Project, Subproject and Object and click on continue
Click on Execute
Page 4 of 25 Internal Use Only
LSMW – SAP HR
Select Maintain Object Attributes and click on Execute
Click on Display <-> Change, select Batch Input Recording and Click on Overview
Page 5 of 25 Internal Use Only
LSMW – SAP HR
Click on Create in the popup window give Recording name and Description and click on
Continue
Enter the Transaction Code and click on Continue
Page 6 of 25 Internal Use Only
LSMW – SAP HR
In this example we are updating the Date of Birth of the employees. Enter the Personnel
no. select info type 0002 and click on change
Update the Date of Birth and Click On Save (Ctrl + S)
Page 7 of 25 Internal Use Only
LSMW – SAP HR
We will get the recording. Click on Default All and Click On Save (Ctrl + S)
We have created the recording. Copy the Recording name
Page 8 of 25 Internal Use Only
LSMW – SAP HR
Paste the Recoding name in Batch Input Recording as highlighted below Save the click
on Back.
Page 9 of 25 Internal Use Only
LSMW – SAP HR
Selection will automatically move to the next Process Step - Maintain Source Structure.
Click on Execute
Place the cursor on Source Structures and Click on Display<->Change
Click on New and Provide the Source Structure and Description
Page 10 of 25 Internal Use Only
LSMW – SAP HR
Click on Save and Back
Next Process Step - Maintain Source Fields click on Execute
Click on Display <-> Change
Page 11 of 25 Internal Use Only
LSMW – SAP HR
Provide the field name that you want to upload thru LSMW
Provide the Second field and so on that needs to upload
Page 12 of 25 Internal Use Only
LSMW – SAP HR
Click on Save and Back
Next Process Step - Maintain Structure Relations click on Execute
Click on Display <-> Change
Page 13 of 25 Internal Use Only
LSMW – SAP HR
Click on Save and Back
Next Process Step Maintain Field Mapping and Conversion Rules click on Execute
Click on Display <-> Change
Page 14 of 25 Internal Use Only
LSMW – SAP HR
Click on Extras and select Auto-Field Mapping
Click on Continue in the Popup window
The mapping is done Click on Save and Back
Page 15 of 25 Internal Use Only
LSMW – SAP HR
Select Process Step - Specify Files and click on Execute
Click on Display <-> Change
Page 16 of 25 Internal Use Only
LSMW – SAP HR
Double Click on Legacy Data select the path of the file that we need to upload (follow the
sequence as highlighted in the below screenshot)
Once you give the file path Click on Save and Back
Page 17 of 25 Internal Use Only
LSMW – SAP HR
Next Process Step Assign files. Click On Execute
Click On Display <-> Change
Click On Save and then Back
Page 18 of 25 Internal Use Only
LSMW – SAP HR
Process Step – Read Data click on Execute
Click On Execute
Check the number of records and Click On Back
Page 19 of 25 Internal Use Only
LSMW – SAP HR
Click On Back
Process Step - Display Read Data click on Execute
Click on Continue
Page 20 of 25 Internal Use Only
LSMW – SAP HR
Click on Back
Process Step – Covert Data click on Execute
Click on Execute
Page 21 of 25 Internal Use Only
LSMW – SAP HR
See the number of records read count and Click on Back
Click on Back
Process Step – Display Converted Data. Click on Execute
Page 22 of 25 Internal Use Only
LSMW – SAP HR
Click on Continue
Click on Back
Process Step - Create batch Input Session. Click on Execute
Page 23 of 25 Internal Use Only
LSMW – SAP HR
Click on Execute, tick the check box ‘Keep batch input folder’
Click on Continue
Process Step- Run Batch Input Session. Click on Execute
Page 24 of 25 Internal Use Only
LSMW – SAP HR
Select the file Click on Process select Background and Click on Process
Once the background job is completed the Status will be Processed
Page 25 of 25 Internal Use Only
