Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Requirement:

Creation of Task List using LSMW Batch Input with 1 input file having 5 level Structure data.

Mapping Template:

5 Structures:

Fields in the structures:

Note:     1) All these 5 rows generate 1 Task list.

2) There can contain multiple Operations (level2) for each Header (Level1) in the input file.

3) There can be multiple Text Lines (Level3), Components (Level4), and Packages (Level5) for 

each Operation (Level2).

Input File Format:

The first Column is the Unique Identifier, which we need to maintain at the source field level for correct mapping.


LSMW:

Steps Involved:

Step1:  Maintain Object Attributes

We have Batch Input for the Task List Creation in the LSMW.

Data Transfer Object:           0490

Data Transfer Method:        B (Batch Input)

Step 2: Maintain Source Structures

Maintain Source Structures as per the Hierarchy.

Create a Header File Structure. Add Operation as the child Node (Next Level) to Header.

Add Long Text, Components, Packages structures as the child node (Next level) to Operations.

But all these three at same level

Step3: Maintain Source Fields

Maintain a Unique Identifier “RECORDNAME” in each structure.

Double Click the RECORDNAME Field and fill the identifying Field Content with some Unique Value.  

Similarly, do this for all the Identifying fields in each structure. The same can be screen in the screenshots.

Step4: Maintain Structure Relations

Map the structures respectively.

Step5: Maintain Field Mapping and Conversion Rules

Go to Menu Bar -> Extras -> Auto Field Mappings.

This will map the fields in our Source structures to the corresponding fields the Target Structures.

Similarly, all the fields will be mapped accordingly. It will be better to cross check.

Step6: Maintain Fixed Values, Translations, User-Defined Routines

User Defined Routines or Values can be maintained at this step.

Step7: Specify Files

At this step, specify the input file present at the Presentation Server.

Step8: Assign Files

Assign the input file to each structure applicable as shown below

As we have single input file, assign the same to all the structures applicable.

Step9: Read Data

At this Step, the data in the input file will be read and stored in the Structures.


Step10: Display Read Data

Step11: Convert Data

The data read from the input file, will be converted as the rules we provide in the field mapping stage.

Ex: Here, Conversion Exit was used was for Equipment Number.  This conversion will be executed at this stage.

Step12: Display Converted Data

The data converted, can be seen at this step.

Step13: Create Batch Input Session

This step will create the Batch Session. We need to provide the Session Name at this step.

Provide the Session Name. Delete the Deletion indicator, if you want to keep the session even after processing.

Step14: Run Batch Input Session

This will take you to SM35.  You can process the session according to your requirement.


Hope this might be helpful...!



Thanks

V Prasanth Kumar Reddy.

6 Comments
Labels in this area