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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

PLEASE HELP ME... ITS URGENT

Former Member

‎05-12-2006 6:43 AM

0 Kudos

I WANT TO CREATE A NEW REPORT THAT WILL HAVE THE DETAILS OF A PARTICLUAR Z-TRANSACTIONS LIKE <b><u>WHEN IT WAS LAST RUN</u></b>.

PLEASE TELL ME WHT FIELDS AND TABLES I HAVE TO TAKE.

PLEASE HELP ME FAST ITS VER VERY URGENT.

5 REPLIES 5

Former Member

‎05-12-2006 6:45 AM

0 Kudos

Hi Abhay,

Take a look at the tcode STAT and STAD. These transaction gives you details of the last run time of the program.

You can get the information from MONI table.

Remember all this will work only if the system is enabled to for system statstics.

You can copy the code and use it.

Cheers

VJ

REPORT ZSTATFILE LINE-SIZE 164.
************************************************************************
* This is an example of how to dig out some interesting performance
* and statistical data from the STAT file.
* The program creates a rank list of users based upon their database
* update and read activity. The results are the accumulated database
* time and row number per user for the different categories:
* insert/delete/modify and sequential/direct read. The results can be
* sorted by any of these categories.
* There are a lot more interesting data in the STAT file that can
* be used to write similar programs.
*
* Written by : SAP Basis, ABAP Programming and Other IMG Stuff
*              http://www.sap-img.com
*
************************************************************************
DATA: STATISTIC_VERSION_USED LIKE  SAPWLPSTRC-VERSION.
DATA: SORT_FIELD(20).

* General input parameters: from/to, client, STAT file path
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE T7.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(30) F1.
SELECTION-SCREEN POSITION 40.
PARAMETERS: FDAT LIKE SY-DATUM,
            FTIM LIKE SY-UZEIT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(30) F2.
SELECTION-SCREEN POSITION 40.
PARAMETERS: TDAT LIKE SY-DATUM,
            TTIM LIKE SY-UZEIT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(30) F4.
SELECTION-SCREEN POSITION 40.
PARAMETERS: CLI LIKE SY-MANDT.
SELECTION-SCREEN END OF LINE.
*SELECTION-SCREEN BEGIN OF LINE.
*SELECTION-SCREEN COMMENT 1(35) F3.
*SELECTION-SCREEN POSITION 40.
*PARAMETERS: FILE(128) LOWER CASE.
*SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK B1.

* Sort order input
SELECTION-SCREEN BEGIN OF BLOCK B2 WITH FRAME TITLE T5.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(30) F5.
SELECTION-SCREEN POSITION 40.
PARAMETERS: ASC  RADIOBUTTON GROUP ORD,
            DESC RADIOBUTTON GROUP ORD.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK B2.

* Sort criteria input
SELECTION-SCREEN BEGIN OF BLOCK B3 WITH FRAME TITLE T6.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(30) T1.
SELECTION-SCREEN POSITION 62.
PARAMETERS: A1 RADIOBUTTON GROUP SORT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(55) T2.
SELECTION-SCREEN POSITION 62.
PARAMETERS: A2 RADIOBUTTON GROUP SORT.
PARAMETERS: A3 RADIOBUTTON GROUP SORT.
SELECTION-SCREEN POSITION 67.
PARAMETERS: A4 RADIOBUTTON GROUP SORT.
PARAMETERS: A5 RADIOBUTTON GROUP SORT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(55) T3.
SELECTION-SCREEN POSITION 62.
PARAMETERS: A6 RADIOBUTTON GROUP SORT.
PARAMETERS: A7 RADIOBUTTON GROUP SORT.
SELECTION-SCREEN POSITION 67.
PARAMETERS: A8 RADIOBUTTON GROUP SORT.
PARAMETERS: A9 RADIOBUTTON GROUP SORT.
SELECTION-SCREEN POSITION 72.
PARAMETERS: AA RADIOBUTTON GROUP SORT.
PARAMETERS: AB RADIOBUTTON GROUP SORT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 1(50) T4.
SELECTION-SCREEN POSITION 62.
PARAMETERS: AC RADIOBUTTON GROUP SORT.
PARAMETERS: AD RADIOBUTTON GROUP SORT.
SELECTION-SCREEN POSITION 67.
PARAMETERS: AE RADIOBUTTON GROUP SORT.
PARAMETERS: AF RADIOBUTTON GROUP SORT.
SELECTION-SCREEN POSITION 72.
PARAMETERS: AG RADIOBUTTON GROUP SORT.
PARAMETERS: AH RADIOBUTTON GROUP SORT.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK B3.

