Skip to Content

Requirement:

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

Mapping Template:

5 Structures:

/wp-content/uploads/2014/06/1_471749.jpg

Fields in the structures:

/wp-content/uploads/2014/06/2_471751.jpg

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.

/wp-content/uploads/2014/06/3_471752.jpg


LSMW:

Steps Involved:

/wp-content/uploads/2014/06/4_471753.jpg

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)

/wp-content/uploads/2014/06/5_1_471758.jpg

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

/wp-content/uploads/2014/06/6_471759.jpg

Step3: Maintain Source Fields

Maintain a Unique Identifier “RECORDNAME” in each structure.

/wp-content/uploads/2014/06/7_471760.jpg

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

/wp-content/uploads/2014/06/8_471761.jpg

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

/wp-content/uploads/2014/06/9_471762.jpg

Step4: Maintain Structure Relations

Map the structures respectively.

/wp-content/uploads/2014/06/10_471763.jpg

Step5: Maintain Field Mapping and Conversion Rules

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

/wp-content/uploads/2014/06/11_471764.jpg

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

/wp-content/uploads/2014/06/12_471765.jpg/wp-content/uploads/2014/06/13_471766.jpg

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.

/wp-content/uploads/2014/06/14_471770.jpg

Step8: Assign Files

Assign the input file to each structure applicable as shown below

/wp-content/uploads/2014/06/15_471771.jpg

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.

/wp-content/uploads/2014/06/16_471772.jpg


Step10: Display Read Data

/wp-content/uploads/2014/06/17_471773.jpg

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.

/wp-content/uploads/2014/06/18_471774.jpg

Step12: Display Converted Data

The data converted, can be seen at this step.

/wp-content/uploads/2014/06/19_471776.jpg

Step13: Create Batch Input Session

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

/wp-content/uploads/2014/06/20_471777.jpg

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

/wp-content/uploads/2014/06/21_471778.jpg

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.

To report this post you need to login first.

4 Comments

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

      1. Arabind PP

        Hi Prasant,

        Very good document .Still I have some doubt.Can you post the recording as well the excel template..

        Regards

        Aravind

        (0) 
        1. Prasanth Reddy Post author

          Hi Arabind,

          If you are talking about the screen level recording for Task List , here it is not required.

          Here we have Batch Input and Method. I have mentioned the details of the same in Doc.

          Please check and let me know , if you still have any doubt.

          Thanks

          Prasanth Reddy.

          (0) 

Leave a Reply