Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Parent and child roles

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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

0 Kudos

Hi,

Thanks a lot.

The three tables gave the required info.

Regards

DVRK