New report from transaction ST03N

[Former Member]

Hi everybody,

In transaction ST03N you can have an overview about User or transaction for a period.

This helps to let you know what kind of work has been done in the system.

The data is shown separated, you have one place for transactions and one for user.

The only problem is that we do not have a combined list which shows, user + transaction at once.

Is there a way to do this, or has anybody any idea where the data from this transaction are stored, so I can get them from the database

Regards,

Dren Selimi

[Former Member]

Hi Dren,

You will get that data from transaction AL08(Current data). If you want the data for particular time you can use transaction STAD .

Regards

Santosh

[Former Member]

Hi Santosh,

Thank you for your reply,

I know there are transactions but I need to extract data in a custom way, that's why I need tables or FMs that store the data of ST03N

Regards,

Dren

[Former Member]

Hi Dren,

See sap note 1053634. This contains some of function module which fetch data from database and display in st03 tcode.

Regards

Santosh

[Juwin]

report zbc_r_tcodes_by_user.

data:begin     of   gv_output,

     user      type string,

     type      type c,

     title     type string,

     times     type i,

     end       of   gv_output,

     gt_output like standard table of gv_output,  "Output table

     gv_title  type char100.                      "Report title

perform get_data.

*&---------------------------------------------------------------------*

*&      Form  get_data

*&---------------------------------------------------------------------*

*       text

*----------------------------------------------------------------------*

form get_data.

  data:lv_datum  type d,

       lt_data   type standard table of swncaggusertcode,

       lv_data   type swncaggusertcode.

  lv_datum = sy-datum.

  gv_title = 'Objects executed by users from'.

  write: sy-datum to gv_title+55.

  do.

    lv_datum+6 = '01'.

    refresh lt_data.

    call function 'SWNC_COLLECTOR_GET_AGGREGATES'

      exporting

        component     = 'TOTAL'

        periodtype    = 'M'

        periodstrt    = lv_datum

      tables

        usertcode     = lt_data

      exceptions

        error_message = 1

        no_data_found = 1

        others        = 2.

    if sy-subrc ne 0.

      exit.

    endif.

    write lv_datum to gv_title+40(10).

    subtract 1 from lv_datum.

    loop at lt_data into lv_data where tasktype = '01'.

      gv_output-user  = lv_data-account.

      gv_output-type  = lv_data-entry_id+72.

      gv_output-title = lv_data-entry_id(40).

      gv_output-times = lv_data-count.

      collect gv_output into gt_output.

    endloop.

  enddo.

  sort gt_output.

  gv_title+52(1) = '-'.

  condense gv_title.

endform.                    "get_data

[Former Member]

Hi Juwin,

I have two more questions ?

why do you use the 'tasktype' or what does it mean ?

and how can I make the FM to show me the data about a day

Thanks and regards,

Dren

[Juwin]

Hi,

Tasktype 01 stands for Tcode. This is used to limit the report by Tcode data only.

Since most customers don't keep daily log, for more than 2 weeks, the data will be very limited, if you try to get the information per day.

In order to get the daily values, you may pass periodtype = 'D' and periodstrt  = required_date, to the above function module.

Thanks,

Juwin

[Former Member]

Hi,

Okay I understand, thank you very much for your help

Regards,

Dren

[Former Member]

Hi Juwin,

I was wondering is there a way to get the data from 2 or 3 or more different days, like getting the required_date as a select-option, so I can put intervals of days there, ex. 02.06.2014 - 06.06.2014

Regards,

Dren

[Juwin]

Sure you can. You just have to build a loop through those dates and call the same FM.

Thanks,

Juwin