Custom code Usage Analysis

[Former Member]

Hi

I want to get the data from SAP system for all  custom develoed programs execution date and its frequency.
Please let is know the table & method from where I will get the program name and used data.

If any program is available , please share those

If any background job need to be run please let us know...

Regards

Vimal

[nikolayevstigneev]

Hi, Vimal!

There was a post about UPL recently, you may have a look at it. But it has requirements to solution manager packages.

[Former Member]

Hi Nikolay

I have gone through the UPL but it needs solution manager. I want to develop my own code which will be a part of some tools.

Can you please let us know that how to extract the data and from which table it is to be extracted ?

The report should be in our format.

Regards

Vimal

[RaymondGiuseppi]

Question: What is your version, I ask cause you seem unwilling to use Solution Manager and UPL?

You could create a background job to periodically analyze statistical data on your system before they are cleared by a periodically standard job.

Look at following FM

• TH_SERVER_LIST - get list of AS (as following FM must be executed on each one)
• SAPWL_STATREC_READ_FILE (*) - to read statistic file that are stored in FS of the AS, check returned table parameter V2_NORMAL_RECORDS)

Else you could start searching information on table MONI and similar tables where SAP store some information. (start anamyze transacion ST03N)

Regards,

Raymond

PS: I called this FM on 4.6C but no longer, maybe look at SAPWL_STATREC_DIRECT_READ which replaced this one?

[Former Member]

HI Raymond

Thanks for reply.

I want to understand that for above below activities to be done.

1. Any RFC need to be created

2. Audit need to be enabled or not... what are the parameters to be activated

Regards

Vimal

[matt]

You cannot get complete information without UPL and SOLMAN. ST03N (Stats) will give you some information. However you must recognised that it isn't complete. For example, print programs will not be picked up. It also does not tell you about function modules or classes that are in your system and not used. Further the data is not held forever. If the retention time is 3 months, then you have no data older than 3 months.

This question has been discussed many times before; as such I am locking this thread.