Automate

 View Only
  • 1.  SU01D

    Posted 04-03-2020 10:24
    ​Hi All,

    I'm using 10.7.1 and I'm trying to use SU01D to see if a user has a particular role assigned.  I can go to the roles tab and perform the search, but I can't seem to get a value returned from SAP to Excel that shows what the role on the first row is. I have been able to get other user data returning to Excel, jst not from this tab.

    Any suggestions much appreciated.

    Everyone stay safe!

    Regards

    ------------------------------
    Mark Tiller | Delivery Enhancement Developer
    Transport for London (TfL) | 0203 054 4196
    ------------------------------


  • 2.  RE: SU01D

    Posted 04-04-2020 09:58
    I would recommend using Query and look up the tables that are used in SU01D to extract the data you need. I use Google to look up SU01D tables.


    ------------------------------
    Benjamin Kielas | SAP Data lead
    Generac Power Systems, Inc. | 2625106580
    ------------------------------



  • 3.  RE: SU01D

    Posted 04-06-2020 07:56

    One can also use SUIM to search for all users associated to a particular role.  I know this isn't Winshuttle related, but it may be helpful nonetheless.






  • 4.  RE: SU01D

    Posted 04-07-2020 03:12
    SAP table AGR_USERS will have SAP roles along with user names.

    ------------------------------
    Moazzam Mubarak | Manager SAP
    De Beers Canada Inc | 5875825035
    ------------------------------



  • 5.  RE: SU01D

    Posted 04-07-2020 05:28
    Thanks everybody, I'll try these out​.

    ------------------------------
    Mark Tiller | Delivery Enhancement Developer
    Transport for London (TfL) | 0203 054 4196
    ------------------------------