How to find the authorization object and details from role

[Former Member]

Hi Expert,

Currently I am working on PLM project . I am new in this domain so my requirement is to find out the authorization object details from Role .

Could any one please help me to tell the tables related to PLM.

Following are my requirement.

1.  Which contexts 1: n users are assigned to?

2.  Which users are assigned to 1: n ACM contexts?

3. Which documents are assigned to 1: n ACM CONTEXTS?

4. To which contexts 1:n document info records are assigned?

Waiting for your valuable reply.

Thanks and Regards,

Prakash

[Former Member · Accepted solution]

Thanks to all..!!!

I got the answer for 2 questions .

1.  Which contexts 1: n users are assigned to?

     Table:  agr_1250

2.  Which users are assigned to 1: n ACM contexts?

       " Get the Authorization from table UST12 : User Master Authorizations

      " Get Authorization data for the Activity group : Table AGR_1250

      " Assignment of roles to users : Table  agr_users

Could you please suggest me any bapi or tables for following points.

1. Which documents are assigned to 1: n ACM CONTEXTS?

     for example : DMS document (CV03N)

     ACM context : Means Authorization Object

2. To which contexts 1:n document info records are assigned?

Waiting for your valuable reply.

[Former Member]

Hey  Prakash

You need to go to SUIM t code as mentioned by Nishant.

For 1 and 2 you can check in SUIM as shown below it should give you a list of users etc .. in a system assigned to a particular role i.e 1 , 2 of your question ..

Point 3 , 4 are not that clear that is not something you check from roles I guess .. or maybe I am not understanding correctly .

Regards

Vinita

[Former Member]

Thanks Vinita,

See what i did in my requirement .

1.  Which contexts 1: n users are assigned to?

In my program first I get the user data from following BAPI.

CALL FUNCTION 'BAPI_USER_GET_DETAIL'

     EXPORTING

       username       = ls_sel_user-bname

     IMPORTING

       ADDRESS        = ls_ADDRESS

       logondata      = ls_logondata

       islocked       = ls_islocked

       admindata      = ls_admindata

     TABLES

       activitygroups = lt_activitygroups

       return         = lt_return.

In lt_activitygroups tables I got the role name for particular user .

table AGR_1250 gives me the Authorization Object but i want all the details i.e authorization is active or not .

Could you please suggest me any bapi or tables for the same .

Thanks and Regards,

Prakash

[nishantbansal91]

Hi,

For the activation there is one DELETED field in the same table.

Please check.

[Former Member]

Hi Prakash

Did you check these below and see if it helps ?

Report RSUSR070 or TX S_BCE_68001425

AGR_USERS Table

AGR_1016

You may want to do hit and trial to see if any of these work trying first with AGR_USERS which should work for you

Regards

Vinita

[nishantbansal91]

Hi Prakash,

Please check suim t-code.

Thanks

Nishant

[Former Member]

Thanks for quick reply

but i need a table relation.

Thanks and Regards,

Prakash