Application Development and Automation 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: 
Read only

report run date

madan_ullasa
Contributor
0 Likes
1,840

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
Read only

Former Member
0 Likes
666
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
Read only

Former Member
0 Likes
667
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.
Read only

former_member183804
Active Contributor
0 Likes
666

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

Read only

0 Likes
666

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

Read only

ferry_lianto
Active Contributor
0 Likes
666

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