08-01-2006 12:11 PM
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..
08-01-2006 12:13 PM
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.
08-01-2006 12:13 PM
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.
08-01-2006 12:20 PM
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
08-01-2006 12:40 PM
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
08-01-2006 12:25 PM