10-19-2011 1:15 PM
Good morning all,
I am required to perform a system measurement exercise with USMM. I was curious whether anyone knows a good way to setup a batch job that would reflect daily changes to the USR02 table, because we would like to have our Service Desk update an external spreadsheet of user into as it changes to stay in line with our production system. The reasoning behind this is to match up our employee data against an HR master list.
Things like users being created, locked, or unlocked.
I also looked for a tool internal to SAP for this, but could not find one.
Any help or insight would be greatly appreciated.
Edited by: Ben Daniels on Oct 19, 2011 8:15 AM
10-19-2011 8:17 PM
Report RSUSR100N at midnight with the Excel list as spool recipient via OLE?
Otherwise, shame... the poor "service desk"...
Cheers,
Julius
10-19-2011 1:24 PM
Hi Ben,
Check for this Badi's:
ADDRESS_UPDATE
HRBAS00INFTY
HRFPM_FTE_DISPATCHER
LSO_CORRESPONDENCE41
You can insert custom code to update your file, after SU01 User Saving.
Otherwise, you can also develop a daily scheduled report to read all user and write/update the file.
10-19-2011 8:17 PM
Report RSUSR100N at midnight with the Excel list as spool recipient via OLE?
Otherwise, shame... the poor "service desk"...
Cheers,
Julius
10-19-2011 8:24 PM
Hah! Thanks Julius.
Initially they wanted a Z program created, but I was able to convince them to do this exact thing. Thanks for your input on the solution.
10-19-2011 8:33 PM
Wow! You convinced them of that in just 7 minutes...
Must be a very good report
Cheers,
Julius