- SAP Managed Tags
Hi Experts
I have Client requirement they need a report which will tell user-wise plant authorization and that plant in which which transaction codes, please suggest the table and field name. it is urgent. its output have to look look this..
Regards.
Jitendra.
Moderator message: no "spec dumping" please, and no "urgent" as well.
Message was edited by: Thomas Zloch
- SAP Managed Tags
Look at following tables for authorization/role database
AGR_1016 | Name of the activity group profile |
AGR_1250 | Authorization data for the activity group |
AGR_1251 | Authorization data for the activity group |
AGR_1252 | Organizational elements for authorizations |
AGR_AGRS | Roles in Composite Roles |
AGR_ATTS | Role attributes |
AGR_BUFFI | Internet Links for a Role |
AGR_CUSTOM | Role Customizing objects |
AGR_DATEU | Personal settings for roles |
AGR_DEFINE | Role definition |
AGR_FLAGS | Role attributes |
AGR_FLAGSB | Role attributes |
AGR_HIER | Table for Structure Information for Menu |
AGR_HIER_BOR | Table for Object-Oriented Navigation (OBN) |
AGR_HIERT | Role menu texts |
AGR_HPAGE | Role Home Page |
AGR_MAPP | MiniApps in Role |
AGR_PROF | Profile name for role |
AGR_TCODES | Assignment of roles to Tcodes |
AGR_TEXTS | File Structure for Hierarchical Menu - Customer |
AGR_TIME | Time Stamp for Role (Menu, Profile, Authorizations) |
AGR_TIMEB | Time Stamp for Role (Profile Generation) |
AGR_TIMEC | Time Stamp for Role (User Assignment) |
AGR_TIMED | Time Stamp for Role (Profile Comparison, RFC Distribution) |
AGR_USERS | Assignment of roles to users |
And for relations between transaction and authorization
USOBT | Relation transaction > authorization object |
USOBX | Check table for table USOBT |
USOB_AUTHVALTRC | Authorization Trace Result: Objects and Values |
USOB_SM | Control Table SU22: Auth. Obj. Maint. for Transact./Service |
USORG_DB | Generated Table for View USORG_DB |
Regards,
Raymond
Bluesky
