Last Used status for Reports, Transactions, Tables ??

[former_member190178]

Dear all,

Kindly let me know how to find the last used status for

Reports, Transactions, Tables ??

This is very urgent, Please do the needful.

Waiting for the responses..

Cheers,

Virendra.

[Former Member]

Hi,

Try database tables JEST and TVARV.

Regards

[Former Member]

Hi,

Use the Transaction <b>STAT</b>.

Regards,

<b>AS</b>

[former_member190178]

Thanks for the quick reply.

I have seen transaction STAT before posting the query.

The main problem which i am facing with STAT is that

is require TIME to be specified i.e "from time to time".

But i need a solution as when i input the Report or Transaction code it should mention when that particular Report or Transaction has been used .

Its not useful for me if i have to specify the time.

Kindly help.

Virendra

[Former Member]

Hi Virendra,

I can suggest a method but I have never tried it.

The code for transaction<b> STAT</b> is written in the report <b>RSSTAT26</b> . You can write a short report program and call this report using the <b>SUBMIT</b> option and pass the parameters as per your requirement.

Regards,

<b>AS</b>

Message was edited by: Arun Sambargi

[former_member190178]

Here the issue is same.

STAT transaction is asking for the time which is the main hurdle.

I am hanging around with STAT transaction but not finding

how to getover the time specification.

if i dont specify the time i takes by default the 2 or minutes back from the current time.

which is not useful for me at all.

My main requirement is that my seniors want to know what are all reports or transaction or tables which are not used at what last time ?

so if i have to specify the time wont be so useful for me.

And writing a report 'll not gain anything coz internal SAP report is take time as main parameter.

Regards,

Virendra.

[Former Member]

Hi,

I am trying something like this, will let you know if successful.

REPORT  zztest_prd_3                            .



DATA : rstartti      TYPE swlstart, "Start time
       rday          TYPE swldate.  "Start date


PARAMETERS :      ruser         TYPE sapwlpfnrm-account,      "User
                  rtcode        TYPE sapwlpfnrm-tcode,        "Tcode
                  rprogram      TYPE sapwlpfnrm-report.       "Report


*We populate the date and time(say you require status from 1 year)

<b>rstartti = '16:11:00'.
rday     = sy-datum - 365.</b>  "Since 1 year


START-OF-SELECTION.

.
.
.
.

Regards,

<b>AS</b>

[Former Member]

Hi,

Start date  05.08.2006        Read time      <b>24:00:00</b>
Start time  16:42:00

The maximum read time is limited to 24:00:00 i.e.. one day.

Regards,

<b>AS</b>

[former_member190178]

Thanks Arun for your kind initiative.

I am waiting you to hear something positive...

Regards,

Virendra.