password reset date and time

[Former Member]

Hi,

In my report i need to pick up all the records for the users whose password is being reset and user did not logged on to the system for 24 hours.

what are the table fields that gives password reset time and date. and a table field that tells that user has logged on and changed the password first time.

[Former Member]

Hi,

Check the Tables,

<b>USR01</b> User master record (run-time data)
<b>USR02</b> Logon data

<b>USR20</b> Date of last user master reorganisation
<b>USR40</b> Table for illegal passwords

Regards,

<b>AS</b>

[dani_mn]

Hi,

in transaction SE11 look for 'USR*'

you fill find all tables related to user information.

Regards,

[dani_mn]

Deleted

[Former Member]

Please check table USR02 and you would be able to get the details about last logon date and time as well as date of last password change.

BNAME - Userid

TRDAT - Last Logon Date

LTIME - Last Logon Time

BCDA1 - Last Password Change Date.

Regards

Anurag

Message was edited by: Anurag Bankley

[Former Member]

Hi Kartikey,

Consider this sample code. Does it suit your requirement.

REPORT  zztest_user                             .

DATA : it_data TYPE STANDARD TABLE OF usr02 WITH  HEADER LINE.

DATA : time TYPE sy-timlo,
       date TYPE sy-datlo.



date =  sy-datlo - 1.     "Password changed in last 24 Hrs
time =  sy-timlo - 24.    "User did not logged on to the system for 24 hours


SELECT * FROM  usr02
       INTO TABLE it_data
       WHERE  ltime       LE time    "Last logon time
       AND    pwdchgdate  GE date.   "Date of last password change

BREAK-POINT.

Regards,

<b>AS</b>