LSMW for uploading BOM | SAP Blogs

Skip to Content

LSMW for uploading BOM

August 13, 2013 | 6,087 Views |

Former Member

ABAP Development

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.

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

To report this post you need to login first.

29 Comments

You must be Logged on to comment or reply to a post.

Former Member August 13, 2013 at 10:32 am

Bookmarked 😏 😘 Thanks for sharing 😎

like (0)
Former Member August 13, 2013 at 10:55 am

Good Work Dany!! 🙂

like (0)
Former Member August 13, 2013 at 10:58 am

Good….Thank You….

like (0)
Former Member August 16, 2013 at 5:24 am

Fantastic work Danny !! Thanks for your knowledge sharing.

like (0)
1. Former Member Post authorAugust 16, 2013 at 9:36 am
  
  Thank you 🙂 for you appreciation.
  
  like (0)
Former Member August 16, 2013 at 10:35 am

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

like (0)
Former Member August 16, 2013 at 11:01 am

Really i like this.This is good for beginner.

Thanks for sharing.

Regards,

Viswanathan S

like (0)
sandeep praharaj September 23, 2013 at 11:35 am

nice document thnks for sharing

Thanks & Regards

Sandeep Kumar Praharaj

like (0)
1. Former Member Post authorSeptember 27, 2013 at 8:58 am
  
  Thanks Sandeep
  
  like (0)
Former Member September 27, 2013 at 9:25 am

Great Job 🙂

Thanks for sharing 🙂

like (0)
1. Former Member Post authorSeptember 27, 2013 at 11:13 am
  
  Thank You Ajmeri
  
  like (0)
Former Member September 27, 2013 at 11:23 am

Good document Danny.

Regards,

Nilesh Mohite.

like (0)
Former Member September 27, 2013 at 11:25 am

Hi, 🙂

Good Document thanks for sharing

like (0)
Former Member September 28, 2013 at 7:45 pm

Hi,

Good d 🙂 cument. thanks a lot for sharing

like (0)
1. Former Member Post authorSeptember 30, 2013 at 5:23 am
  
  Thank you Nagendra
  
  like (0)
Former Member October 22, 2013 at 11:03 am

Good Job Danny it is very useful 🙂

like (0)
1. Former Member Post authorOctober 22, 2013 at 11:08 am
  
  Thank you Mahesh.
  
  like (0)
Former Member October 22, 2013 at 11:08 am

Hi Danny John,

Good article… Thanks for sharing…very helpful.

Regards,

Rajesh

like (0)
1. Former Member Post authorOctober 22, 2013 at 11:11 am
  
  Thanks Rajesh.
  
  like (0)
Debraj Bhaduri March 16, 2015 at 3:21 am

Nice document John…

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

Regards

Debraj

like (0)
Former Member August 19, 2015 at 11:08 am

Good Document.

Thanks for sharing

like (0)
Former Member September 24, 2015 at 6:17 am

Thank you Danny, this document was an outstanding assistance in my accomplishment of bom migration 😉 .

like (0)
1. Former Member Post authorSeptember 24, 2015 at 3:54 pm
  
  Glad that document was useful for you. 🙂
  
  like (0)
Jie Peng October 9, 2015 at 5:02 am

can you help me why I alway dump during converting data

like (0)
1. Former Member Post authorOctober 12, 2015 at 6:06 pm
  
  Can u check in Read data whether you are able to see your data correctly in each field.
  
  like (0)
CHRISTOPHER VILLAMOR April 17, 2017 at 8:36 pm

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

like (0)
1. Former Member Post authorJune 27, 2017 at 2:09 pm
  
  Sorry Chris for the very late response
  
  You can find IDNRK field for the BOM component.
  
  Regards,
  
  Danny
  
  like (0)
Dinesh Jagasia July 18, 2017 at 12:04 pm

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

like (0)
1. Dinesh Jagasia July 20, 2017 at 2:07 pm
  
  The issue is resolved.
  
  Cheers
  
  like (0)