topic Re: USER Detail Table in Application Development and Automation Discussions

USER Detail Table

Former Member — Wed, 31 Jan 2007 10:03:28 GMT

Hi Gurus,

I got a requirement to find out the user's

1)time logged into SAP

2)time logged out of SAP

3)transaction executed and time of execution

could you tell me the table where user's details will be stored.So that i cud get login time,logout time,transaction executed and time of execution.

orelse anyother process is there to find the above fields...

Regards ,

ashok

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:04:30 GMT

usr02

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:05:03 GMT

Hi Ashok,

Sm04 transaction gives you almost the same information.

Regards,

Ravi

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:09:24 GMT

Search for tables with usr*

For logoin data table is USR02.

Please reward if useful.

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:17:28 GMT

Hi Ravi,

Your answer is not giving a solution for my problem.

My requirement is that to get all the logon time , date,and the list of transactions

which are executed by the user that within a Data Range...

I need someother solution to get the list of transactions

which are executed by the user ...The input for my requirement is Date Range.....

Regards,

ashok ..

Re: USER Detail Table

RaymondGiuseppi — Wed, 31 Jan 2007 10:20:59 GMT

Data is in Cluster table MONI.

You will need FM APWL_STATREC_READ_FILE

(with date selection)

Results for you are in table parameter v2_normal_records.

Regards.

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:24:45 GMT

Did u checked transaction STAT for the transactions used by the user in the given date range .

also check STAD

regards,

vijay

Re: USER Detail Table

p291102 — Wed, 31 Jan 2007 10:29:39 GMT

Hi,

Using through the transaction SM50 u can access the process overview of the particular server which u r using and used by the no.of other users also u can get the detail.

Thanks,

Shankar

Re: USER Detail Table

Former Member — Wed, 31 Jan 2007 10:43:37 GMT

Check the transaction STAT, this provides you a statistic about the user

Rgds,