Technical Articles
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.
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.
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.
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!
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.
Actually, you're right, I take it back ;))
Thank you lot for your support
I completely agree with Marek that this Blog is really good and appreciate your work - Sampath. Thanks and keep writing.
Thank you lot for your support.
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.
What I explained step by step easy to understand and it helps to beginners.
I agree, but it's also been done dozens of times already. There's nothing new here.
New is the auto field mapping.
Informative, appreciate your work.
Thank you
Great Sampath Sir!!
Please do add additional tips for beginners so that we can learn more. Keep up the great work!!
Thank you for your support.
How this works on more recent systems where MB11 is no longer supported?
SAP S4HANA you can use LTMC.