ST03 data into Ztable

[Former Member]

Hi,

I want to capture ST03 data into a ztable. What are some transparent tables that store ST03 data? IF there are no transparent tables then are there any fmodules that I can read and then INSERT records into my ztable?

{also, what is the main difference between ST03 and ST03N}

Thanks

Naved

[Former Member · Accepted solution]

Hi, Naved!

http://help.sap.com/saphelp_bw31/helpdata/en/bb/26ba65ddf111d286d6006008b32e84/frameset.htm

Good luck!

[saleh_med]

Hi,

You can know which user use which tx by activing security audit (SM19) and after use the report in SM20.

Your basis team could activate this.

Hope helping.

Saleh.

[Former Member]

Hello,

I had the same problem. Data for st03 is stored in the table MONI but in a way that you can't get the data out. MONI gets its data from the stat-files which are located in the filesystem of the operating system. you can read out this stat-files by using the function module

<b>SAPWL_STATREC_DIRECT_READ</b>

(look in se37 and try to perform it directly).

This module returns all the data you want and then you only have to read out the results and move them into your ztable.

Greetz

Joschi

[Former Member]

<b>STAT</b> transaction uses program <b>RSSTAT20</b>. So you might want to check that out even.

Regards,

Subramanian V.

[Peter_Inotai]

ST03(N) data is stored in files in the DIR_DATA directory. The file called stat, and there is another file astat for the application statistics.

May be there a function module to read this file into an internal table.

Peter

[Former Member]

Hi Peter,

I did not see much data in (a)stat thru tcode AL11. However, there are other files stat69 to stat108 which contains continuous stream of data. I have listed the files below for ref. Do you know which one is most relevant and also how to read the continuous stream of data. Thanks

astat 136 xxxadm 11/27/2004

rslgspid 4 xxxadm 12/05/2004

rslgssta 21 xxxadm 12/05/2004

stat 136 xxxadm 12/08/2004

stat100 3,079,574 xxxadm 12/07/2004

stat101 3,242,391 xxxadm 12/07/2004

.

.

.

stat107 4,305,677 xxxadm 12/07/2004

stat108 2,001,876 xxxadm 12/08/2004

.

.

.

stat115 708,362 xxxadm 12/08/2004

stat69 1,760,561 xxxadm 12/06/2004

.

.

.

stat99 3,252,968 xxxadm

[Former Member]

Look at the tables that start with <b>SAPWLT</b> in SE11.

However, I feel that values in these tables are stored at runtime.

Also do a workload in SE37, there seems to be a lot of FM, which you might be searching for.

Regards,

Subramanian V.

Message was edited by: Subramanian Venkateswaran

[Former Member]

Thanks for your reply.

In ST03, I am able to display data for current day AND current day minus one. So, I assume, data is stored somewhere. In SE37, search on workload returns about 34 modules. Do you know which one is more suitable? I am trying to build a report showing which USERS run what tcodes on a daily basis.

Thanks

Naved

R/3 - 4.7

[Former Member]

Try <b>SAPWL_WORKLOAD_GET_STATISTIC</b>.

I am afraid, I do not know the exact one.

Regards,

Subramanian V.

[Former Member]

Hello Naved,

If you are looking at the transaction codes used by a user everyday, then the transaction that you might find to be more useful than ST03(N), in my opinion would be STAT.

This is a report transaction, which I guess provides more information than you need :-). So assuming that this report gives you all the information you need, all that you would have to do is to schedule this report as a job to be run everyday. You can probably write a small program which submits this report and then send the results as an email to the concerned people. Whether or not you send the email, since you have scheduled the job, the spool will be available for later analysis.

I hope my explanation is in line with your requirement. If you are still interested in writing a custom report, I can probably give you a few leads.

Regards,

Anand Mandalika.

[Former Member]

Hi Anand,

Yes, please provide a few leads.

Thanks

Naved

[Former Member]

Hi,

could you send some sample code.

Thanks