What is the T-code used to fetch some table data from user table & some data from roles table??

[Former Member]

What is the T-code used to fetch some table data from user table & some data from roles table??

Please help..

Regards,

Venki

[surya_appala]

Hi Venkatesh,

Please be specific with your requirement. Unable to understand "some".

If you are looking for role vs user relationship, you may please make use of AGR_USERS table.

Please let me know if you have any questions.

Regards,

Surya

[Former Member]

Hi Surya,

My apologies that I was not specific, let me try to rephrase my question,

Is there a t-code using which we can pull tables from both user table & role table as a combination (like a one single table).

Regards,

Venki

[Colleen]

Venki

which tables and which fields are you trying to get in a report?

Have you looked in to SUIM standard security reports to see if they meet your requirements?

[Former Member]

Hi Colleen,

Honestly I did not look in to SUIM standard security reports,I think it will fullfill my requirement( It might sound stupid but) am wondering for suppose if I need a report comprising of roles, profile data & T-codes & users is there a way other than using the standard reporting tables??

I mean is there an alternative way ?

Regards,

Venki

[Jelena]

SUIM works perfectly fine for the user/role reporting needs, why would you require an alternative? Would you also look for an alternative to breathing, for example? I guess there is a ventilator machine, but it ain't any better...

Kindly do some search before posting, post more specific questions going forward and close this discussion if the question has been answered. You might want to refer to these blogs:

http://scn.sap.com/community/getting-started/blog/2010/05/12/asking-good-questions-in-the-forums-to-...

http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why

[Colleen]

Hi Venki

Before you start thinking about tools and approaches to extract data you really need to think through you report requirements and design them out.

At the moment your desire it too generic. Even if SE16 with scripts and extracts or custom code, etc there are still a heap of tables involved.

Start with your specifics: what are you trying to report on? Break your scenarios down into the different reports you actually need. After that, see what SUIM has to offer and then look at the gaps.

Regards

Colleen