General Task List Upload on LSMW with Document (DMS) by Direct Input method

[phi_dang]

Table of Contents

I. Requirement

II. Solution

III. How to do

1. Prerequisite

2. Correct wrong default transaction on LSMW

          Symptom

          Solution

        3. LSMW creation for General Task List

Maintain Object Attributes

Maintain Source Structures

Maintain Source Fields

Maintain Structure Relations

Maintain Field Mapping and Conversion Rules

Define Upload File

Specify Files

Read Data

Convert Data

Create Batch Input Session

Run Batch Input Session

I. Requirement

• Upload General Task Lists with operations
• Task List number is generated automatically
• Documents are assigned to Operations on task list

II. Solution

• Create LSMW with Direct Input method
• Multi - level structure with 3 levels : task list header, task list operation and document

III. How to do

1. Prerequisite

• Document Management System is implemented in advance
• Documents are already created on CV01N
  • Sample documents using on scope of this Document are

2. Correct wrong default transaction on LSMW

Symptom

• Transaction LSMW with objects 0490 - general task list call to IA01 (equipment task list) instead of IA05
• Apply SAP Note 1120544

Solution

Detail steps are:

Go to transaction code SM31, select table SXDA3, choose Maintain

Click on Table Name and Enter, type IBIPTLST on Table Name

Double click on below record

Change value IA01 to IA05 and Save

Other method to change the T code

In the LSMW under Maintain "Field Mapping and Conversion Rules" in change mode

 

Just double click on IBIPLIST-TCODE it will pop up new screen where you can change the T code = IA05

Note: If you dont find the technical fileds in the above screen you can activate by menu path Extras>layout , then tick mark the "Technical Fields"

Edited the content for sharing the information , thanks to Mr PHI DANG for this documentation

3. LSMW creation for General Task List

Maintain Object Attributes

Choose Object and Method as below

Maintain Source Structures

Create Source Structure as below.

Put curse on TLHEADER and click  button, select Lower Level and type TLOPERATION

Put curse on TLOPERATION and click button, select Lower Level and type TLDOCUMENT

 
 

Maintain Source Fields

Enter source fields as below. You may enter other field length number.

Note:

IDENT is a key to map Header and Operation

IDENT2 is a key to map Operation and Document

 
 

Maintain Structure Relations

Create Relationship as below

Maintain Field Mapping and Conversion Rules

Select Extra à Auto-Field Mapping for this step

Define Upload File

There are 3 upload file: HEADER, OPERATION and DOCUMENT

Below are sample upload files

     1. Header

 
Note

If you want to use INTERNAL NUMBER RANGE, put the “!” on PLNNR, otherwise, upload program just create the first task list only

If you want to use EXTERNAL NUMBER RANGE, enter Group name as normal (E.g. Inspection1)

     2. Operation

In my upload, I create 2 operations for each task list; Header of each Operation is identified by IDENT key

     3. Document

Document is attached to Operation as PRT with PRT category Document

IDENT2 is a key to identified which document is assigned to which operation

In this example, I assign 2 documents to each operation of 1^st Task list, 3 documents to each operation of 2^nd task list and 1 document to operation 10 of 3^rd task list

Note

Document with DMS is usually assigned on task list as below:

Specify Files

Assign correct upload files on this step

 
 

Read Data

Convert Data

Do as normal

Create Batch Input Session

Choose application server and assign Physical file for save incorrect data records. In my case, I use the same file

Run Batch Input Session

Execute Session and get Result

Check Task List 45

HEADER

Operation

Document on Operation 10

2 documents on operation 10 of the 1st task list as on upload file.