How to fetch ST03 data

[Former Member]

I have a requirement, to fetch the details of the transactions executed by a users in last three months.

a pre existing custom report using the FM " SAPWL_STATREC_DIRECT_READ" used to do this, but since EHP 7 upgrade it is not working.

now i have been talking to SAP support and they have advised

If you look at the coding of the FM SAPWL_STATREC_DIRECT_READ, there

is for example this comment:

* This function module reads data from the statistic file(s) for the

* given selection-criteria

The stat* files in DIR_DATA directory are available for the last 48

hours. With this FM you can read data only for 2 days. The statistics

from the stat* files is aggregated in ST03 and can be read by the

function modules as described in the note:

1053634 - SCSM_NW_WORKLOAD interface for reading ABAP statistics data

Which contains four FMs.

and i think i could use "SWNC_GET_DIRECTORY_FRAME " and "SWNC_GET_AGGREGATES_FRAME (function group SCSM_NW_WORKLOAD) to read statistics from ST03N's database."

ref..

but how, couldnt figure out a way to make them work.

kindly help.

[srijayant · Accepted solution]

Hi  siegreich,

I had a similar requirement,

and I could develop a report to fetch the ST03 data for one month at a time.

I had used another aggregate SAP workload collector function,

'SWNC_COLLECTOR_GET_AGGREGATES'

have attached the snip, might help

the table I am reading gives sufficient details, as transaction, users and hits count

Regards

Sri jayant

[Former Member · Accepted solution]

lieben dank, es half.

thanks

siegreich Löwe