Table to view the list of queries accessed by particular user

[Former Member]

Hi,

I need the list of queries accessed by particular user.

I have used RSDDSTAT table, but I am not sure whether I am using the right table.

Please let me know the alternative way.

[Former Member · Accepted solution]

Hi Kusuma,

Look in TFDIR on R/3 side with TA SE11 or SE16

BW function names used as extractor are called BIW mostly, the rest depends on the application area, like HR_BIW_GET_DATA

for module PA (personnel)

Other tables related to BW are ROIS and ROOSOURCE

With Regards,

Lolla.

[Former Member]

hii,do u mean to say that you want ot know the T-Codes accessed or database queries

If T-codes,then ST03N is a nice option

If database queries try using STAD,it might help you

Rohit

[Former Member]

Hi Rohit,

Please let me know the table of function module name, which will provide hint for finding list of BEx reports accessed by particular user.