INTRODUCTION

Objectives and scope of this procedure

This OP explains how to write up the report of users created on SRM per month.

TCode SE16 Table USR02 – BP2

Data Operations > SRM7 Report of Users Created > image.png

Data Operations > SRM7 Report of Users Created > unnamed (1).png

Data Operations > SRM7 Report of Users Created > image (1).png

#	Main Activities	Tips / Best practices	Key points
1.	Fulfill “Created on” field	first last days of the month
2.	Clear ”width of Output List” and “Maximum No. of Hits” fields
3.	“Execute”		Will generate a list
4.	Click “Edit” -> “Download…”
5.	Click “Spreadsheet”
6.	Click “Continue”
7.	Choose the file directory and name and click “Generate”		Will generate a file with all users created
8.	Copy all users to Clipboard	Can use the following shortcuts: Select the first name and press “Ctrl + Shift + down arrow” (Will select all names) Press “Ctrl + C” (will copy them all)

TCode ZWPU01K – BP2

(Validity Date field by default is the date of the extraction)

#	Main Activities	Tips / Best practices	Key points
1.	Click “Multiple Selection”
2.	Click “Upload from clipboard” and all user copied to clipboard will be copied to the list
3.	Click “Execute”
4.	Click “Execute”		Will generate a list of users with theirs info
5.	Click “Export”
6.	Click “Spreadsheet”	If window “B.” appears, you will have the option to select the flag on window “A.” In this case, you will be able to jump steps 7. and 8. directly to step “9.”
7.	Select “Excel (In Office 2007 XLSX Format)” from “Select From All Available Formats”
8.	Click “Continue”
9.	Choose directory and name and save the file

Cross information with Companies per Country

#

Main Activities

Tips / Best practices

Key points

1.

“Company” column must be formatted as number.

2.

Add new column on report’s file called “Country”

Can use one of this tips:

use formula in this column: =IFERROR(VLOOKUP(J2;'2018-11-06 - Documents Export '!K:N;3;0); VLOOKUP(J2;'2018-11-06 - Documents Export '!L:N;2;0))
copy column from “Dec 2019”

Send the report

#	Main Activities	Tips / Best practices	Key points
1.	Create a filter and choose the EMEA countries (Exclude “#N/A” results)		EMEA countries listed at the end of this document
2.	Copy the result to new tab on this file: https://docs.google.com/spreadsheets/d/1IjNGtG-JAEIFfqp0oyEjdO4YFpnOB-6p2LshWBE-Mtw/edit#gid=711468199		Rename the new tab with respective month and year: (example) DEC2019
3.	Send the email to EMEA responsibles::		Persons to send: Daniela Gargano: daniela.gargano@solvay.com Dirk Vercammen: Dirk.Vercammen@solvay.com Julie MUNOZ: julie.munoz@solvay.com Liz COTTERILL: liz.cotterill@solvay.com Hartmut SCHWARTZ: hartmut.schwartz@solvay.com Caroline DELOGE: caroline.deloge@solvay.com Diane KEALY: diane.kealy@solvay.com, Caterina Varone: aterina.Varone@solvay.com, And all SRM7 team in copy
4.	Create a filter and choose the NAM countries (Exclude “#N/A” results)		NAM countries listed at the end of this document
5.	Copy the result to new tab on this file: https://docs.google.com/spreadsheets/d/1yh5jxSfKA9apggN2FhwtvL-zkOnuZbt6fa7bBzUA6Nw/edit?ts=5e170c86#gid=861285794		Rename the new tab with respective month and year: (example) DEC2019
6.	Send the email to responsibles		Persons to send: Nicole Colson: Nicole.colson@solvay.com Danielle Dalton: Danielle.Dalton@solvay.com Deepa Pathirage: deepa.pathirage@solvay.com Diane Kealy: diane.kealy@solvay.com And all SRM7 in copy

Subject: Report SRM users creation EMEA - June 2017

"Dear all,

Kindly be informed that a new sheet "JUN2017 '' was created and shared with you regarding the SRM7 Users creation.

In case of any doubt please feel free to contact me.

Thank you and kind regards“

List of EMEA countries scope:

List of NAM countries scope:

End of document