Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2012 at 11:54 AM

    Hello Sunit,

    You could get a help in table USR02.

    regards,

    Deepti

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Posted on Dec 10, 2012 at 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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2012 at 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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.