SAP LSMW (Legacy System Migration Workbench) Recording method full guide

[Senthilkumar3]

                                    LSMW (Legacy System Migration Workbench)

Function of LSMW

LSMW is essential for data migration and data updating. It's responsible for the automatic processing of transactional data and Master Data creation.

LSMW provides four different methods for upload:

• Direct input method
• Batch input recording
• BAPI
• IDOC 

This document helps us to learn about Batch input recording method.

In the SAP home screen type LSMW , then press enter to move next screen

Click on the Create Entry button

1. Enter Project / Subproject / Object details,
2. Then click on the continue button

Click on the Execute button (Shortcut F8)

Select the line item and click on execute button (F8)

Individual steps will open display mode, manually switch to change mode

1. Select on Batch Input Recording
2. Select on Recordings overview

Click on the Create on button

1. Enter the Recording name and Description
2. Click on the Continue button

1. Enter the Transaction code, which is you want to record
2. Click on the Continue button

1. Enter the required inputs to create the transaction
2. Click on the save button

Click on the Default All button, to get the field name

1. Click on the Save button
2. Click on the Back button

Click on the back button

1. Click on F4 button to get recent record name.
2. Click on the save button.
3. Click on the back button

The system automatically highlighted the next steps

Click on the object overview

Choose Table

Select from the 3rd row and copy the data

Open the Excel sheet and paste the data into sheet 1

Paste the same data in sheet 2, and delete the description column. Then change CHAR to C

Copy the data from sheet 1 and paste to sheet 3 in Transpose mode, then enter data

Copy data from row number 1 and 5 and paste into sheet 4, then Align left

Open the Text document, copy the data from sheet 4, and paste it into text format.

Keep ready the text file to upload.

Select step 2 and click on execute

Click on change mode

1. Click on the create button
2. Enter source structure and Description
3. Click on the continue button

Click on the save button

Select step 3, then click on the execute button

Click on the Change mode

1. Keep the cursor on the source name
2. Click on the table maintenance button

Copy the data from Excel file sheet 2, paste and press enter

Click on the Save button, then click on the back button

1. Click on the Save button
2. Click on the back button

1. Select step 4
2. Click on execute button

Click on change mode

1. Click on the save button
2. Click on the back button

1. Select step 5
2. Click on the execute button

Click on change mode

1. Keep the cursor on Fields
2. Select the Extras option
3. Select the Auto Field mapping option

Click on the continue button.

Click on Accept Proposal until auto field mapping complete

Click on the continue button

1. Click on the save button
2. Click on the back button

1. Select step 6 (Auto select by system)
2. Click on the execute button

No action this step, so click on the back button

1. Select step 7
2. Click on the execute button

Click on change mode

1. Keep the cursor on Legacy data
2. Click on the create button

1. Choose the file local desk and enter name for file
2. Select the Tabulator option (Our text file space in Tabulator mode)
3. Choose File Names at start of file (Our file Field name is first row)

1. Click on the save button
2. Click on the back button

1. Select step 8
2. Click on the execute button

Click on change mode

1. Click on the save button
2. Click on the back button

1. Select step 9
2. Click on the execute button

Click on the execute button (F8)

Click on the Allow button

We can see the number records loaded, then click on the back button

1. Select step 10.
2. Click on the execute button (F8)

Click on the continue button

Click on the back down

1. Select step 11
2. Click on the execute button

Click on the execute button (F8)

Click on the back button (F3)

1. Select step 12
2. Click on the execute button (F8)

Click on the continue button

Click on the back button (F3)

1. Select step 13
2. Click on the execute button

1. Enable Keep batch input folder check box
2. Click on the execute button

Click on the continue button

1. Select step 14
2. Click on the execute button (F8)

1. Select the line item
2. Click on the process option
3. Choose the Display errors only option (If loaded bulk data, choose background option)
4. Enable check as per shown
5. Click on process button

If data was loaded successfully, this message will be displayed.

Click on the session overview button

You can see the result to loaded vs Successful

If you load further more new data’s keep the file ready in text format and execute the transaction form step 7 in same project.                        

Thanks

Senthilkumar T