LSMW Tools LSMW stands for legacy system migration workbench and it is a special form of data migration that is used in SAP, to transfer data from legacy. LSMW is a tool used to tranfer data from legacy system to R/3 periodically or supports conversion of data and Batch Input,BAPI,IDOC or. SAP Practice Manager, Quality Systems & Software () This document contains Step-by-step instructions to use LSMW to update Customer.
|Published (Last):||28 May 2005|
|PDF File Size:||17.63 Mb|
|ePub File Size:||16.47 Mb|
|Price:||Free* [*Free Regsitration Required]|
However, at times, it would be responsibility of the functional consultant to load the data such as vendor master, customer master and asset master etc. It would be real handy for a functional consultant to know LSMW at least recording method and it would help them to successfully complete the task.
Hope this document would help many of our functional consultants, as I am seeing number of questions around LSMW. The simple rule is: Follow this document and practice is for number of times possible, then you will become master. Give some Unique name for Project, Subproject and Object. Recording is saved now.
With this, you can drag and copy whatever you want.
SAP LSMW Tools Steps | Migrate data using LSMW
In case if any field is appearing twice you need to change the field name by double clicking on that. Otherwise, your uploading will get failed. Fjco the fileds to an excel file. Remove the Blank Rows. Now the field name and descriptions are in one Column.
You need to segregate that. Now all fields and texts are divided into two Columns. Keep the cursor in the Sheet 2 A1 and then. Check in Transpose as shown below and say OK. Now all your rows will become your columns as shown in the blow Screen. Now fill the required details exactly as shown below. Now select the whole sheet2.
No colors should be there in the sheet. No letter should be typed in different colors. All are in normal color only. Now copy the whole Sheet2 and paste it in the Eteps. Then delete the header rows as shown below: Save this file to your Hard Disk with a simple name. In this case I saved as Vendor. Save as Text Tab Delimited as shown in the above screen shot.
Press F3 or Click on Back Button. Again, press F3 or click on back Button. Click F4 in the Recording Button, your structure will be populated. Now you will observe that few steps have been disappeared. Only few steps are left out. This is because of the recording mode that you have been selected.
Ideally there should not be any Idoc related steps should be visible. Now Step1 is being completed and the system automatically takes you to second step. Now Press F3 or Click back button to go back.
Now the second cico is completed and system automatically takes you to third step. Now press on Table Maintenance as shown above by keeping your cursor on the Source Structure in blue color in the above screen shot.
Copy those Fields from Sheet1 and copy it here. In case if your fields are came twice in recording, none of the field should be similar. As already advised that change the field names to different field names. Whatever, field names that you have changed in the structure should fcio appear here. Meaning that in lwmw these fields does not map with your changed fields in your Structure, sa; will fail.
If you know the length enter the exact length. If you do not enter the maximum length You should not enter the length less than the actual length of the field.
Save the results and Press F3 or Click on back button to go back. Now Click Save in this screen and again press F3 to go back.
SAP LSMW Tools Steps | Migrate data using LSMW – SAP Training Tutorials
Now system will automatically takes you to fourth screen. Though it is customary step, you should go to this step. And say OK for the message that the system has issued. Now press Save and PressF3 or Click on back button to go back. It will take you to the next screen automatically.
Again Select the Structure. Go select the auto filed mapping as showing above in the above screen shot. Do not make any changes. Your entire field mapping should appear as above. Each field should have four rows as above. Now the system will take you to next step i.
Step it is a customary step, you lssmw to visit fifo step compulsory. The system will take you to next step i. Remove the Checks for. There should not be any check in the above two check boxes. Now Click on Execute F8. The system will tell that total 8 records are being read.
Here you give the number of lines in your text file and say OK. Just press F8 or Execute Button. The following screen will appear. See the screen and press Back Button F3 twice, which will take you to initial screen. Enter the number of lines From 1 to 8 in this case, to see how it is showing in Converted Data and Say Ok. Click on Rite Tick. Click on any one of the converted data line and see how the data is going. Just Click on Execute Button F8.
Saap Batch input session will be created. Click Rightwhich will take you to initial screen. Now you are in SM35 Screen. Select the line that is being created to upload and press Execute F8 button as shown above.
See the log and click on Line, if there are any problems in your log. Now You are Viewing the vendor records that you are uploaded. You can also follow the same steps for Change also. Please let me know if you have any doubts. Three years passed since publication, but this document is still valid and helpful. Everything works, thank you, Ravi, very much!!! Please zteps and execute in the foreground in the last stels. As said, recording is the wrong approach for material master.
Very helpful thank you Ravi Sankar Venna. I managed to successfully complete an LSMW but in a trial and error way. I really need you help!
Thank you in advance. T hank you for answering. Just start from the step load your file. Document is very helpful for being a Functional consultant because I have upload number of Master data in my current project without any coding. How can I view the records I have uploaded? I am a newbie in SAP. This manual served me to upload costcenters massively and it worked! Unfortunately you made the mistake that was only discovered in the last step already in the first step.
Personal defaults like view selection is no recorded, as a usual scenario would be that a developer creates the recording BDC and a user executes it, and it cannot be stepd that any user has the same personal ls,w. Further is a recording for a full blown material master in most cases insufficient as different material types have different views, and fields in the view depend on other lamw values.