topic SUIM Users by Complex Selection Criteria by authorization object in Application Development and Automation Discussions

SUIM Users by Complex Selection Criteria by authorization object

Former Member — Thu, 03 May 2018 10:52:17 GMT

Hi All,

I want to extract all users for authorization objects (S_PROGRAM and S_TCODE) SUIM -> Users by Complex Selection Criteria.

Can anyone provide table linking for below mentioned criteria?

suim.png

Re: SUIM Users by Complex Selection Criteria by authorization object

RaymondGiuseppi — Thu, 03 May 2018 11:09:51 GMT

Look at tables

UST04 User masters
UST10S User master: Single profiles
UST12 User master: Authorizations

You may in some case also require (in some do/loop til no more profiles)

UST10C User master: Composite profiles

Re: SUIM Users by Complex Selection Criteria by authorization object

Former Member — Thu, 03 May 2018 11:22:53 GMT

Hi Raymond,

I am using below logic to fetch the data..but I am getting different number of enteries than SUIM.

suim-logic.png suim-logic.png

Re: SUIM Users by Complex Selection Criteria by authorization object

RaymondGiuseppi — Thu, 03 May 2018 12:31:28 GMT

You could use a JOIN

        select  ust04~bname into bname
          from  ust12 "#EC CI_BUFFJOIN 
          join  ust10s "#EC CI_BUFFJOIN 
            on  ust10s~objct  eq ust12~objct
            and ust10s~auth   eq ust12~auth
            and ust10s~aktps  eq ust12~aktps
          join  ust04 "#EC CI_BUFFJOIN            
            on  ust04~profile eq ust10s~profn
          for all entries in lt_autor
          where ust12~objct   in lr_objct
            and ust12~aktps   eq 'A'
            and ust12~field   eq lr_field
            and ust12~von     eq lr_von.

Seems you didn't filter for active version of authorization...

NB: Also check for any composite profile (browse ust10c) if this is the case, use a first select for list of profiles, and do a select for composite profile from previous result, until no new selected profile. Only then select users.