12-10-2012 11:04 AM
Hi,
I have a requirement, in which in need to show the last 10days transaction history of the user and also I need to get the password expiration date, I got Last login date but the expiration date parameter i didn't got it.
The above requirement is to be shown in a report so i need some table or fm or some reference to get it.
Can anybody help me on this.
Thanks and Regards,
Sunil
12-10-2012 11:54 AM
12-10-2012 12:20 PM
Hi Deepti,
From that table only i got the field PWDCHGDATE which gives last password change date, but I want date of password expiry either in terms of number of days(30days as b) or the exact date and I am also searching for user transaction histroy(table or FM) like ST03.
12-10-2012 12:37 PM
Hi,
from SAP basis perspective, there is no need for a persistent database table where the expiration date is stored. The password behavior is defined in kernel profile parameter.
go to transaction RZ11 and use parameter
login/password_expiration_time
All these stuff with login/* in RZ11 are relevant for password handling.
You may also check the reports to evaluate user login behaviour like RSUSR200.
Hope this gives you some new ideas where to look further.
Regards,
Matthias
12-10-2012 12:37 PM
You could
- From USR02 you got last change of password, then read system profile to get rules of expiration (*)
- Take a look at FM like SWNC_STAD_READ_STATRECS to get history of user
To fulfill your requirement, first execute transaction SUIM and look for a report similar to your request, then analyze the source or use a tool like SE30/SAT to analyze the FM called and DB read (hints: like form get_pw_system_settings of report RSUSR200 or similar reports)
Regards,
Raymond
(*) Like login/password_max_new_valid for new users, login/password_max_reset_valid for changed password, login, password_max_idle_initial for initial password by administrator, login/password_max_idle_productive for password changed by user, etc.