topic Re: About Logon DATA in Application Development and Automation Discussions

About Logon DATA

Former Member — Wed, 13 Jun 2007 06:35:37 GMT

hi all,

please give me specific table name to get details of logon information about user.......

means i can see which user logon to the system on specified date and time and which tcode used by user ...........

don't give me any standard program or tcodes ...... just give me table name....

full points will be definitely rewarded for helpful answer...........

Thanks,

Imran

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 06:36:58 GMT

Hi Imran,

Check this link,

Thanks,

Reward If Helpful.

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 06:38:33 GMT

Hi,

Check USR02.

Regards

Bala

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 06:38:59 GMT

Hi,

Tables:

USR01 -- User master record (runtime data)

USR02 -- Logon data

USR04 -- User master authorizations

Regards,

Padmam.

Re: About Logon DATA

S0025444845 — Wed, 13 Jun 2007 06:43:58 GMT

Hi,

You can use TCODE SM04 for this purpose.

regards,

sudha

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 06:44:51 GMT

hi all,

thanks for the reply........

i know all this tables..........this tables only give information about last logon date......

but i want to details as on date....for example....if i m entering yesterday's date....

than i can see which user login on which client,server(prod,dev,quality),terminal id,tcode...

or any of the date.......

Thanks,

Imran

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 06:46:23 GMT

hi all,

please dont give any tcodes......

i just want to table name........

Thanks,

Advance

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 07:12:23 GMT

hi freinds,

please give me table names.............its urgent........

thanks,

Imran

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 07:24:20 GMT

Hi Imara,

I have written code below for get logon user address details .

****get the user personal numnber

select single * from usr21 where bname eq sy-uname.

if sy-subrc eq 0.

Get the user first and last name

select single * from adrp where PERSNUMBER eq usr21-PERSNUMBER.

**** Get the user Telephone numner and extenstion

select single * from adcp where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

Get the user Email address

select single * from adr6 where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

Get the user Fax number

select single * from adr3 where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

endif.

If its useful reward the points

Regards,

D.prabhu

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 07:26:05 GMT

Hi,

Please check Tables USR41 & USERTRACE.

Regards

Bala

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 10:13:59 GMT

hi BALA,

thanks for the reply but table which u have given is giving information based on last logon date............................

i want information as on date..........if i m entering date 01.01.2007

than i can see which user logon on that day....with details which i have specified earlier.

thanks,

Imran

Re: About Logon DATA

Former Member — Wed, 13 Jun 2007 12:28:28 GMT

hi all,

hey freinds still not got the answer............do some help yaar.........

regards,

Imran

Re: About Logon DATA

Former Member — Thu, 14 Jun 2007 08:49:37 GMT

hi all,

i thing there is no such table exist................

thanks to all for reply......

thanks,

Imran

Re: About Logon DATA

Former Member — Mon, 18 Jun 2007 09:57:38 GMT

hi friends,

what happen gurus.......still not got the answer...........

Regards,

Imran