Skip to Content
avatar image
Former Member

Get relationship of roles (composite/single) remotely

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 14, 2010 at 01: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2010 at 02: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2010 at 04: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

    Add comment
    10|10000 characters needed characters exceeded