Question:
I am trying extract SAP authorizations from the tables for a special project.
I know that table UST04 gives me the userid & profiles assigned.
I know that table UST12 gives me the authorization values per profile.
What I do not know is how to join the two tables. The problem I have when an activity group is broken up into multiple profiles.
Table UST04
User Profile
SMITH AR_COLL___
Table UST12
Authorization Version for field Value
AR_COLL___00 ACTVT 03
AR_COLL___00 BGRKL *
AR_COLL___07 BUKRS 1000
AR_COLL___07 ACTVT 03
AR_COLL___14 APPKZ F
AR_COLL___14 ACTVT 08
I need to some how be table to join the AR_COLL____ profile from UST04 with the AR_COLL___XX authorizations in UST12.
Is there a table that list something like this?
Profile Authorization
AR_COLL___ AR_COLL___00
AR_COLL___ AR_COLL___07
AR_COLL___ AR_COLL___14
Any suggestions how I can join the 2 tables?
What I am trying to extract is the authorization values per user.
Thank you,
VCC
Answer:
THe link you are missing is UST10S and UST10C. Though do note if you have not synced the tavles to the real SAP security(the USR10, 12 and 04) you will get bad information. You are better off using the USRxx tables but you will then have to find the "decypher" code which can be fount in the OPF0 transaction code in th eInformatin->Overview path or the SU02, and SU03 tcodes.
You can also run the SYNC function module via SE37 but the TASKTYPE must be 'X' or nothing happens. The function module name is something like SUSR_SYNC_USER_TABLES