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

User Logon history

Hi All. Does anyone know of a table or a function module that gives the logon history for a user? Table USR02 shows the last time a user logged on, but not any of the times before that. Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2006 at 03:42 PM

    HI Sherry,

    Check all USR* tables...

    Regards,

    Santosh

    Message was edited by: Santosh Kumar P

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2006 at 03:49 PM

    Hi Sherry,

    I doubt if such a table exist.

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2006 at 03:51 PM

    Hi,

    Check this table : USH02

    USH02 Change history for logon data

    Regards

    Appana

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2006 at 03:57 PM

    STAT

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi sherry,

      The point is, if you want to know anything from a log on then some custom program around stat is the way. So start harrassing someone to grant you authorization for it.

      But do you really really need al this info?

      Most of the times, instead of cleaning up the mess at a later time, it's always better to prevent it. This authorization profiles of much higher quality.

      That accompanied by some daily checks ( for instance, in sm21 you can see if a user has changed a field value during debug mode), should be sufficient.

      Kind regards, Rob Dielemans

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2006 at 04:24 PM

    Hi Sherry,

    Check this link if it helps

    http://help.sap.com/saphelp_nw04s/helpdata/en/1e/478f40f3b19920e10000000a1550b0/content.htm

    try transaction RSUSR200

    Cheers

    VJ

    If it helps dont forget to reward points

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2006 at 03:53 PM

    Hi Sherry,

    USe BAPIS there are very useful BAPIS to get the user's info.

    BAPI_USER_CHANGE               Change User                                                               
     
    BAPI_USER_CLONE                Create User with Template in Another System                               
     
    BAPI_USER_CREATE               Create a User                                                             
     
    BAPI_USER_CREATE1              Create a User                                                             
     
    BAPI_USER_DELETE               BAPI to Delete a User                                                     
     
    BAPI_USER_DISPLAY              Display users                                                             
     
    BAPI_USER_EXISTENCE_CHECK      Check a user exists                                                       
     
    BAPI_USER_GET_DETAIL           Read User Details                                                         
     
    BAPI_USER_LOCACTGROUPS_ASSIGN  Change Activity Group Assignment for Dependent Systems from Central System
     
    BAPI_USER_LOCACTGROUPS_DELETE  Delete Activity Group Assignments in the Dependent Systems                
     
    BAPI_USER_LOCK                 Lock User                                                                 
     
    BAPI_USER_LOCPROFILES_ASSIGN   Change Profile Assignment for Dependent Systems from Central System       
     
    BAPI_USER_LOCPROFILES_DELETE   Delete Profile Assignments for Dependent Systems                          
     
    BAPI_USER_PROFILES_ASSIGN      User: Assign profiles                                                     
     
    BAPI_USER_PROFILES_DELETE      User: Delete All Profile Assignments                                      
     
    BAPI_USER_UNLOCK               Unlock user                                       
     
    

    Cheers

    VJ

    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.