Last Password Changed time - Time stamp for password change in R/3

[Former Member]

Hi,

Greetings!!

Can anyone let me know if there are any table field which describes the timestamp or time of last password change for the R/3 system.

Please reply.

Best Regards

Sid

[Former Member]

Hi,

The "Date of last password change" is found in USR02-BCDA1 through USR02-BCDA5. Unfortunately, table USR02 does not contain a timestamp. Table USH02, however, does contain fields with modification date (USH02-MODDA) and modification time (USH02-MODTI). You might be able to link these two tables to get the password change time from USH02-MODTI.

Starting with the USR02 data, you can find the user-id and password change date(s) that you are interested in. Then take the USR02 password change date(s) and search against USH02-MODDA for a given user id.

Example link condition:

USH02-BNAME = USR02-BNAME

USH02-MODDA = USR02-BCDA1

If you are only interested in the last time the user changed their own password, you can include:

USH02-MODBE = USR02-BNAME

USH02-TCODE = 'KRNL'

Note: You cannot use USH02 in a join since it is a pooled table.

Regards,

Jamie

[uwe_schieferstein]

Hello Sid

Calling area menu SUIM you may go to: User -> By Logon Date and Password Change (transaction RSUSR200).

The ALV list displays the date of last PW change but not the time.

Regards

Uwe