It is mainly for grouping the objects. One can have multiple subprojects and Object in a Project. These core tutorials will help you to learn the fundamentals of sap mm. For an in-depth understanding and practical experience, explore sap mm online Training. Define the method of upload. Go inside this step and choose the radio button for the options.
|Published (Last):||24 March 2016|
|PDF File Size:||20.40 Mb|
|ePub File Size:||9.41 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. 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. Copy 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. Go to Sheet2.
Keep the cursor in the Sheet 2 A1 and then. Paste Special. 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. Remove all grids. No colors should be there in the sheet. No letter should be typed in different colors. All are in normal color only. Now say OK. Now copy the whole Sheet2 and paste it in the Sheet3.
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 step 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 also appear here.
Meaning that in case these fields does not map with your changed fields in your Structure, uploading 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. 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. Though it is a customary step, you need to visit this step compulsory.
Say Ok. 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. One Batch input session will be created. Say OK. Click Right , which 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.
Check in:. Extended log. Expert Mode. Dynpro Standard Size. 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!!!
Thanks Marianna Bilan. Please rerecord and execute in the foreground in the last step. 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!
LSMW for Functional Consultants in simple step-by-step way
This can be a one-time transfer as well as a periodic one. LSMW also supports conversion of data of the legacy system in a numerous way. Furthermore, the LSM Workbench provides a recording function that allows generating a "data migration object" to enable migration from any required transaction. If you want to transfer data from several legacy systems, you may create a project e. Subproject : An ID with a maximum of 10 characters that is used as a further structuring attribute.
Learn SAP LSMW
Steps to simple LSMW using Record Method In Sap MM
What is LSMW in SAP – Overview of SAP LSMW WorkBench