I am sure that your data governance is up do date and you are happy with your eCATT and LSMW scripts, or even happy that you saved some money to hire some interns or temps to enter data in your system. But why doing it the better & more cost effective way if you have money to burn? Just kidding!

Did you know that you can save a lot of abap development and manual labor by having your data taking a Shuttle in the form of a easy to use tool that can be run by end-users within Excel? The example below shows a few easy steps to reset passwords in SAP, including re-running the script on failed records if there is a problem with data.

You would not give LSMW to end-users but with this tool, you can have them loading data via Microsoft Excel. You also can create excel data entry forms that save lots of time vs. using regular SAP Screen, like for example, creating new employees via PA30.

For this example, the system administrator generates a set of random passwords online.

1 pwgen

The data is extracted into a text or Microsoft Excel and pasted into another Excel template file:

2 pw_list

From within Excel, the administrator runs the script that resets passwords via SU01.

3 excel datafile

However, one of the passwords starts with a character that SAP would not allow and fails on that – the other user ID’s have been reset successfully:

4 pwgen_run

Being in a hurry and a human being, the Administrator makes another mistake and changes only one of the two passwords that need to be identical. Now, the script has to be re-run again (just for failed items):

5 pwgen_run_error

The one item that failed finally can be processed correctly and is highlighted (by the tool). The log file can be used for audit purpose and shows the records that have been updated.

6 pwgen_run_error_results

Below a few other examples where you can perform a daily or weekly task in a few seconds, for example by terminating multiple users at once. You can also run the same scripts against mutliple systems to have all data in synch exactly the same way. That script is changing the user into the ‘Terminated’ user group, end-dates the user-ID, adds a ticket number into the account field, removes all existing roles and finally, locks the user-ID.

7 mass termination data

Results in SAP (overview)

8 mass termination sap

Please feel free to contact us if you want a demo, white papers or learn more about this product.

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
  • Share/Bookmark