WHAT IS LSMW AND HOW IS IT CUSTOMIZED IN SAP?

In SAP systems, one of the most common tools for data uploads is LSMW (Legacy System Migration Workbench), especially using the Batch Input Recording method.In this blog post, I walk through the step-by-step process of creating a recording, preparing the input files, and highlight key points to watch out for during execution. 

First, navigate to the LSMW screen.

After filling in the Project, Subproject, and Object fields on the opened screen, click the white page icon shown in the screenshot. In the newly opened pop-up window, enter the descriptions for the relevant fields. Then, click the "Execute" button.

In the newly opened screen, click on the "Maintain Object Attributes" option.

In the opened screen, click on the "Recording Overview" button to create a new entry.

On the opened screen, click the "New Entries" button and fill in the necessary information related to the record.

In the second step, the transaction code for which the recording will be created is entered.

The system will automatically navigate to the related transaction code. Enter the required data on the screen that opens.

The relevant fields are filled in completely and the 'Save' button is clicked.

In the newly opened screen, the data to be used is selected, and the 'Default' button is clicked and the 'Save' button is clicked.

A structure (structure file) is created by examining the data here.

After the record is created, the 'Back' button is clicked, and in the opened screen, the 'Batch Input Recording' method is selected, then the created record is selected.

After this, the step of 'Define Structure' is proceeded with.

Here, the structure is defined, and its description is written

In the next step, the field definition for the structure is made

Here, the 'Copy Fields' button is clicked, then in the opened screen, the file you created for the structure is selected, and the 'Save' button is clicked.

In this step, the relationship between the structure and the record is established, then the 'Save' button is clicked.

 The steps shown below are followed, then the 'Auto-Field-Mapping' option is selected. After selecting this option, the process continues automatically by pressing the Enter key in the opened screen

After the mapping is done, it will appear as shown below

After this, the 'Specify Files' step is proceeded with.

In the opened screen, click on the 'Legacy Data' field to make a new entry. The opened screen is filled in as shown below.

Note: The data file here must be filled according to the structure.

It will appear as shown in the final version.

In the next step, it is assigned to the structure data file and saved.

  In this step, SAP reads the data from the file

After the reading process is completed, the screen will appear as shown

In this step, you can view the data read in SAP

If the data is not reflected correctly, you need to check the previous steps and complete any missing parts in those steps

In the next step, the data in the data file is converted to match the data format in SAP

When the data is converted to be compatible with SAP, you will see the following screen

In the next step, you will check the converted data. If the data has been successfully converted, you will see the following screen

In this step, a Batch Input is created for the data to be transferred to SAP

After the Batch Input is created, the final step is taken to transfer the data into the system

In the opened screen, the relevant object is selected, then the 'Process' button is clicked, and the steps shown below are followed

If the process is successfully completed at this stage, a "successful" message will appear as an example in the bottom left corner.

To view the created customers, you can retrieve the most recently created customer numbers from the KNA1 table and display them as shown in the example below.

In this blog post, I have detailed the customizations of LSMW. If you'd like to support, feel free to like and share this post. For more insights about SAP, you can check out my other blog posts published on LinkedIn and S4Pedia.

To stay up to date with my SAP-related updates and posts, feel free to visit and follow my LinkedIn profile.

Yunus Emre Doğan 

SAP SD CONSULTANT