This workflow identifies users who only run a subset of transaction codes, in our case we are trying to identify which users are only accessing time entry transaction codes. The idea is that we could move time entry only users to a portal application and free up some professional licenses.
In order to run this example, you will need to edit all components that are in bold face type. The "Execute SQL" component named "Super Users" contains an insert statement that can be altered for any subset of transaction codes. Here is the SQL:
INSERT INTO Result (ACCOUNT) SELECT distinct(ACCOUNT) FROM Source1 Where NAME not in ('CAT2','CAT3','PT50','PR05')
Replace the transaction codes listed in the parenthesis.
Please note: This workflow connects to a productive ECC system and a productive BW system. A user could be a BW user and only use ECC for time entry and thus would still require a license.