Skip to Content
Author's profile photo Former Member

LSMW for uploading BOM

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

L0.JPG

One advantage of this kind of naming is, we can see all objects created under one project – under one subproject.L1.JPG

Procedure

Step 1 : Maintain Object Attributes

L2.JPG

Step 2 : Maintain Source Structures

Create two structures, second structure as lower level.

L3.JPG

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.

L4.JPG

Step 4 : Maintain Structure Relations

L5.JPG

Step 5 : Maintain Field Mapping and Conversion Rules

Maintain fields for both the two structures.

L6.JPG

Step 6 : Prepare Excel File.

Prepare both header and item file separately.

L7.JPG

Step 7 : Specify Files

Item file should be created under the Header file.

L8.JPG

Logical File path must be created in transaction FILE.

Step 8: Assign Files

L9.JPG

Step 9 : Read Data

L10.JPG

Step 10 : Display Read Data

Step 11 : Convert Data

Step 12 : Display Converted Data

Step 13 : Create Batch Input Session

L11.JPG

Click Display Errors Only

Following screen appears .

L12.JPG

Now the BOM is created for material.

L13.JPG

*&———————————————————————————————————————————————————————————–&*

Assigned tags

      33 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Bookmarked 😏 😘 Thanks for sharing 😎

      Author's profile photo Former Member
      Former Member

      Good Work Dany!! πŸ™‚

      Author's profile photo Ramesh .
      Ramesh .

      Good....Thank You....

      Author's profile photo Former Member
      Former Member

      Fantastic work Danny !! Thanks for your knowledge sharing.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you πŸ™‚ for you appreciation.

      Author's profile photo Benjamin Giehl
      Benjamin Giehl

      Great, thx. it´s a help, sure.

      Author's profile photo Former Member
      Former Member

      Really i like this.This is good for beginner.

      Thanks for sharing.

      Regards,

      Viswanathan S

      Author's profile photo sandeep praharaj
      sandeep praharaj

      nice document thnks for sharing

      Thanks & Regards

      Sandeep Kumar Praharaj

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Sandeep

      Author's profile photo Former Member
      Former Member

      Great Job πŸ™‚

      Thanks for sharing πŸ™‚

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank You Ajmeri

      Author's profile photo Former Member
      Former Member

      Good document Danny.

      Regards,

      Nilesh Mohite.

      Author's profile photo Former Member
      Former Member

      Hi, πŸ™‚

      Good Document thanks for sharing

      Author's profile photo Nagendra m
      Nagendra m

      Hi,

      Good d πŸ™‚ cument. thanks a lot for sharing

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Nagendra

      Author's profile photo Former Member
      Former Member

      Good Job Danny it is very useful πŸ™‚

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Mahesh.

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Hi Danny John,

      Good article... Thanks for sharing...very helpful.

      Regards,

      Rajesh

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Rajesh.

      Author's profile photo Debraj Bhaduri
      Debraj Bhaduri

      Nice document John...

      Can we do the same through recording method?If possuble please share..

      Regards

      Debraj

      Author's profile photo Vidyashree D
      Vidyashree D

      Good Document.

      Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Thank you Danny, this document was an outstanding assistance in my accomplishment of bom migration πŸ˜‰ .

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Glad that document was useful for you. πŸ™‚

      Author's profile photo Jie Peng
      Jie Peng

      can you help me why I alway dump during converting data QQ图片20151009130302.png

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Can u check in Read data whether you are able to see your data correctly in each field.

      Author's profile photo CHRISTOPHER VILLAMOR
      CHRISTOPHER VILLAMOR

      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Sorry Chris for the very late response

      You can find IDNRK field for the BOM component.

       

      Regards,

      Danny

      Author's profile photo Dinesh Jagasia
      Dinesh Jagasia

      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

       

      Author's profile photo Dinesh Jagasia
      Dinesh Jagasia

      The issue is resolved.

      Cheers

       

      Author's profile photo Rohit Nagdeve
      Rohit Nagdeve

      Dear Sir,

      Very nicely explained.

      Thanks a lot.

      Author's profile photo Tridib Das
      Tridib Das

      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.

      Author's profile photo Vuyolwethu Sam
      Vuyolwethu Sam

      Make sure your method is on "Create"

      Author's profile photo Vuyolwethu Sam
      Vuyolwethu Sam

      Nice Documentation. I have created equipment BOM using same logic. I used equipment as primary key in my files and it worked perfectly. Thanks for sharing knowledge.