topic report run date in Application Development and Automation Discussions

report run date

madan_ullasa — Tue, 01 Aug 2006 11:11:34 GMT

hi frnds,

is there a way to get the last run date and time of a report?

poitns assured to all the replies..

regards,

Madan..

Re: report run date

Former Member — Tue, 01 Aug 2006 11:13:00 GMT

v can query the Table TVAVRV as follows:

select single low
from tvarv into last_date
where name = 'LAST_RUN_DATE_END'
and type = 'P' "variable
and numb = 0. "variable

* Assign last run date to variable 
last_date_end = last_date."variable

* update the run date in TVARV table
clear tvarv.
move 'LAST_RUN_DATE_END' to tvarv-name.
move 'P' to tvarv-type.
move 0 to tvarv-numb.
move sy-datum to tvarv-low.
modify tvarv.

Re: report run date

former_member183804 — Tue, 01 Aug 2006 11:20:41 GMT

Hello Madan,

the SAP system does not store a timestamp of the last execution by default.

I assume the Coverage Analyser (SCOV) / Release 6.40+ may store such an information.

Best Regards

Klaus

Re: report run date

ferry_lianto — Tue, 01 Aug 2006 11:25:23 GMT

Hi Madan,

You could use transaction STAT to find out, but the information you will get depends on the number of statistical records kept (probably only a limited number of time...).

Also you can check this thread as well.

Regards,

Ferry Lianto

Re: report run date

former_member183804 — Tue, 01 Aug 2006 11:40:52 GMT

I have checked SCOV meanwhile. I found no trace of the last exec timestamp. It seems like I was wrong in my assumption.

Sorry

Klaus