topic Re: Authorization Object report in Application Development and Automation Discussions

Authorization Object report

Former Member — Thu, 18 Oct 2012 09:34:27 GMT

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

Re: Authorization Object report

Former Member — Thu, 18 Oct 2012 09:39:43 GMT

you need to work on the tables AGR*

AGR_1250

AGR_1251

AGR_1252

AGR_1253

AGR_AGRS

with USR* tables.

Re: Authorization Object report

RaymondGiuseppi — Thu, 18 Oct 2012 10:11:47 GMT

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

Re: Authorization Object report

Former Member — Thu, 18 Oct 2012 10:53:42 GMT

Thank you all for quick respond. but i cant able to solve the problem, please suggest