S.03 - Users by Profile

This workflow accesses the SAP 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	Username.
PROFILE	The specified profile associated with the username. 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.

Create RFC Destinations

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

Prepare the workflow

To prepare the S.03 - Users by Profile workflow, drag its workflow template from the Templates > Basis 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.

Click to save the workflow.

Run the workflow

To run the S.03 - Users by Profile workflow, click the toolbar button, choose Run Now from the diagram’s context menu, or select 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.