*Internal tables
DATA: BEGIN OF V1_NORMAL_RECORDS OCCURS 100.
        INCLUDE STRUCTURE  SAPWLSTATR.
DATA: END OF V1_NORMAL_RECORDS.
DATA: BEGIN OF V2_NORMAL_RECORDS OCCURS 100.
        INCLUDE STRUCTURE  SAPWLPFNRM.
DATA: END OF V2_NORMAL_RECORDS.

DATA: BEGIN OF SUM OCCURS 100,
        ACCOUNT(32),
        READSEQREC TYPE I,
        READSEQTI TYPE I,
        READDIRREC TYPE I,
        READDIRTI TYPE I,
        UPDREC TYPE I,
        UPDTI TYPE I,
        DELREC TYPE I,
        DELTI TYPE I,
        INSREC TYPE I,
        INSTI TYPE I,
        SUM_RD_ROW TYPE I,
        SUM_RD_TIM TYPE I,
        SUM_MOD_ROW TYPE I,
        SUM_MOD_TIM TYPE I,
        SUM_ALL_ROW TYPE I,
        SUM_ALL_TIM TYPE I,
END OF SUM.

*Initialize the selection screen
INITIALIZATION.
  T1 = 'User Name and Report Name'.
  T2 = 'READ: Sequential(row/time) Direct(row/time)'.
  T3 = 'Update(row/time) Delete(row/time) Insert(row/time)'.
  T4 = 'SUM: Read(row/time) Modify(row/time) All(row/time)'.
  T5 = 'Sort'.
  T6 = 'By'.
  T7 = 'Period, Client and STAT file'.

  F1 = 'From: (date/time)'.
  F2 = 'To: (date/time)'.
* F3 = 'STAT file path(only for old stat)'.
  F4 = 'Client'.
  F5 = 'Ascending/Descending'.

  FDAT = SY-DATUM. FTIM = SY-UZEIT.
  FDAT = FDAT - 1. TTIM = SY-UZEIT.
  TDAT = SY-DATUM.
  CLI = SY-MANDT.

* Write a page header
TOP-OF-PAGE.
  WRITE:        / 'User and Report ' COLOR 2,
             34(15) 'Sequential read' COLOR 2,
             50(15) 'Direct read' COLOR 2,
             66(15) 'Update' COLOR 2,
             82(15) 'Delete' COLOR 2,
             98(15) 'Insert' COLOR 2,
            114(15) 'Sum Read' COLOR 5,
            130(15) 'Sum Modify' COLOR 5,
            146(15) 'Sum All' COLOR 6.

  WRITE:        / 'name' COLOR 2,
            34(6) 'rows' COLOR 2,
            41(8) 'time(ms)' COLOR 2,
            50(6) 'rows' COLOR 2,
            57(8) 'time(ms)' COLOR 2,
            66(6) 'rows' COLOR 2,
            73(8) 'time(ms)' COLOR 2,
            82(6) 'rows' COLOR 2,
            89(8) 'time(ms)' COLOR 2,
            98(6) 'rows' COLOR 2,
           105(8) 'time(ms)' COLOR 2,
           114(6) 'rows' COLOR 5,
           121(8) 'time(ms)' COLOR 5,
           130(6) 'rows' COLOR 5,
           137(8) 'time(ms)' COLOR 5,
           146(6) 'rows' COLOR 6,
           153(8) 'time(ms)' COLOR 6.

