How to update multiple operations in tasklist

Submitted by Anonymous (not verified) on Fri, 05/20/2022 - 01:12

I would like to update multiple operations in tasklist through transaction IA06 , the fields I would like to update are Work center , Plant and Control key. Could you please help to create LSMW for Tasklist operation update as I am not able to get operation number in LSMW recording.

Duration: 
1 month

Comments

1
Jimbo's picture
Submitted by Jimbo on Fri, 05/20/2022 - 01:48

Normally, the response to such questions are simply emailed back, but this question came in with no return email address. The answer is posted here in the hopes that it can help the person who asked the question.

While recordings tend to make tasks like this easy, they're not always the best solution. The IA06 transaction has no go to Operation number field to make focusing on the right Operation easy, so guessing on what grid line in the screen the Operation will land is the requirement. That isn't impossible, but likely very cumbersome as it may not land on the first screen and require that the grid be scrolled down a number of pages which must also be predicted.

A better solution would be to use LSMW as a wrapper for a BAPI and call the EAM_TASKLIST_CHANGE function. This function accepts an internal table IT_OPERATIONS_UPD as a parameter which has the fields VORNR, STEUS, WERKS and ARBPL to change.

Naturally, reading the existing data out of the PLPO table to populate all of the fields that are already populated would be necessary; replacing those values with blanks might be catastrophic and would certainly be unnecessarily risky. Much easier is to coax the data into the structure, change the appropriate fields and then append the record into the internal table to be passed on to the BAPI.

A little experimentation in SE37 and then in a sandbox LSMW system would make short work of this. Transporting the LSMW object to the production system is as easy as exporting and importing the LSMW project.

An alternative solution would be to create a Excel scripting tool using Saplicity. It might take an hour to knit in the logic for stepping through the operations and touching the appropriate fields, but the result is a bulletproof tool that can be passed to users who have neither access to LSMW nor a license for an expensive proprietary scripting tool (Saplicity is free).

Check out the Saplicity website for tutorials and recyclable code to get up-to-speed in some minutes. For an experienced VBA programmer, the learning curve is effectively flat.