cancel
Showing results for 
Search instead for 
Did you mean: 

how to find the last run date of the report..

Former Member
0 Kudos

please any one one help me

how to find last run date of the report...

for example if my report is zgrir...if i am exuted in last week

if want to find when it executed

last run date is req

please any one help me...

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

Sorry i mean the table name is TVARV

sbhutani1
Contributor
0 Kudos

Hi

You can also use the tcode STAT and then give your program name and user name if you know otherwise use * in user name and execute it will show you all the details

Regards

Sumit Bhutani

Former Member
0 Kudos

Hi Raja,

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

Likewise u can also get last run time by using extra variables to store time vals.

Hope this helps. Award points if u find it so.

regds

Harikumar

sbhutani1
Contributor
0 Kudos

Hi raja,

Table is TRDIR

rahulkavuri
Active Contributor
0 Kudos

hi please goto SM12 to find this

Former Member
0 Kudos

Hi,

refer this thread

rgds,

latheesh

sbhutani1
Contributor
0 Kudos

Hi raja,

You can find these information in table TRDIF.

or you can refer to same thread

Ps reward points if helpful

Regards

Sumit Bhutani

Former Member
0 Kudos

The trasaction stat is limited because i want all the execution date even if it is 3 years ago.

I have tryied the transaction st03 but it is limited to 3 months ago.

check transaction STAT and it's report RSSTAT00.

U can copy RSSTAT00 into ZRSSTAT00 and modify corresponding.

&----


*& Report ZDSAP *

&----


REPORT ZDSAP .

DATA: d_ref TYPE REF TO data,

d_ref2 TYPE REF TO data ,

i_alv_cat TYPE TABLE OF lvc_s_fcat,

ls_alv_cat LIKE LINE OF i_alv_cat.

TYPES tabname LIKE dcobjdef-name .

parameter: p_tablen type tabname.

data: begin of itab occurs 0.

INCLUDE STRUCTURE dntab.

data: end of itab.

FIELD-SYMBOLS : <F_FS> TYPE table,

<F_FS1> TYPE TABLE,

<F_FS2> TYPE ANY,

<F_FS3> TYPE TABLE.

REFRESH itab.

CALL FUNCTION 'NAMETAB_GET'

EXPORTING

langu = sy-langu

tabname = p_tablen

TABLES

nametab = itab

EXCEPTIONS

no_texts_found = 1.

LOOP AT itab .

ls_alv_cat-fieldname = itab-fieldname.

ls_alv_cat-ref_table = p_tablen.

ls_alv_cat-ref_field = itab-fieldname.

APPEND ls_alv_cat TO i_alv_cat.

ENDLOOP.

  • internal table build

CALL METHOD cl_alv_table_create=>create_dynamic_table

EXPORTING it_fieldcatalog = i_alv_cat

IMPORTING ep_table = d_ref .

ASSIGN d_ref->* TO <F_FS>.

SELECT * FROM (p_tablen) INTO CORRESPONDING FIELDS OF TABLE <F_FS>.

LOOP AT <F_FS> ASSIGNING <F_FS2>.

*your code goes here.

ENDLOOP.

Former Member
0 Kudos

thanx for the reply.

please tell me whta should i write as table name and also wht code should i write.

i m new to abap.. please provide me the complete coding..

its urgent.