Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to get the history of Transaction

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

10 REPLIES 10

Former Member
0 Kudos

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

0 Kudos

Hello Zaheer,

Can you describe it little bit more.

can we get the information or log transaction vice like which transaction has executed when and at what time and by whic user..

can we get such information from SAP system.

Regards,

Bhavesh

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

Hello Dipesh,

In St03 i am able to see the total transactions have executed in the systems and their another details but i am unable to find out that which transaction has run when on which date and at which time.

Is there any mechenism to find out this information transaction vice.

and can you tell me how to activate audit logs from SM19..

REgards,

Bhavesh

0 Kudos

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

--Dipesh

0 Kudos

>

> 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

Former Member
0 Kudos

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

0 Kudos

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.

Former Member
0 Kudos

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