User Wise Authorization/profile report needed

[Former Member]

Hi Gurus,

I need a Report where in Input screen user name is provided & in the output I required User wise

Profile , Authorization & transaaction code assigned to this user .

can i get similar type of Report developed by some of the gurus .

Is there any BAPI is availavle for this .

Thanks & regards.

Kiro

[Former Member]

Hello,

You can use following tables and write custom report:

1. USR02 --> User Name

2. AGR_USERS --> User Name & Role Name

3. AGR_TCODES --> Role Name & Transaction Code

4. AGR_PROF --> Role Name & Profile Name

Also,

5. AGR_DEFINE --> For more detail role information

Hope this will resolve your issue!

Thanks,

Augustin.

[Former Member]

Hi Kiro,

Check the T-Code SUIM (User Information System).

Regards

Bala

[Former Member]

HI ,

just check FM

AUTHORIZATION_DATA_COMPARE

AUTHORIZATION_DATA_READ_RFC

AUTHORIZATION_DATA_READ_SELOBJ

[GauthamV]

Use this program.

RSUSR010

[Former Member]

Hello,

You can use the transaction SUIM.

or the BAPI " BAPI_USER_GET_DETAIL"

Thanks,

Anju

[Former Member]

Hello,

You can use following tables and write custom report:

1. USR02 --> User Name

2. AGR_USERS --> User Name & Role Name

3. AGR_TCODES --> Role Name & Transaction Code

4. AGR_PROF --> Role Name & Profile Name

Also,

5. AGR_DEFINE --> For more detail role information

Hope this will resolve your issue!

Thanks,

Augustin.

[Former Member]

Thanks for the Answer.

Need 1 more Info..

In which table SAP Objects are stores .

[Former Member]

Hello Kiro,

You can trace down table for any SAP object by pressing F1 (help) and selecting technical information.

you will either get value table in data element --> data domian or it will directly give you transparent table name.

For example:

For table objects we can locate them in table DD02L and DD03L.

In same way you can try for other object like reports, function modules etc.

Hope this helps!

Thanks,

Augustin.

[Former Member]

Hi ,

Hi All,

In which table SAP Objets ( which is created while defining Role & profile ) are stored.

This should be in some relationship with the table Usr02, agr_users,agr_tcodes,agr_prof.

Thanks

[former_member230215]

Use this BAPI_USER_GET_DETAIL to get all user details.