Skip to Content
avatar image
Former Member

how to get the history of Transaction

Hello,

I want to get the history of transaction which have been executed in the SAp system.

can any body help me how can i get the transaction history?

like when did the trasaction was executed last time and at what time.

Regards,

Bhavesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 09, 2009 at 01:34 PM

    You can get the history for a limited period from transaction STAD / STAT, enter the transaction in the selection field and execute.

    Other option is the SM20, audit, in case you have AIS enabled in the system.

    Cheers !!

    Zaheer

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Transaction STAD or STAT (depending on the version of SAP you have) should give you the time when the transaction was executed.

      Once you run STAD -> input the transaction and the client for which you want to see the tcode usage and specify the time limit for which you want to check the trace for. and execute it. And vola... you should have the report that you are looking for.

      Cheers !!

      Zaheer

  • avatar image
    Former Member
    Jul 09, 2009 at 01:51 PM

    You can get the information as mentioned by Zaheer from the transaction SM20 if audit logs are activated for the users through SM19. Also you can use the transaction ST03N ---> Expert Mode ---> Select the Application server ---> Selet the requisite date. Then under Analysis view look for Transaction profile.

    Do let me know if this helps you.

    Dipesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      >

      > Bhavesh,

      >

      > From ST03N , once you select Expert mode and then the SAP Instance, it will display the trees for Day, Week,Month & Total. From here you can choose a particular day or a data range and then from the Analysis view frame open the transaction Profile tree to select standard. This will display the Transactions that were used during this period . If you double click on each transaction, it will show you the users who have used these transactions during this time. But, yes the exact execution timefor these transactions won't be available from ST03N. This can be available from the SM20 Audit Logs.

      >

      > To activate Audit logs you can try the following :

      >

      > Start transaction SM19

      > Select the 'Enable' checkbox in the 'Administrative data' section

      > Select the 'Active' checkbox for the first audit section

      > Select the weight of the events you wish to log -

      > LOW = log all events which are classed as low or above e.g. start

      > transaction

      > HIGH = Only log events which are classified as high e.g. failed logon,

      > transaction start failed, system shutdown/restart etc.

      > Select the activities which you want to log e.g. transaction start

      > activity, logon activity etc

      > Select the client which you want to audit ( * = all clients)

      > Select the user you want to audit ( * = all users )

      > Do the same in the second section if you would like a second audit set up

      > Click on Save

      >

      >

      > Set up the audit log deletion using SM18.

      > Enter the number of days logs which you would like to keep

      >

      > You also need to pay attention to the following parameters:

      > (Display these from SM19 > Environment > Profile parameter on 4.6C.)

      >

      > rsau/enable (must be 1)

      > rsau/local/file

      >

      > rsau/max_diskspace/local

      >

      > rsau/max_diskspace/per_day

      >

      > rsau/max_diskspace/per_file

      > rsau/selection_slots

      >

      > rsau/SQL-Audit/filename

      >

      > rsau/SQL-Audit/filesize

      >

      > rsau/SQL-Audit/logdir

      >

      > rsau/SQL-Audit/switch

      >

      > DIR_AUDIT

      >

      > FN_AUDIT

      >

      >

      Whole effort is useless unless you restart the Application servers. SM20 Audit log is activated only after bouncing the system.

      Regards,

      Dipanjan

  • avatar image
    Former Member
    Jul 13, 2009 at 06:38 AM

    hi

    Use se16 and the following tables:

    USH02 Change history for logon data

    USH04 Change history for authorizations

    USH10 Change history for authorization profiles

    USH12 Change history for authorization values

    hope this helps

    Shitika

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Experts...

      The whole thing does not give what one really wants....in some case it has only 1 week past history only.

      My problem is like this...

      I have a custom transaction (Z*) for which I have to see when was it last executed in a Production System and who executed it.

      Can anyone give me a less complicated way to get this out of SAP?

      Thanks.

  • avatar image
    Former Member
    Aug 02, 2009 at 07:49 AM

    Okay, that´s enough now...

    Thread locked.

    Name:  Abhyankar bhavesh  - View user's Business Card    
    Registered:  Jun 3, 2009  
    Total Posts:  7  
    Total Questions:  3 (3 unresolved)  
    Forum Points:  0  

    Add comment
    10|10000 characters needed characters exceeded