10 Replies Latest reply: Jun 25, 2008 10:39 AM by ben leen lee RSS

user login with details

ben leen lee
Currently Being Moderated

hi guys,

 

was need to come out a report for the user login details. which has to have the date and time of the user login to SAP, with the terminal ID access from and transaction has done. can any one tell me what table it is from? or is there existing report that i can view all this? thanks

  • Re: user login with details
    Richa Gupta
    Currently Being Moderated

    Execute transaction SM04.

     

    Reward if useful.

  • Re: user login with details
    Kesavadas Thekkillath
    Currently Being Moderated

    USe table USR02...Everything is there

  • Re: user login with details
    Sriram Ponna
    Currently Being Moderated

    Hi,

     

    Pls refer USR02 table.

     

    Thanks,

    Sriram Ponna.

  • Re: user login with details
    sravanthi chilal
    Currently Being Moderated

    hi,

     

    you can find the transactions by a particular user from the transaction SM04.

     

    SM04 gives you the details of the users logged in,terminals,transactions the user is working on, the time he has logged in,no of sessions user has opened, and the memory used by the user's programs... all of that w.r.t to the client we login. but we can't get info like date and number of times the user has logged in.

     

    U can see tables:

    USR01 User master record (runtime data)

    USR02 Logon data

    USR03 User address data

    USR05 User Master Parameter ID

    USR12 User master authorization values

     

    You can also use transaction code ST03N.

     

    1. Go to tx code - ST03N

    2. Under "Workload" you can select your "Instance or Total" so that it expands and shows you Days, Week, Month.

    3. If you want to look at the transactions executed for a particular day, lets say, then double click on any day.

    4. At the bottom left you get "Analysis Views"

    5. Select & expand "User and Settlement Statistics"

    6. Double click on "User Profile"

    7. On the right side of the window you get a list of all the users

    8. Double click on a particular user you want to view the details of.

    9. The new screen will display the "Transactions/Reports Utilized by User XXX"

     

    If you want to track which users executed a particular transacation then follow this:

     

    10. In "Analysis Views" expand "Transaction Profile"

    11. Double click on "Standard"

    You can view the list of Transactions and Reports.

    12. Double click on the Tx Code or Report you wanna check and it will show the Use of it.

     

    hope this is helpful

     

    regards,

    sravanthi

  • Re: user login with details
    Anirban Bhattacharjee
    Currently Being Moderated

    hi,

     

    go to USR02 table. it will give all your requirment.

     

    Reward if find helpful.

     

    Anirban Bhattacharjee

  • Re: user login with details
    dilip kumar
    Currently Being Moderated

    hi ,

     

    use these table

    USR01 User master record (runtime data)

    USR02 Logon data

    USR03 User address data

    USR05 User Master Parameter ID

    USR12 User master authorization values

     

    regards,

    dilip

  • Re: user login with details
    Sumit Agarwal
    Currently Being Moderated

    hi,

    u can refer table USR02 for your Report.The details you have mentioned in your query are avaliable in the table.

    For any Master Record of a Particular User refer to table USR01.

     

    reward if useful

     

    regards

    Sumit Agarwal

    • Re: user login with details
      ben leen lee
      Currently Being Moderated

      hi All,

       

      but i need the data to be select by dates, which is,

      to display the user ID login using which work station(terminal ID), access what transaction code, or what process on selection date. the date can be any time for selection.

       

      i need it because have to trace who and when a person done some thing.

       

      SM04 only provide me instant access, and ST03N i was unable to find the terminal ID to be show in it.

  • Re: user login with details
    Sumit Agarwal
    Currently Being Moderated

    hi

    in USR02 you have fields which gives you the logon date and last logon time of the person. Also u find the values of password changes.

     

    You will find Host No and other host related info from USR01.

     

    hope this will help.

     

    reward if helpful.

     

    Regards

    Sumit Agarwal

Actions