Skip to Content
author's profile photo Former Member
Former Member

How to find the last executed date ,time and user of the quaery

Hi,

How to find the following information of the Query

1. Where all the place these queries/web template used.

2. When was it last executed.

3. Who executed last.

Regards,

Hari

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 30, 2006 at 11:22 AM

    hi Hari,

    you can try table /BI0/APERS_BOD00

    for query, first go to table RSRREPDIR, give field COMPID

    with query technical name and get GENUNIID, then go to table /BI0/APERS_BOD00, field TCTOBJNM = RSRREPDIR-GENUNIID, TCTUSERNM and TCTTIMSTMP -> user name and last executed.

    for web template, give field TCTOBJNM in table /BI0/APERS_BOD00 with web template name.

    hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 30, 2006 at 11:17 AM

    To capture this kind of info, you need to activate the technical content for BW statistic.

    Have a look in:

    http://help.sap.com/saphelp_nw04/helpdata/en/f2/e81c3b85e6e939e10000000a11402f/frameset.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 30, 2006 at 11:23 AM

    Hi,

    Go to Bex and execute the any Query. Now in Bex toolbar->go to layout(Fourth from rite of toolbar)->Display Text->General.

    Regards,

    San!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2006 at 11:09 AM

    Thank you vey much. my problem has been solved

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.