Skip to Content
-1

SUIM Users by Complex Selection Criteria by authorization object

May 03 at 10:52 AM

35

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raymond Giuseppi May 03 at 11:09 AM
0

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
Show 1 Share
10 |10000 characters needed characters left 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.

0
Malaviben Rameshbhai Zala May 03 at 11:22 AM
0

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


suim-logic.png (18.6 kB)
suim-logic.png (16.5 kB)
Share
10 |10000 characters needed characters left characters exceeded