Report showing transactions assigned to users.

[Former Member]

I've tried accessing certain tables and creating aquery with tables like AGR_1251,AGR_USERS,AGR_TCODES to get a report showing transactions assigned to users but the query is still not giving the transaction names.

What's the best way to generate a report showing user name,role and transaction name?

[Former Member]

>

> I've tried accessing certain tables and creating aquery with tables like AGR_1251,AGR_USERS,AGR_TCODES to get a report showing transactions assigned to users but the query is still not giving the transaction names.
> 
> What's the best way to generate a report showing user name,role and transaction name?

Run a search on this forum on SUIM for users & transactions with complex selection criteria.

Edited by: John Navarro on May 13, 2009 6:02 PM

[Former Member]

SUIM didn't give me the results i required that's why i went the way of the SQVI originally

[Former Member]

>

> SUIM didn't give me the results i required that's why i went the way of the SQVI originally

If this is a one time report I will not use SQVI.

I'm assuming you want a report with the following information:

User ID

Role

Transactions

Transaction Names

You are in the right track by using tables AGR_USERS & AGR_1251. Use table TSTC to get the transaction name. You have to do multiple queries and combine it into a report or run SQVI.

Good Luck!

Edited by: John Navarro on May 14, 2009 4:53 PM

[jurjen_heeck]

> SUIM didn't give me the results i required that's why i went the way of the SQVI originally

What did you miss in the suim results?

[Former Member]

Hi Adeel,

Please join only the 2 tables AGR_USERS & AGR_TCODES using SQVI to get the output in the format you are looking for i.e User --> Role Name --> Tcodes.

Make username as the selection field.

Thanks,

Saby..

[jurjen_heeck]

> Please join only the 2 tables AGR_USERS & AGR_TCODES using SQVI to get the output in the format you are looking for i.e User --> Role Name --> Tcodes.

This will only show tcodes present in the role menu(s). Tcodes manually entered into S_TCODE and tcodes brought into the role through SU24 proposals will not show up with this query.

[sdipanjan]

>

> > Please join only the 2 tables AGR_USERS & AGR_TCODES using SQVI to get the output in the format you are looking for i.e User --> Role Name --> Tcodes.
> This will only show tcodes present in the role menu(s). Tcodes manually entered into S_TCODE and tcodes brought into the role through SU24 proposals will not show up with this query.

Yes... this should be captured by AGR_1251 and poutting Field value TCD only as the search criteria.

Regards, Dipanjan