Displaying Archiving Objects and Tables

Use

Each archiving object archives specific tables as set in the definition of the archiving object in transaction AOBJ . If you do not know which tables are archived using which archiving object or vice versa, you can use this procedure to determine:

The archiving object that archives a particular table

Which archiving objects can be used to archive the tables in question

There are number of export, filter, and search functions that you can use here.For more information about the SAP List Viewer (ALV) functions available here, see SAP List Viewer (ALV) Grid Control (BC-SRV-ALV)

Procedure

Choose Administration → CCMS → DB Administration → Data Archiving (transaction DB15). Alternatively, go to transaction SARA and choose Database Tables

The Tables and Archiving Objects screen appears with the cursor in the lower section of the screen in the area Tables from which data is archived.

Tables

To display the tables archived by a particular archiving object, enter the archiving object in theTables in object field and chooseEnter

By default, only the tables from which data is deleted after archiving are displayed. To display all tables processed by the archiving object, choose All Tables

To display all the archiving objects for one of the tables listed, choose a table and thenShow objects

The list of archiving objects appears in the upper part of the screen.

Archiving Objects

Choose Archiving Objects .

To display the archiving objects that archive a specific table, enter the table in the Objects for table field and choose Enter .

This graphic is explained in the accompanying text.

In addition to transparent tables, you can also enter pool and cluster tables. DB15 determines the transparent tables for the pool or cluster table.

To display all the tables for one of the archiving objects listed, choose an archiving object and then Show tables .

The list of tables appears in the lower part of the screen.

This graphic is explained in the accompanying text.

DB15 does not output archiving objects that:

Only read data and do not delete it from the table

Archive data from the table indirectly using a view or a structure