LSMW – Legacy system Migration Workbench
LSMW: stands for Legacy System Migration Workbench
The tool is primarily intended for the one-time or periodic transfer of data from external systems (legacy systems) to an SAP system. Thus, it plays a role in particular when switching from third-party systems to SAP products.
The core functions of the SAP Legacy System Migration Workbench are:
- Importing Data from Non-SAP Systems
- Conversion of data from source format to SAP format.
- Import of converted data (including consistency check)
Although the name refers to the migration of legacy data, SAP LSMW provides additional functions for creating and changing master data, transaction data, and Customizing data. From a technical point of view, the following options are available:
- Batch input: Create (record) and transfer sessions by running transactions.
- Direct input: direct transfer of data to SAP database tables
- BAPI: Data transfer via interface
- IDoc: Data Transfer via Standardized Electronic Messages
The data that can be migrated with the SAP Legacy System Migration Workbench:
LSMW already enables the transfer of numerous master data and transaction data in the standard system. These include G/L accounts, customer master data, supplier master data, material master data and bills of materials. Of course, it is also possible to transfer documents such as orders, purchase orders or posting documents from financial accounting.
Additional data objects can be migrated by recording transactions if the transaction is suitable for the batch input method. This method can also be used for mass deletion of data.
Application of SAP LSMW with Batch Input:
Put simply, the batch input concept simulates the input of data by a human user. To do this, batch input sessions are first created, which contain both the necessary transaction codes (input screens) and the data to be entered. If the data originates from a non-SAP system, it must first be formatted to conform to the SAP input formats.
Select the Batch Input Recording and click on the overview.
The system takes to the Material Master creation screen and records the data what we are entering.
Click on the Default all field the field names will appear automatically.
By Maintaining the Record name in the Recording field click on the save button.
The system Picks the field names automatically by recording while creating Material Master.
Application of SAP LSMW with Direct Input:
In contrast to batch input, no sessions are generated with the direct input procedure. The data is updated directly. This means that no screens are run through. Instead, the data is written directly to the target database tables. If errors occur, a restart function can be used. Direct inputs can only be processed in the background to ensure that this is effective.
Direct input is particularly suitable for very large amounts of data, since it offers considerably better performance than batch input. SAP function modules are also available here for consistency checks.
We have to Manually enter the field names in XL Sheet or Notepad.
The benefits of SAP LSMW are:
- The main advantage lies in the considerable reduction of the time and cost involved in data migrations.
- Additional simplifications are provided by the reusability of data mapping and conversion rules.
- Another positive aspect is that migration can be carried out without programming.
- Special knowledge (e.g., ABAP) is only required if very specific steps are to be mapped. Users are guided intuitively through the migration process by a clear sequence of steps.
- Another advantage is that LSMW ensures a high level of data quality and consistency through import checks. If the procedure is correct, serious damage to the existing SAP database caused by incorrect imports can be almost ruled out.
Process Flow:
Enter the Transaction Code – LSMW in the Command Field
The Initial screen may appear like this Enter the Project name and click on Create Entry.
By Maintaining the data click the Enter or the Check box which shown in the below with the Tickmark.
By Maintaining the data click on the Execute button.
In these some fields are optional and some fields will be automatically assigned.
Select the line Define Object Attributes and Click on the Execute.
It will be always in display mode we have to change to change mode manually by clicking on Display <–> Change tab.
Here I’m creating the Materials by using Batch Input Recording.
Select the Batch input Recording and click on the overview.
Click on Create Recording.
By Maintaining the data click the Enter or the Check box which shown in the below with the Tickmark.
The system asks to enter the Transaction Code. Enter MM01.
The system takes to the Material Master creation screen and records the data what we are entering.
After Maintaining the data click on save the system screen appears like this.
Click on the Default All the system shows the Field names what we maintain in the creation of Material Master.
Click on back button
Click on again the back button.
By Maintaining the Record in the field click on the save button.
Some fields will disappear automatically.
Click on the object overview
Next click on the Tabe,
Here the system shows the fields that we can maintain in the Creation of Material Master.
Select the line Define Source structures and click on Execute
By clicking on the new entry, we can Maintain the source Structure. By Entering the data click on Enter button.
Click on the save button.
Select the line Define Source fields and click on Execute
Select the field and click on the Table Maintenance
Enter the Required data and click on the save button and click on the back button.
The fields are assigned to the Source structure by checking the data click on save.
Select the line Define Structure Relations and click on Execute.
The system automatically assigns the source structure to Recording which is created in the batch input Recording.
Select the line Define Field Mapping and Conversion Rules and click on Execute
Select the field and Goto Extras in the header and click on the Auto field Mapping.
By clicking on the Auto field Mapping the screen will open, don’t change any data and click on enter.
By clicking on Enter another screen will be open
Keep clicking on enter until the system shows the process is done.
By checking the data click on the save button
Select the line Specify Files and click on Execute.
Place the cursor on legacy data and click on Add Entry
Upload the file which maintained in the Notepad
Select the Tabulator if we maintained data in the Notepad
If We maintained data in XL sheet, select comma tab
Tick the checkbox Field Names at Start of file if we maintain the fields data first.
By Maintaining the data click on Enter
The file is successfully uploaded, By checking the data click on save.
Select the line Assign files and click on the Execute
The system automatically assigns the file to the source Structure.
Select line Read Data and Click on Execute button.
The screen will appear like this click on the Execute the system asks to allow or deny the further step. Click on the allow the system picks the data from file that we assigned. In the file we maintain the data for 3 Materials.
Select the line Display Read data and click on Execute button.
Click on the Enter or the Tickmark which is shown below.
Select the line Convert data and click on the Execute button.
The screen will Appears like this click on the Execute button.
Select the line Display Converted Data and click on Execute.
Click the Enter button or Tickmark checkbox which is shown in the below
This is the last step if you want to make any changes to the data. Double click on the line item or select the line item and click on the field contents to see the full details.
Select the line Create Batch Input Section and click on the Execute button.
Select the Keep batch input folder check box and click on Execute.
Under 1 batch 3 transactions are created.
Select the line Run Batch Input Session and click on the Execute button
Select the line item and click on Process the system will open the screen
Proces/Foreground:
If we select this indicator, the process will be done in frond end
Display Errors only:
If we select this indicator, the system directly shows if the data contains any errors.
Background:
If we select this indicator, the whole process will be done in the background.
- Here I am selecting the Process/Foreground indicator I.e., the process will be the front end.
- By selecting the required check box (Extended log and Expert mode) click on the process.
Keep Pressing on Enter
After Completing of creation materials, the system shows the pop-up message that Processing of batch input session completed.
Click on the session overview field which is shown below.
The three transactions are successfully completed.
Now Goto the MM60 to check the materials.