LSMW in SAP- 13 STEPS

LSMW - Helpful hints for Support PM for transaction updates using the recording option.

TCODE: LSMW

Here you have to first Define Project, Sub Project, and Object. It is mainly for grouping the objects. One can have multiple subprojects and Objects in a Project.

LSMW

Execute the transaction and you will get navigated to the second screen: LSMW Work Bench. Here one can choose the required steps by pressing the ‘User Menu’ button.

LSMW

These core tutorials will help you to learn the fundamentals of sap mm. For an in-depth understanding and practical experience, explore SAP MM Training

The following 13 steps are sufficient for the Support person for the LSMW update.

LSMW

Step 1: Maintain Object Attributes

Define the method of upload. i.e. batch recording, direct update, BAPI, etc. Go inside this step and choose the radio button for the options. This document explains only about the transaction recording method.

Object Attributes in LSMW

One can toggle between the Display or change option using the standard button. Select the object type and Import method as ‘Batch Input Recording’. Once you have selected this click on the overview button so that you can go to the recoding overview

Object Attributes of LSMW

Example of a recording

Object Attributes Of LSMW

After recording default those fields that you want to update /use in the batch update.

Step 2: Maintain Source Structures

Give any name, which can be easily identifying the input data structure. (It is equivalent to defining an internal table in an ABAP program). Can define multiple structures also (if required).

Source Structures of LSMW

Step 3: Maintain Source Fields

Define all those fields that you are giving in the input file here. The order should match the order of fields in the file. Otherwise, it will get updated into the wrong fields. (Most of the errors might be in this step)

Step 4: Maintain Structure Relations

Define the source and destination structure relationships.

Structure Relations of LSMW

SAP MM Tutorial

 

Step 5: Maintain Field Mapping and Conversion Rules.

You have to define the mapping rules.., eg. Customer = customer. Or if any default value has to be passed, or some fixed value is given like that ( company code can be a default value if processing for a particular company code.

Field Mapping and Conversion Rules of LSMW

After making all the mappings and initialization you can even do a syntax check to see your mappings are correct or not

Step 6: Specify Files

Files of LSMW

You have to specify the input file location in this step.

Step 7: Assign Files

Assign the physical file path to the structure

FIles Of LSMW

Step 8: Read Data

Reading the file to the source structure

Data LSMV

Step 9: Display Read Data

This is a very useful step where we can review the field values that got read.

Reading Data LSMW

Step 10: Convert Data

Converting the source structure data to the destination by applying the conversion rules that have mentioned in step 4 and step 5.

Convert Data LSMW

Step 11: Display Converted Data

Convert Data LSMW

Also useful for checking the values converted.

Step 12: Create Batch Input Session

This will create a BI session in SM35.

Batch Input Session LSMW

Step 13: Run Batch Input Session

This step will call SM35. One can run the session in SM35. You can run in the foreground, Error mode, or background. Preferably run in Foreground for testing some few records…once confirmed the update then run in the background.

How to transport the LSMW project from Test to Production system;

The LSMW projects can be transported between systems via the export /import method. You can export the entire project as a text file and that can be imported to another system.

Run Batch Session LSMW

In MSS no changes are allowed, so before importing to MSS, give the MSS file path in MST and then do an export.