The reason to create this macro was to update webcycle (workcycle) users according to plant / company/ p. org.
Root cause: Updating users manually is an activity that takes too long and does not develops any skill.
Solution: Create a macro which loops through a new user’s list, searching them on the transaction ZWFA05K - PRECO E VENC / ZWFA05H - TAB QUANTIDADE.
This Operating Procedure (OP) applies to SBS Curitiba Office, the responsible area is DMO LAM/NAM, though it can be adapted to other regions.
The Macro can be executed whenever a webcycle table needs to have its users updated , the request is sent through a freshdesk ticket.
Roles and Responsibilities
Paulo Bastos (Data Management Operator) was the main developer and he is responsible to ensure that the macro is running right, with no bugs or errors.
Thiago Carlins, Edison Fontoura and Izabella Casagrande are the backups responsible to run the macro and correct eventual errors and bugs.
Macro will be used only WP1 system and the operator needs to have the credentials to access the tables ZWFA05K (ZWFAT159) / ZWFA05H (ZWFAT155).
Usually the user asks to extract the data which is under his scope on tables.
The data can be downloaded from SE16 tables.
Tables according to transactions:
ZWFA05K (ZWFAT159) / ZWFA05H (ZWFAT155)
After that, open the file on “Q:\Paulo Bastos\Tables - Macro Webcycle User Exchange”.
- Enter the data you want to find, (COLUMNS "A" to "E"). * PS = site’s data must have 3 characters.
- In the column "GENERIC USER", place the new user who the webcycles will be assigned to.
- Run the macro by clicking on the “Change Users” Button.
- The data will be modified. Review them and then click save before leaving the table.
A Casting out nine method can be made by downloading the new users on SE16 table and crossing the data with the excel.
Macro steps:
The macro follows these steps:
Searching for the users according to excel cells.
copying the data from “Genera User” column excel to SAP.
Looping through rows.
The updates need to be saved manually.
(1) The macro will debug if there the site has less then 3 characters.
(2) The macro will debug if the user is wrong.
Contingency
In case of a problem in the VBA Robot running, the activity must be performed manually.