* Main
START-OF-SELECTION.
* Figure out the sort field name
  IF A1 = 'X'.
    SORT_FIELD = 'ACCOUNT'.
  ELSEIF A2 = 'X'.
    SORT_FIELD = 'READSEQREC'.
  ELSEIF A3 = 'X'.
    SORT_FIELD = 'READSEQTI'.
  ELSEIF A4 = 'X'.
    SORT_FIELD = 'READDIRREC'.
  ELSEIF A5 = 'X'.
    SORT_FIELD = 'READDIRTI'.
  ELSEIF A6 = 'X'.
    SORT_FIELD = 'UPDREC'.
  ELSEIF A7 = 'X'.
    SORT_FIELD = 'UPDTI'.
  ELSEIF A8 = 'X'.
    SORT_FIELD = 'DELREC'.
  ELSEIF A9 = 'X'.
    SORT_FIELD = 'DELTI'.
  ELSEIF AA = 'X'.
    SORT_FIELD = 'INSREC'.
  ELSEIF AB = 'X'.
    SORT_FIELD = 'INSTI'.
  ELSEIF AC = 'X'.
    SORT_FIELD = 'SUM_RD_ROW'.
  ELSEIF AD = 'X'.
    SORT_FIELD = 'SUM_RD_TIM'.
  ELSEIF AE = 'X'.
    SORT_FIELD = 'SUM_MOD_ROW'.
  ELSEIF AF = 'X'.
    SORT_FIELD = 'SUM_MOD_TIM'.
  ELSEIF AG = 'X'.
    SORT_FIELD = 'SUM_ALL_ROW'.
  ELSEIF AH = 'X'.
    SORT_FIELD = 'SUM_ALL_TIM'.
  ENDIF.

  CALL FUNCTION 'SAPWL_STATREC_READ_FILE'
       EXPORTING
            READ_CLIENT            = CLI
            READ_END_DATE          = TDAT
            READ_END_TIME          = TTIM
            READ_START_DATE        = FDAT
            READ_START_TIME        = FTIM
*           STATISTIC_FILE         = FILE
       IMPORTING
            STATISTIC_VERSION_USED = STATISTIC_VERSION_USED
       TABLES
            V1_NORMAL_RECORDS      = V1_NORMAL_RECORDS
            V2_NORMAL_RECORDS      = V2_NORMAL_RECORDS.

  LOOP AT V2_NORMAL_RECORDS.
    V2_NORMAL_RECORDS-READSEQTI = V2_NORMAL_RECORDS-READSEQTI / 1000.
    V2_NORMAL_RECORDS-READDIRTI = V2_NORMAL_RECORDS-READDIRTI / 1000.
    V2_NORMAL_RECORDS-UPDTI = V2_NORMAL_RECORDS-UPDTI  / 1000.
    V2_NORMAL_RECORDS-DELTI = V2_NORMAL_RECORDS-DELTI / 1000.
    V2_NORMAL_RECORDS-INSTI = V2_NORMAL_RECORDS-INSTI / 1000.
    MODIFY V2_NORMAL_RECORDS.
  ENDLOOP.

  LOOP AT V1_NORMAL_RECORDS.
    V1_NORMAL_RECORDS-READSEQTI = V1_NORMAL_RECORDS-READSEQTI / 1000.
    V1_NORMAL_RECORDS-READDIRTI = V1_NORMAL_RECORDS-READDIRTI / 1000.
    V1_NORMAL_RECORDS-UPDTI = V1_NORMAL_RECORDS-UPDTI  / 1000.
    V1_NORMAL_RECORDS-DELTI = V1_NORMAL_RECORDS-DELTI / 1000.
    V1_NORMAL_RECORDS-INSTI = V1_NORMAL_RECORDS-INSTI / 1000.
    MODIFY V1_NORMAL_RECORDS.
  ENDLOOP.

  LOOP AT V2_NORMAL_RECORDS.
    MOVE-CORRESPONDING V2_NORMAL_RECORDS TO SUM.
    CONCATENATE V2_NORMAL_RECORDS-ACCOUNT V2_NORMAL_RECORDS-CUA_PROG
