LSMW for uploading BOM | SAP Blogs

Skip to Content

Actions

LSMW for uploading BOM

August 13, 2013 | 2,418 Views |

Danny John

more by this author

ABAP Development

Follow

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.

Bastin Vinoth August 13, 2013 at 10:32 am

Bookmarked 😏 😘 Thanks for sharing 😎

like (0)
niran orkkatteri kariyadan August 13, 2013 at 10:55 am

Good Work Dany!! 🙂

like (0)
Ramesh T August 13, 2013 at 10:58 am

Good….Thank You….

like (0)
Raja Babu August 16, 2013 at 5:24 am

Fantastic work Danny !! Thanks for your knowledge sharing.

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

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

like (0)
Viswanathan s 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. Danny John Post authorSeptember 27, 2013 at 8:58 am
  
  Thanks Sandeep
  
  like (0)
Akberhusain Ajmeri September 27, 2013 at 9:25 am

Great Job 🙂

Thanks for sharing 🙂

like (0)
1. Danny John Post authorSeptember 27, 2013 at 11:13 am
  
  Thank You Ajmeri
  
  like (0)
Nilesh Mohite September 27, 2013 at 11:23 am

Good document Danny.

Regards,

Nilesh Mohite.

like (0)
KIRAN RAJAN September 27, 2013 at 11:25 am

Hi, 🙂

Good Document thanks for sharing

like (0)
Nagendra m September 28, 2013 at 7:45 pm

Hi,

Good d 🙂 cument. thanks a lot for sharing

like (0)
1. Danny John Post authorSeptember 30, 2013 at 5:23 am
  
  Thank you Nagendra
  
  like (0)
Mahesh V October 22, 2013 at 11:03 am

Good Job Danny it is very useful 🙂

like (0)
1. Danny John Post authorOctober 22, 2013 at 11:08 am
  
  Thank you Mahesh.
  
  like (0)
rajesh bethamcharla October 22, 2013 at 11:08 am

Hi Danny John,

Good article… Thanks for sharing…very helpful.

Regards,

Rajesh

like (0)
1. Danny John 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)
Vidyashree D August 19, 2015 at 11:08 am

Good Document.

Thanks for sharing

like (0)
Simon Probst 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. Danny John 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. Danny John 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. Danny John 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)