07-14-2010 1:48 PM
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
07-14-2010 2:23 PM
Hi Jens, you can query AGR_AGRS to get the composite:single role relationship.
From memory this applies for non-CUA and CUA systems.
07-14-2010 2:23 PM
Hi Jens, you can query AGR_AGRS to get the composite:single role relationship.
From memory this applies for non-CUA and CUA systems.
07-14-2010 3:30 PM
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
07-14-2010 5:22 PM
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