‎2006 Sep 19 7:35 PM
Hi,
We are looking for list of Authorization objects which contain company code field for Audit. The listing should have Role, Authorization obj and the <b>company code and values</b>.
Is there any we can query this info.
Thanks,
Sam
Message was edited by: Sam
‎2006 Sep 19 7:47 PM
Hi Sam,
Assuming you are looking for company code in the roles you have implemented as opposed to all company code in
SAP. Go to SE16 and enter in table AGR_1251. Restrict
to the namespace of your roles and in "field" type in BUKRS. This will give you the listing of roles and auth. objects. For the ORG level values go to table AGR_1252
and select by $BUKRS in field VARBL.
Regards,
JC
‎2006 Sep 19 9:05 PM
Thanks JC.. It worked.. How to identify the table name for this issue?
-Sam
‎2006 Sep 19 10:14 PM
The table description for AGR_1251 is "Authorization data for the activity group".
‎2006 Sep 19 10:34 PM
Thanks JC.. Could you please confirm if this table is good and exhaustive for Version 4.6B ?
Thanks,
Sam
‎2006 Sep 19 10:46 PM
It should be as long as all of the roles you are using are created in profile generator. Otherwise, if there
are profiles go to table UST12 and select BUKRS in "field". This will give you the authorization objects
for these values - then you'll have to map back to
the profiles via table UST10S
‎2006 Sep 20 12:37 PM
Hi,
You can use the follwing
in USR12 table
in USOBT table (but you get the details for the Auth Obj in the Tcodes and their field values.
But as far as my knowledge goes you will get all the Auth Obj with Company code field
Caution: If there are some objects in not check or are which are not in any tcodes then they will not be captured.
But they are very less I guess and so i think you can capture most of the Auth Obj I guess
Message was edited by: Manohar Kappala