The reason of developing this macro was improving quality and creation speed of Industrial Supplies materials.
Root cause: ZERS creation process is a manual activity which does not develop many skills for data operators. Some requests need to create more than 50 materials at a time, so the automation helps to accomplish SLA target.
Solution: A VBA Robot which copies the data from the material forms (filled by requesters) and does the required adjustments to input data in system in order to create a new material.
This Operating Procedure (OP) applies to SBS Curitiba Office, the responsible area is DMO LAM/NAM.
The Macro runs whenever a ZERS (LAM/NAM) material needs to be created, 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.
Edison Fontoura (Data Management Operator) is the first backup, responsible to run the macro and correct eventual errors and bugs.
Macro can be used only on WP1 system and the operator needs to have the credentials to material creation transaction (MM01).
How to Run
First of all, the material form must be saved in the “Q:\Paulo Bastos\BR MATERIAL CREATION MACRO” file (the format must be excel XlSX) . PS: the excel file doesn’t need to be opened, since the macro will execute the open/closure task. (*Macro is configured to run inside “Paulo Bastos” file)
Open “BR Material Creation Macro” file.
Press the button “update list”, so the saved material files (xlsx. docs) will be updated on the list. Choose the desired material.
The sheet is splitted between 2 parts. Text boxes and Cells values from the form. “Button 2” is for design mode macro and “Button 3” for the normal macro. Press the buttons according to numbers.
1 - Press button 1 to Open material creation form and remove blocking password.
2 - Press button 2 to Import text box data (design mode) from material form.
3 - Press button 3 to import data from form’s cells.
*After pressing button 3, review the gathered data from the form, before finishing the creation. If any modification of the data that will be input in system is required, execute the exchanges manually, on column “M”.
4 - Press button 4 to trigger the macro and create material. When macro stops running, copy the code and save the material on SAP.
Material Creation steps:
After button is pressed, It Opens excel file forms
Unblocks form’s worksheet
Copy data from form to Macro worksheet
Catalog and fix data from macro’s sheet on column “Adjustments”/”System Field” (column “N”).
Enter transaction “mm01” on SAP and copy data from macro sheet to.
The saving and copying material’s code process is manual.
(1) If the macro debugs after the “Create Material” button is pressed, click on “debug” and check on which field the macro has stopped. It might be a data field that must be adjusted before being copied to SAP (a price or material delivery date, for example).
Contingency
In case of a problem in the VBA Robot running, the activity must be performed manually.
