LSMW for uploading BOM

[Former Member]

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.

*&-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------&*