Skip to Content

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.

29 Comments

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

  1. 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

     

    (0) 

Leave a Reply