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: 

Last Used status for Reports, Transactions, Tables ??

former_member190178
Participant
0 Kudos
169

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
101

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

8 REPLIES 8

Former Member
0 Kudos
101

Hi,

Try database tables JEST and TVARV.

Regards

Former Member
0 Kudos
101

Hi,

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

Regards,

<b>AS</b>

0 Kudos
101

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
0 Kudos
102

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

0 Kudos
101

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.

0 Kudos
101

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>

0 Kudos
101

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>

0 Kudos
101

Thanks Arun for your kind initiative.

I am waiting you to hear something positive...

Regards,

Virendra.