‎2010 Nov 24 9:54 AM
Hello,
my task is to implement a program which analysis the data amount which is freed by an archiving object if it would be archived by the admin. The information I've gathered so far is the following:
1) With the transaction db15 I am able to take a look into the archiving objects and how they are linked with the tables in the database.
2) I know that every archiving object has to do 4 steps while it is processed: read-write-delete-back loading
The problem is I don't know how many data rows are archived by an archiving object nor which data they hold. Is there a table which holds this information?
Best Regards,
Ralph
‎2010 Nov 24 2:27 PM
Hi Ralph,
To analyse how many data rows are archived by an archiving object you'll have to query the relevant tables for the archiving object and then check if the objects are business complete and the residence period is met. This can be quite complex, a fast alternative is to run the archiving jobs in test mode and they will display the total number of objects that would be archived.
When you say "nor which data they hold", I understand that you mean to see which data has already been archived by the different archiving objects. For this you'll have to use the AIS (Archive Information System), but basically, for each archiving object, SAP has "link tables" that contain information about the objects that have been archived.
More information about AIS on the following link:
http://help.sap.com/saphelp_nw2004s/helpdata/en/5c/11af9bd55711d2b1f80000e8a5b9a5/content.htm
Regards, David.