topic Re : User related Database table in Application Development and Automation Discussions

Re : User related Database table

Former Member — Thu, 26 Feb 2009 12:52:36 GMT

Hi,

Can anybody tell me which database table is to store all the Users data along with date details??

My Requirement is to Develop a Function module Which takes Input as Date for that i Want to display all the Users who were log in into SAP on that Particular Date.

Re: Re : User related Database table

Former Member — Thu, 26 Feb 2009 12:58:05 GMT

Hi,

check table PA0002.

Regards,

jaya

Re: Re : User related Database table

Former Member — Thu, 26 Feb 2009 13:05:50 GMT

Hello

Only last logon date are store in tables.

USR02-TRDAT

Re: Re : User related Database table

Former Member — Fri, 27 Feb 2009 04:28:05 GMT

USR02 TAble

also check this thread

hope it helps you.

thanks

SAchin

Re: Re : User related Database table

Former Member — Fri, 27 Feb 2009 09:30:46 GMT

Hello Venkat,

The table USR02 saves the logon data of the users. USR02-BNAME gives you the the user name, TRDAT- the last logon date and LTIME, the last logon time.

Hope this data helps you.

Regards,

Shiny