SAP USERS++ Global Central Administration v2.0.19.0

July, 30th 2010

Jean-Michel SOMMER SOMMER IT CONSULTING [email protected] [email protected] 21.04.2011

1

SAP USERS++ Global Central Administration v2.0.19.0




Standalone local installation on Microsoft Windows Microsoft Access 2003 SAP GUI 7.10

(to get requiered SAP logon capabilties)






Secured access SAP Security SAP Traceability Flexible configuration Fast download

(tested with data from 65 systems with 40.000 user accounts in less than 7mn)

21.04.2011

2

Original Concept



SAP tables

Read tables via RFC

Change User via RFC




MSAccess task queue tables

21.04.2011

MSAccess temp tables




Manual Or Automated updates

Creation of global user data cube

MSAccess working tables Allow fast access to user data

3

RFC_READ_TABLE Download module




Download necessary information from selected SAP tables like USR02

Including : 1. 2. 3. 4. 5. 6.

Full SAP Landscape download Status of current download Completion indicator Warnings Advanced download Generation of the CUBE

21.04.2011

4

FAST++ overview


Fast overview of a user across a full landscape

1. 2. 3. 4.

Check Header data and Roles Copy/Paste updates Change lock / password, and send emails Manage Groups and ULI (get info from LDAP)

21.04.2011

5

Update SAP !


1. 2. 3.

The task queue

Check your changes Send the updates (1 to 3 second for each task) Get feedback message from SAP (real message, RFC response)

21.04.2011

6

Additionnal features














Automated classification of user licenses Clone user header data Mass Deactivation Change password module – Send email (Windows API) Manage SAP group and description across landscape Synchronize Unique Location identifier into SAP with Active Directory data Advanced User Roles and derived Role comparison cross SAP landscape Manage administrator connection Assign group of role Report BI 7.0 authorizations Landscape view live connections Report SAP system parameters Unlimited report possibilities…

21.04.2011

7

Annex 1 : Secured Logon to the tool

21.04.2011

8

Annex 2 : Main menu

21.04.2011

9

Annex 3 : License management

21.04.2011

10

Annex 4 : Group Management

21.04.2011

11

Annex 5 : Advanced Role Comparison

21.04.2011

12

Annex 6 : Basic Reporting to Excel

21.04.2011

13

Annex 7 : BI 7.0 authorization Reporting to Excel or SAP BUSINESS OBJECT

21.04.2011

14