Purpose
This document will briefly discuss LSMW for uploading Bill of Material using Direct Input Method.
Prepare LSMW
Project : As name describes, I mention the name of the project.
Subproject : I usually maintain the module for which we are preparing.
Object : It is the business object, in this case I mention as BOM
Here I mention LSMW as
One advantage of this kind of naming is, we can see all objects created under one project – under one subproject.
Procedure
Step 1 : Maintain Object Attributes
Step 2 : Maintain Source Structures
Create two structures, second structure as lower level.
Step 3 : Maintain Source Fields
Here we maintain two structures – one for header level data and second one for item data. Header Material number (MATNR) is the common field connecting these two structures.
Step 4 : Maintain Structure Relations
Step 5 : Maintain Field Mapping and Conversion Rules
Maintain fields for both the two structures.
Step 6 : Prepare Excel File.
Prepare both header and item file separately.
Step 7 : Specify Files
Item file should be created under the Header file.
Logical File path must be created in transaction FILE.
Step 8: Assign Files
Step 9 : Read Data
Step 10 : Display Read Data
Step 11 : Convert Data
Step 12 : Display Converted Data
Step 13 : Create Batch Input Session
Click Display Errors Only
Following screen appears .
Now the BOM is created for material.
*&———————————————————————————————————————————————————————————–&*
Bookmarked 😏 😘 Thanks for sharing π
Good Work Dany!! π
Good….Thank You….
Fantastic work Danny !! Thanks for your knowledge sharing.
Thank you π for you appreciation.
Great, thx. it´s a help, sure.
Really i like this.This is good for beginner.
Thanks for sharing.
Regards,
Viswanathan S
nice document thnks for sharing
Thanks & Regards
Sandeep Kumar Praharaj
Thanks Sandeep
Great Job π
Thanks for sharing π
Thank You Ajmeri
Good document Danny.
Regards,
Nilesh Mohite.
Hi, π
Good Document thanks for sharing
Hi,
Good d π cument. thanks a lot for sharing
Thank you Nagendra
Good Job Danny it is very useful π
Thank you Mahesh.
Hi Danny John,
Good article… Thanks for sharing…very helpful.
Regards,
Rajesh
Thanks Rajesh.
Nice document John…
Can we do the same through recording method?If possuble please share..
Regards
Debraj
Good Document.
Thanks for sharing
Thank you Danny, this document was an outstanding assistance in my accomplishment of bom migration π .
Glad that document was useful for you. π
can you help me why I alway dump during converting data
Can u check in Read data whether you are able to see your data correctly in each field.
Good day,
I do not see a MATNR field in the BICSP Structure; how did you add the MATNR field to the Item Structure?
Regards,
Chris
Sorry Chris for the very late response
You can find IDNRK field for the BOM component.
Regards,
Danny
This is indeed of great help.
Just a clarification, i tried creating Logical path in transaction FILEΒ as per naming convention proposed automatically but without any luck. There is still error “No logical path has been specified”. Would appreciate any input on this.
Example:
Logical file path:
CS01_1_CS01_1_CS01_1.LSMW.CONV
CS01_1_CS01_1_CS01_1.LSMW.READ
What should be syntax grp for these?
Logical filename definition:
CS01_1_CS01_1_CS01_1.LSMW.CONV
CS01_1_CS01_1_CS01_1.LSMW.READ
Cheers
The issue is resolved.
Cheers
Dear Sir,
Very nicely explained.
Thanks a lot.
HI,
This is very good but i am receiving error “E29 811 Transaction not supported”. could you please help in what step exactly change is needed.