topic stad tables in Application Development and Automation Discussions

stad tables

Former Member — Thu, 19 Nov 2009 09:57:05 GMT

HI experts,

I want to create a custom Program for to find how many times a custom program is executed by user . i searched in STAD. But i ididnt get stsndard tables. can anyone explain which table the data is available?.

Regards,

Varadarajan.R

Re: stad tables

Former Member — Thu, 19 Nov 2009 10:44:39 GMT

STAD data is held in a file on the application server directories rather than database tables. It is also a cyclic file of fixed size, which will overwrite on an ongoing process, so the data will only be held for a period dependent upon how busy your system is.

The data can be read into a program via function SAPWL_READ_STATISTIC_FILES.

Re: stad tables

Former Member — Fri, 20 Nov 2009 03:36:05 GMT

HI ,

I Tried that Function module. But i am not getting the correct input. I dont know where i give the program or transaction name?

Can u solve tgis problem please ?

Regards,

Varadarajan.R

Re: stad tables

Former Member — Fri, 20 Nov 2009 08:22:41 GMT

To cannot pass the program name as selection criteria to the function module.

But if you retreive all the data by date selection, then the program name can be found in ALL_STATS which is a table, element RECORD which is also a table, field REPORT.

So retrieve the data and then loop through looking for the program in this field.