Last login of SAP-user

[Former Member]

Hi there,

I'm looking for the database table and field that contains the date of the last login of an sap-user.

Is there anything like this?

Thanks...

Kind regards

Markus

[former_member181995]

SM04>sort decending wrt to time column.

[GauthamV]

HI,

use this table.

USR02.

fields:

TRDAT

LTIME.

[Former Member]

you can use table usr02 , field LTIME ( Last logon time ) based on user.

[Former Member]

The above may work some of the time (sometimes also unreliably as you may incorrectly interpret the single fields of tables, or SAP might change them, as they have also done), but they are not the intended solution for this.

The correct tool is SM20(N) recording the event "Successfull logon" which will also tell you which "type of logon" it was.

Cheers,

Julius

[Former Member]

Hi,

You can check in this table USR02

Regards

Pavan

[former_member598013]

Hi Markus,

Check out the

FM " ISR_GET_USER_DETAILS " 

It will give you the complete detail of the user Login.

Regards,

Chidanand