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: 

Get relationship of roles (composite/single) remotely

JRunge
Discoverer
0 Kudos

Hello,

We have to analyze the structure of composite and single roles externally (via Java - JCo middleware). Is there a simple way - without changing the R/3 system (i. e. remote RFC modules) - to extract the relationship information of composite and single roles? In which tables is the information stored? I would need this information for non-CUA and for CUA environment.

Thanks for your help.

Kind regards,

Jens Runge

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Jens, you can query AGR_AGRS to get the composite:single role relationship.

From memory this applies for non-CUA and CUA systems.

3 REPLIES 3

Former Member
0 Kudos

Hi Jens, you can query AGR_AGRS to get the composite:single role relationship.

From memory this applies for non-CUA and CUA systems.

Former Member
0 Kudos

What you are looking for is COLL_ACTGROUPS_GET_ACTGROUPS (List of singles to a composite) and COLL_ACTGROUPS_GET_TOP_AGR (where-used-list of singles in a list of composites.

They are remote enabled but not officially released, however SAP has't made changes to them in the past 10 years....

Cheers,

Julius

Former Member
0 Kudos

Hi if you need to do this from a NON-CUA system to all other systems in your landscape go to transaction PFCG

1. Transaction PFCG

2. Perform mass import of roles from other systems to the reference system( or the system you wish to do this analysis)

3.Click on role tab on the main menu , choose read from other system by RFC

4. Then You can enter either an RFC destination

or a variable which points to an RFC destination as target system

(Define variables in transaction SM30_SSM_RFC).

5. Now you can follow the instruction as per other Experts instruction ( AGR_AGR ) table

Follow the above steps if you need to do this for various other SAP systems.

Basically you are getting all the roles to one central place

secondly an RFC connection with necessary authorization is required between each of the systems you are trying to analyze

Edited by: Franklin Jayasim on Jul 14, 2010 6:54 PM

Edited by: Franklin Jayasim on Jul 14, 2010 7:15 PM