The reason to develop this macro was to create a list of NAM materials massively, executing the copy-paste activities automatically from material’s form to SAP Material Creation Transaction.
Root cause: Speed up the ZERS US Material creation process, NAM, and so the creation of the PIRs.
Solution: Create a macro which loops through all the items that must be created to attend NAM plants (Data gathered from US form, filled by requester).
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 is executed whenever a new material needs to be created .
Thiago Carlins (Data Management Operator) was the main developer.
Edison Fontoura and Izabella Casagrande are the backups responsible to run the macro and correct eventual errors and bugs.
Macro is used in RCS system, the operator needs to have the credentials to access MM01 and ME11 transactions.
How to Run
First Part
Open the file Q:\Luiza Ciecilinsky\ZERS creation.xlsm
Fill the cells in “ZERS” tab with the information provided in the US NAM material forms (sent as an excel file, in freshdesk request) - Columns “A” to “W”
After it, click on button “Material Creation”
PS: An extraction on SE16 transaction (table: MARA) , can be made to download all the materials that were created.
Second Part
On the Second part, the material numbers that were just created need to be copied from MARA and pasted on “PIR” sheet to proceed with Purchasing Reg Info creation.
The PIRs will be created after pushing the button.
The PIR numbers can be extracted on table EINA
PIR long text description needs to be inserted manually.
After that, the Material and PIR numbers need to copied to the material form once again.
Macro steps:
Open transaction MM01.
Enter Material type, plant, and store location (data copied from excel worksheet).
Starts material creation with the data inserted on worksheet “ZERS”.
Copies the material number and the other information required on sheet “PIR” to SAP, after entering transaction ME11.
(1) The macro will debug if the fields are different from SAP pattern, for example, a plant is “0263” and excel cells are filled as “263”.
Contingency
In case of a problem in the VBA Robot running, the activity must be performed manually.
Related Documents
