Archiving Storage Space

[Former Member]

Hi All,

I'm working on an archiving project, and management has asked for numbers on how much space we will save by performing archiving on each object. So for example, they would like the space used now by production orders, and the space we will save by archiving XX number of orders. Where in SAP could I retrieve this information? I see that in DB02 I can view the storage space used by various tables, and the system as a whole... but could I break that down somehow for just production orders?

Thanks,

J

[Former Member]

Hi J,

Let me start by saying that there is no direct method to achieve your goal to find out the space savings by archiving a particular object.

But you can device a manual way to find out the approximate value. Try this:

- Go to DB15 -> Tables in Object -> enter object name as PP_ORDER

- You will get the list of tables for object PP_ORDER

- click on 'Online Space' or 'Space statistics'. you will get the size of the tables and indices for PP_ORDER

Note: the DB statistics need to be up-to-date for this. For updating the DB statistics you may have to take help from the Basis / DBA team.

After you get the size of the tables for pp order, you may have to look for the common tables (like CDHDR, CDCLS, COEP, STXH, STXL etc) which are common to many objects, so neccessarily does not contain only data from production orders. And these tables may be of considerable size. You may have to perform table analysis using transaction TAANA to find out the percentage of contribution to these tables from production orders. (for COEP, you can use reports RARCCOA1 and RARCCOA2 as described in note 138688).

After these activities, you have an approximate size occupied by production orders.

Now the next task would be to find out how much can be saved if i archive all production orders say older than 3 years. For this, you can use transaction TAANA on the header table of production orders to find out the distribution of orders over years. (by using date field in the analysis variant).

now based on the residence time, you can multiply the percentage of pp orders which are eligible (from the residence time point of view) with the approximate size which we got earlier. This will give you an approximate of approximates of the size which could be saved.

All said, the size what we got is the 'potential' for archiving, the actual savings depends on how many pp orders are eligible for archiving which satisfies the archiving criteria.

Hope this helps,

Naveen