INTO SUM-ACCOUNT SEPARATED BY SPACE.
    COLLECT SUM.
  ENDLOOP.

  LOOP AT V1_NORMAL_RECORDS.
    MOVE-CORRESPONDING V1_NORMAL_RECORDS TO SUM.
    CONCATENATE V1_NORMAL_RECORDS-ACCOUNT V1_NORMAL_RECORDS-CUA_PROG
INTO SUM-ACCOUNT SEPARATED BY SPACE.
    COLLECT SUM.
  ENDLOOP.

  LOOP AT SUM.
    SUM-SUM_RD_ROW  = SUM-READSEQREC + SUM-READDIRREC.
    SUM-SUM_RD_TIM  = SUM-READSEQTI + SUM-READDIRTI.
    SUM-SUM_MOD_ROW = SUM-UPDREC + SUM-DELREC + SUM-INSREC.
    SUM-SUM_MOD_TIM = SUM-UPDTI + SUM-DELTI + SUM-INSTI.
    SUM-SUM_ALL_ROW = SUM-SUM_RD_ROW + SUM-SUM_MOD_ROW.
    SUM-SUM_ALL_TIM = SUM-SUM_RD_TIM + SUM-SUM_MOD_TIM.
    MODIFY SUM.
  ENDLOOP.

  IF ASC = 'X'.
    SORT SUM BY (SORT_FIELD) ASCENDING.
  ELSE.
    SORT SUM BY (SORT_FIELD) DESCENDING.
  ENDIF.


  LOOP AT SUM.
    WRITE: /  SUM-ACCOUNT,
              34(7) SUM-READSEQREC,
              42(7) SUM-READSEQTI,
              54(7) SUM-READDIRREC,
              58(7) SUM-READDIRTI,
              66(7) SUM-UPDREC,
              74(7) SUM-UPDTI,
              82(7) SUM-DELREC,
              90(7) SUM-DELTI,
              98(7) SUM-INSREC,
             106(7) SUM-INSTI,
             114(7) SUM-SUM_RD_ROW,
             122(7) SUM-SUM_RD_TIM,
             130(7) SUM-SUM_MOD_ROW,
             138(7) SUM-SUM_MOD_TIM,
             146(7) SUM-SUM_ALL_ROW,
             154(7) SUM-SUM_ALL_TIM.

  ENDLOOP.
*-------- END OF PROGRAM --------------------------------------------*

Message was edited by: Vijayendra Rao

Former Member

‎05-12-2006 6:47 AM

0 Kudos

Hi,

Refer this thread:

Regards,

Gayathri

Former Member
In response to Former Member

‎05-12-2006 6:48 AM

0 Kudos

SPAU tcode also may help u.

STAT too check

Former Member
In response to Former Member

‎05-12-2006 7:43 AM

0 Kudos

When I copied and pasted the code given by you its giving dump.

can u give me the parameters used in import and tbales in the same f. module used in program.

thanks

Former Member

‎05-12-2006 8:14 AM

0 Kudos

hii

chk out this func module SAPWL_STATREC_READ_FILE .

you will need to get the path of the statistics file, and to do that try this:

CALL 'C_SAPGPARAM' ID 'NAME' FIELD 'stat/file'

ID 'VALUE' FIELD WS_PATH.

You will need to use WS_PATH on the STATISTIC_FILE exporting parameter on the call to SAPWL_STATREC_READ_FILE.

also chk the transaction code STAT

hope this helps

Thanks&Regards

Naresh