SUIM Users by Complex Selection Criteria by authorization object

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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

[RaymondGiuseppi]

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.

[Former Member]

Hi Raymond,

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

suim-logic.pngsuim-logic.png