topic Re: Function Module showing Transparent Table access?? in Application Development and Automation Discussions

Function Module showing Transparent Table access??

Former Member — Mon, 07 Jul 2008 11:52:47 GMT

Hi Guys,

I'm in the process of writing some programs that will archive some of our Custom tables (they are getting very full!).

Now, instead of going through ALL the custom tables we created, I'm trying to write a small program that will bring me tables that have certain criteria...

One of the criteria is Tables Access. I'm trying to see when last a table has been accessed (by a program, for example). Im not talking about the last Change Date (as per table DD02L entries) as I presume this actually indicates technical changes to the table??

Im looking for a Function Module that can actually give me the last date any given transparent table's data has been accessed...

Does anyone know of such a Function Module/Class?

tks

POINTS WILL BE REWARDED FOR USEFULL AWNSERS

Re: Function Module showing Transparent Table access??

Former Member — Mon, 07 Jul 2008 12:37:32 GMT

Hi Christiaan,

Have a look whether the flag for "Log data changes" has been set for any of those custom tables (Technical settings).

If so, have a look at transaction SCU3 where the logs can be viewed.

Kind Regards

Re: Function Module showing Transparent Table access??

Former Member — Mon, 07 Jul 2008 12:40:19 GMT

Hi,

I'm not 100% but maybe speak to your basis or DB admin team - they might be able to access DB logs that will give you this sort of information quicker than writing an ABAP to find it out?

Gareth.

Re: Function Module showing Transparent Table access??

bpawanchand — Mon, 07 Jul 2008 12:40:51 GMT

Check out his FM iam not sure about this

WUSL_CREATE_TRANSPARENT_TABLE

Regards

Pavan

Re: Function Module showing Transparent Table access??

former_member195698 — Mon, 07 Jul 2008 12:45:40 GMT

Try Transaction ST10. It gives the details of the table Access.

(No need of creating a program for that)

Fyi. -> Since your requirement is to Archive the table which are becoming full, you can also use transaction DB02.

On detailed analysis you can check the tables whose growth rate is high and also the tables which are very huge.

Re: Function Module showing Transparent Table access??

ThomasZloch — Mon, 07 Jul 2008 12:47:41 GMT

I have been looking for something like this in the past, and found that there is no simple way to answer this question.

When you say table access, do you mean changes or also reads?

The closest I found was transaction ST10 table call statistics, but it shows totals only, no timestamps.

For your purpose here I rather recommend analyzing the last runtime of programs that use those large Z-tables.

Thomas

Re: Function Module showing Transparent Table access??

Former Member — Mon, 07 Jul 2008 12:56:20 GMT

Hello Christian,

To answer your question, it is normally obtained through ST04 (DB Performance Monitor).

However, the inherent information pertinent to Table Access made by application programs depends on the underlying Database involved. In case of DB server being ORACLE...you may use the program RSORASCC.

Also, I would like to make a further recommendation about your methodology to identify custom transparent tables. Besides studying the table accesses, it is very important to consider the current size and the growth rate over a period of time. For doing this, use DB02 (Space Statistics for Tables and indexes) and workout the list of tables which you have to concentrate from archiving perspective.

Hope this info helps you and resolves your query.

With Regards

Vijay Gajavalli