topic tables access information in Application Development and Automation Discussions

tables access information

Clemenss — Tue, 17 Oct 2006 13:11:26 GMT

Hi,

we are in a cleaning process. Althoug nobody gets hurt by unnused customer tables, the customer wants to know about tables that are nort used.

One approach is a where-used-list. OK, done.

Another approach is to analyze table access statistics. AFAIK the database collects statistics from database accesses. From those statistics the system gains information to optimize table access.

Now my question: Where can I find (programatrically or via transaction/report) information about table access?

TIA,

regards,

Clemens

Re: tables access information

uwe_schieferstein — Tue, 17 Oct 2006 14:22:55 GMT

Hello Clements

In packages SEST you will find very interesting objects for program analysis.

Function group SEA1 contains function module <b>RS_PROGRAM_TABLES</b> which will show you all tables accessed by a program object.

For example, enter OBJECT_TYPE = 'TRAN' and OBJECT_NAME = 'VA01' and the function module will show you all tables accessed by the transaction. The list shows you if the tables are read, updated or deleted.

In your case you could write a report that analyzes all customer transactions (since SAP standard transactions should not access customer tables) using function module RS_PROGRAM_TABLES. Customer tables that will not be listed here are not accessed by any program.

Regards

Uwe

Re: tables access information

Former Member — Tue, 17 Oct 2006 14:34:02 GMT

Hi,

Pl try DB02->Checks->Database<>ABAP Dict->Display.

If it helps pl reward.

Cheers