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: 

report run date

madan_ullasa
Contributor
0 Kudos

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..

1 ACCEPTED SOLUTION

Former Member
0 Kudos
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.
4 REPLIES 4

Former Member
0 Kudos
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.

former_member183804
Active Contributor
0 Kudos

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

0 Kudos

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

ferry_lianto
Active Contributor
0 Kudos

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