2008 Jul 02 1:22 AM
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
2008 Jul 02 1:24 AM
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
2008 Jul 02 1:24 AM
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.
2008 Jul 02 2:45 AM
Hi Kevin
I was interested in Tables not the tcode with ST05
Thanks for your help
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |