S.03 - Users by Profile

This workflow accesses the UST04 table to find the user accounts associated with the specified profiles and subprofiles in the Profiles String List parameter. The personnel number for each user is obtained from the USR21 table, and the name associated with each user account is obtained from the ADRP table.

The results are stored in the Result Table dataset, which has the following columns:

Column Description
BNAME User name.
PROFILE The specified profile associated with the user name. If a sub profile was specified in the Profiles list, this field refers to the parent profile.
PERSNUMBER User’s personnel number.
NAME_FIRST User’s first name.
NAME_LAST User’s last name.
NAME_MIDDLE User’s middle name.

Creating RFC Destinations

Before you begin, you will need to create an RFC Destination for the SAP system you wish to analyze.

Preparing the Workflow

To prepare the S.03 - Users by Profile workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the system to analyze:

  1. Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the RFC Destination for the system to analyze, then click ‘Save’.

To specify the profiles and subprofiles to retrieve:

  1. Select the Profiles parameter and choose ‘Edit String List’ from its context menu to display the String List Editor dialog.

  2. Click 'Insert Row' to enter the names of each profile or subprofile, then click ‘Save’. Each profile or subprofile should be added as a separate string entry.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the S.03 - Users by Profile workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Result dataset and choose ‘View Details’ from the context menu to display the result table.