Display users with authorization objects assigened to them

[Former Member]

Hi,

How can I display list of users with company code assigned to them?

[Former Member]

Hi Rajesh

Got this info from one of the threads ,see if this helps:

Have a look in the AGR Tabels.

TC SE16 -> AGR*

[Former Member]

Hi,

you can find using transaction suim.

--> users by complex selection criteria

-

---

>by authorization values

-

---

> Enter authorization object "F_BKPF_BUK "

-

---

>press enter and enter company code

execute ... you will find the users

Regards

Ben

[Former Member]

Hi ben,

I would like to display the list of users along with company codes assigned to them. Using options provided by you I can see list of user not company codes.

Can you suggest any other option.

With Regards,

Rajesh Kale

[Former Member]

hello Rajesh,

What you want is not straightforward. There is no SAP report for this as such. You need to find roles assigned to the user first then go to table agr_1252 anf give the value $BUKRS along with the role names.

You will find out the company codes assigned to the user.

This is not a very efficient way really and will involve too much of effort. If I needed such an information I would have written a simple ABAP report using joins of table AR_DEFINE and AGR_1252. Also check tables UST12 and AGR_1251.

Hi Ben,

Company code is present in several authorization objects other than F_BKPF_BUK. Check F_SKA1_BUK..There are several of them. So we need to check on basis of field BUKRS.

Regards.

Ruchit.