Skip to Content
avatar image
Former Member

SAP User login time and Transaction History

Dear Experts,

I am looking for your advice to get the user transaction history and frequency of login's or number of login per day or a week , Our customer wants this report on daily basis so that they can check how many users are frequently using and how many are not using. I had a look at the forums and found some older posts, they talk about using SUIM and activating system audit and checking ST03. Our customer uses a Third party application ACL Audit to get this data from SAP , as you know from ACL you get data from the SAP tables rather than executing ABAP Programes .

I would like to ask you if any one has done this scenario ? What are the tables that can give us the data on User login's and transaction history .

Please Help

Thanks,

Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 11, 2010 at 07:48 PM

    > ... you get data from the SAP tables rather than executing ABAP Programes .

    This is a clear indication that you have not even read the programs, though they are not easy to understand.

    For a taste of things to come see this flamewar:

    For some of the "transactions" you can take a look at the application logs in the update FM's as you seem not to have done that yet.

    But the basic answer is no. There is no meaningfull nor reliable way to do this via a table directly, let alone a single one.

    If you must have this data in an external DB, then the best solution is to use stable APIs for the SM20 and SM21 data. Report RSAU_READ_AUDITLOG_EXTERNAL will help you further to find the BAPI "return table".

    SM20 is also the correct source. The ST03 data is not the correct source nor reliable.

    Cheers,

    Julius

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      All of this data is obtainable. Transaction STAD is a good starting point, this can show a report for users log ins and which transactions were run.

      There are free tools out there (CSI STAD extractor database) which you can use to economically extract and make sense of this data. It is both reliable and easily formatted for consumption.