Skip to Content
Technical Articles
Author's profile photo SAMPATH KUMAR G VEERAPPA

Initial stock upload through LSMW

Introduction

LSMW is a tool to convert legacy data to SAP data. Functional consultants also can use the LSMW tool to upload data in the SAP system. Here I am explaining upload initial stock to SAP from legacy data through the Standard batch/direct input method.

Solution

Enter Project, Subproject, and Object names click on create button. Project, Subproject, and Object maximum 10 characters.

After click on create button small popup window opens maintain the project, Subproject, Object descriptions and click on continue.

Click on execute button.

  1 Maintain Object Attributes.

The system automatically selects Maintain objects attributes click on execute.

Note- Every step needs to click on the change button to change data or to add new data.

Select Standard batch/Direct batch radio button. Enter Object and Method as shown in the below picture and save come back.

  2 Maintain Source Structures.

The system automatically selects Maintain source objects click on execute. Click on create. Enter source structure, description and click on continue. Save and come back.

  3 Maintain Source Fields.

The system automatically selects Maintain source fields click on execute.

Keep courser on source structure and click on Table maintenance.

Here enter required fields like the below picture and save come back. Plant and storage location descriptions enter manually.

Save and come back once.

  4 Maintain Structure Relations.

This transaction system automatically selects the next step after the successful completion of the previous step.

Maintain Structure Relations click on execute button.

Go to change mode here source structure automatically assigns to source relations click on save and come back.

  5 Maintain Field Mapping and Conversion Rules.

Maintain Field Mapping and Conversion Rules click on execute.

In Menu, bar go to Extra and Auto field mapping.

Click on continue.

Here we are mapping fields which we maintained in the 3rd step. 4 fields we maintained in the 3rd step below the pop-up window repeats 4 times each time check and click on Accept Proposal.

Click on continue after successfully mapping fields.

Movement type maintains as a constant value. Keep courser on BWART and click on Rule.

Select the constant radio button click on continue.

Enter movement type 561 and click on continue.

Click on save come back.

6 Maintain Fixed Values, Translations, User-Defined Routines.

Skip this step.

7 Specify Files.

Template convert from excel to text delimited format.

Click on execute. Go to change mode keep courser on legacy data and click on Add entry.

Upload now.

Double click on Converted data enters the logical path and Logical file (if not created system creates automatically). Save and come back.

8 Assign Files.

The system assigns automatically, save and come back.

9 Read Data.

Execute this step twice system reads data and shows how many line items I am going to upload. come back twice.

10 Display Read Data.

Execute system shows upload data and can check data by double click on any line item system displays data. come back.

11 Convert Data.

Execute twice system shows number line items I am going to upload 0 Come back twice.

12 Display Converted Data.

Execute this step system shows converted data. We can cross-check data.

13 Create Batch Input Session.

This is the final step. Execute if required increase Max. a number of items and execute again. Keep courser on stock and click on process session.

Select line and click on process.

Select display errors only and click on process.

Video Tutorial- https://youtu.be/BDC-ZuHFnJk

Conclusion

Through LSMW direct input method we uploaded initial stocks. This extremely easy tool to upload legacy data to SAP. For the report we can check MB51 or in SE16N table name is MSEG. LSMW tips and tricks also explained. In the same way, we can also do other movement types. The system takes MB11 tcode by default and posting and document dates also take by default in-process foreground option we can change the date.

 

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nathan Genez
      Nathan Genez

      Why is there another blog on LSMW? This has been covered dozens of times here, on the Wiki, in the forums, AND it's more than adequately covered by the online documentation.

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      I also explained few tips here which is not explained by others and before I publish this blog I checked and I didn't get any source explained about goods movements through direct input method.

      Author's profile photo Marek Kamiński
      Marek Kamiński

      Hi,

      It is very easy to criticize. I think it's a very good blog, even if there are similar blogs already.

      Author of this blog has spent some time preparing it and thank him very much for that . And it is very helpful for beginners, even if it is another such topic. Every new author can contribute something new. If you are the LSMW-Expert, why are you reading this blog? 🙂

      Thank you for a very good blog! Good job!

       

      Author's profile photo Nathan Genez
      Nathan Genez

      But, it's already been blogged about numerous times.  He's chosen to cover a topic that has already been covered, on a solution that hasn't changed since it was released back in 1997 and is not going to exist much longer.  So, why cover it?  Why spend 1,000 words about defining the source structure, read data, convert date, etc.?

      Yes, it's criticism but it's not negative. My advice is to cover a more relevant topic, or cover an unknown feature of it.  That would 1) be more beneficial to the community, and 2) garner more attention for the author.

      Author's profile photo Marek Kamiński
      Marek Kamiński

       

      Actually, you're right, I take it back ;))

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      Thank you lot for your support

      Author's profile photo Shishir Wakankar
      Shishir Wakankar

      I completely agree with Marek that this Blog is really good and appreciate your work - Sampath. Thanks and keep writing.

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      Thank you lot for your support.

      Author's profile photo Nathan Genez
      Nathan Genez

      Then why not create a "Top 5 Tips about LSMW" and skip all of the step-by-step stuff that is on 10,000 websites?  You'd get more attention for it that way.

      I just re-read and the only thing that could possibly be new is the auto field mapping.  You could publish a high quality blog just on that one feature.  As it is, it's totally lost because most people are going to read this as another step-by-step blog.

      Lastly... and this is my own tip... don't ever use a BDC for LSMW. Find a BAPI.  I may be wrong but I'd be surprised if there wasn't a BAPI available for this.

       

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      What I explained step by step easy to understand and it helps to beginners.

      Author's profile photo Nathan Genez
      Nathan Genez

      I agree, but it's also been done dozens of times already.  There's nothing new here.

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      New is the auto field mapping.

      Author's profile photo unisoft functionals
      unisoft functionals

      Informative, appreciate your work.

       

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      Thank you

      Author's profile photo Yash S
      Yash S

      Great Sampath Sir!!

      Please do add additional tips for beginners so that we can learn more. Keep up the great work!!

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      Thank you for your support.

      Author's profile photo Lucia Sguera
      Lucia Sguera

      How this works on more recent systems where MB11 is no longer supported?

      Author's profile photo SAMPATH KUMAR G VEERAPPA
      SAMPATH KUMAR G VEERAPPA
      Blog Post Author

      SAP S4HANA you can use LTMC.