Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Role Maintenace Table in T code PFCG

Former Member
0 Likes
1,786

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
984

Instead of giving you the fish, why don't I teach you how to fish?

Run ST05 for your user.

Repeat the steps you mentioned above.

Run ST05, stop trace, display trace.

Summarize trace by table.

Aggregate.

Look through the list of tables (shouldn't be that large), and you will find what you are looking for there.

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

2 REPLIES 2
Read only

Former Member
0 Likes
985

Instead of giving you the fish, why don't I teach you how to fish?

Run ST05 for your user.

Repeat the steps you mentioned above.

Run ST05, stop trace, display trace.

Summarize trace by table.

Aggregate.

Look through the list of tables (shouldn't be that large), and you will find what you are looking for there.

Read only

Former Member
0 Likes
984

Hi Kevin

I was interested in Tables not the tcode with ST05

Thanks for your help