Role Maintenace Table

[Former Member]

Hi Experts

I want to developed a report for Auditors. They need to see for each users what is the organization level assign .

1. Go to PFCG->Enter Role name zwa_xyz

2. Click Authorization -> click Change Authorization Data -> Organization Level tap button

You can see all the Org Levl From To is defined , I want to know which tables are these information store and if so what tables I have to select so that I should get the above information for each users individually

User Name

Role Name

-

---

Organization levels

Company Code FROM TO -all the information

Purchasing Group xxxxx 67

Sales Organization xxxxx *

Plant xxxxxx *

Regards

Piroz

[pole_li]

Hi,

You can check table AGR_1252 for Organizational elements of authorizations.

table AGR_USERS for Assignment of roles to users.

Regards,

Pole

Edited by: Pole li on Jul 2, 2008 3:33 AM

[Former Member]

Thanks Mate

Excellent , for your reply it works

Regards

Piroz

[Former Member]

Hi

In table AGR_1252 where can I find all the description for the following

VARBL AND LOW field

Rgds

Piroz

[Former Member]

Yes

Thread closed

[Former Member]

Thread closed

Piroz