Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check Transaction done by User through table or function module

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

Hello Sunit,

You could get a help in table USR02.

regards,

Deepti

0 Kudos

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.

Former Member
0 Kudos

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

raymond_giuseppi
Active Contributor
0 Kudos

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.