Actions

LSMW for uploading BOM

August 13, 2013 | 2,032 Views |
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

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

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

To report this post you need to login first.

26 Comments

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

Leave a Reply