When was the last time that a transaction code executed?

[Former Member]

Hi guys!

Could some one tell me please, how could I know (report, table or transaction..) the last time that a transaction was executed? We need to block some transactions that could be obsolate, but before we need to know if there are any user still using them.

I tried with STAT, STAD, but is not exactly what I need... and I don't know how to get the file that it is suppost to get by report RSSTAT20...

Thank you in advance for your help!!

Kind regards,

Carolina

[Former Member]

Hello

[Former Member]

ST03N. But it entirely depends on how your basis set this, in my client, it is set up for one year so it is good enough to be used to identify unused transaction. In the end, I create custom program based on ST03n logic because we need some advance functionality that ST03N could not provided.

Regards,

Abraham

[Former Member]

hi carolina,

check table TRDIR, give your program name and get the data for the last time execution.

thanks

Sachin

[Former Member]

Dear Sachin,

Thank your for your help! but I have done what you suggest me, and I have no way to know the last time a program was execute, is it TRDIR-SDATE the right date? I don't think so, because I have just execute a program and this field has not been updated...so wich is the right table were you can know the last time a transaction code / program was used/executed???

Thank a lot!!!

Kind regards,

Caroline

[ThomasZloch]

TRDIR doesn't work like this. There is no single table giving you the answer you need.

I also suggest you analyze ST03N monthly aggregates. You could lock transactions that don't show up there, and always unlock later once complaints are coming in.

Thomas

[Former Member]

How can I select the rang dates in ST03N? I don't find the field to do the selection...

Thanks again!

[ThomasZloch]

There is a navigation area on the left. In the upper half, open "Total" and doubleclick on a desired period. Then select "transaction profile" and "standard" in the bottom half.

Table FRUN is only good for a few FI related reports.

Thomas

[Former Member]

Thank you very much, I think you are right and the best way is to use ST03N, even if it is no very intuitive to get the information...

Thank you very much for your help !!!

Have a nice day!

Carolina

[Former Member]

Hi Carolina

Check table FRUN

Hope it solved your problem.

regards

Sachin Sharma

[Former Member]

Thanks, but in my sistem this table only has one entry...