02-23-2009 9:05 AM
Hi All,
We want a report as the following:
_______________________________________________________________________
Name of Parent Role Name of Child role Assing to the user Plant code B.Area
_______________________________________________________________________
can anybody suggest the ways to achieve this.
I think we need to join some tables in SQVI.
Kindly clarify us on the tables where the above information will be held for the SAP system.
Thanks & Regards,
DVRK
02-23-2009 3:32 PM
Hello Rama,
For relation b/w child and parent role use table AGR_DEFINE
For Org lvl values use AGR_1252
For user name use AGR_USERS
Use these three table and create query, this will solve your problem.
Regards,
Surpreet
02-23-2009 3:32 PM
Hello Rama,
For relation b/w child and parent role use table AGR_DEFINE
For Org lvl values use AGR_1252
For user name use AGR_USERS
Use these three table and create query, this will solve your problem.
Regards,
Surpreet
02-26-2009 4:41 PM