Skip to Content
-1

SUIM Users by Complex Selection Criteria by authorization object

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

suim.png (26.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 03 at 11:09 AM

    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
    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • May 03 at 11:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded