tables access information

[Clemenss]

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

[Clemenss]

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

[uwe_schieferstein]

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

[Former Member]

Hi,

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

If it helps pl reward.

Cheers