Skip to Content
Author's profile photo Former Member

You really CAN teach an old SAP Archiving dog new tricks

*Disclaimer – the following information is in theory only.  It should only be used as a guideline.

A while back, I was asked to document the business process for destroying archived SAP data that has met its retention time and has been approved for destruction.  I have been working with SAP Archiving for the past eleven years but have never had to do this process before.  I have theorized about it, but had never researched the exact steps that need to occur and in what order.   

I was very fortunate to have participated in the ASUG ILM (Information Lifecycle Management) Influence Council where the theory of managing data from creation to destruction was discussed in great lengths.  The process to destroy archived SAP data is a very manual process.  With input from the ASUG ILM Influence Council, SAP developed a new solution to handle retention management and legal holds.  In the process of developing this new solution, SAP also developed a retention warehouse that can be used for system decommissioning.  This new solution is called SAP NetWeaver Information Lifecycle Management (SAP NetWeaver ILM).

But, without SAP’s ILM solution, the process of destroying archived SAP data contains multiple steps that need to be followed in a particular sequence.  SAP provides a manual named Final Deletion of SAP Business Data which can be found out on www.service.sap.com/ilm .  Then, Data Archiving -> Media Library -> Literature & Brochures -> Final Deletion of SAP Business Data.

Upon reading this manual, I determined the proper sequence (at a very high level) that can be used to delete archived SAP data from your ERP system that has met its retention time and has followed your company’s business process for the necessary approvals for destruction is:

 

  1. Search for the relevant data archive files via report RSARCH_LIST_STORED (export list).
  2. Search for the relevant image document id’s via OAAD (export list).
  3. Search and delete any “retrieved” archive files via report RSARCH_LIST_RETRIEVED ( from within this report you can delete the retrieved files at the OS level).
  4. Check for application-specific archive indexes such as MKPF_ARIDX and ARIX_BKPF.  If relevant indexes exist and are eligible for destruction, from within the Archive Administration, go to Index-> Delete Index.  Application-specific indexes should be deleted BEFORE the ADK files.  It may not be possible to delete infostructures after the archive files have been deleted because the deletion requires information from the archive files.
  5. Delete relevant Archive Information Structures via transaction SARI.
  6. Delete relevant document data via OAAD.
  7. Send list of document id’s from steps 1 and 2 to be deleted on the external storage server and have the storage administrator delete those files according to process relevant for the particular 3rd party storage system (step 7 must be completed prior to starting steps 8 and 9).
  8. Archive/delete the relevant Archive Management Data via archive object BC_ARCHIVE.
  9. Archive/delete the relevant Link Data via archive object ARCHIVELNK.

 

If you have DART files, they need to be included as well as any Views that have been created.

Also, this process only covers data and images that have been archived.  There still may be old data remaining in the database that may need to be accounted for.

Note, that this process does not have a way to handle legal holds.  If there are any records within an archive file that need to be retained for legal reasons, you must keep the whole archive file/run.   There is no SAP standard functionality that can handle archive file “splitting”.  There may be 3rd party solutions for this, but I am not familiar with them.  Beginning with SAP NetWeaver 2004, there is now the ability to archive data from one archive object to multiple content repositories via Archive Routing.  But, you cannot use this functionality for previously created archive files.

If you have archived SAP data and images that have met their retention requirements, do not have any legal holds and can be destroyed, I hope this information is useful.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      I never had any experience in archiving or any of its related project. After reading this blog, I feel very much interested towards this area. Thanks for sharing your knowledge and experience

      Regards,
      Anand

      Author's profile photo Former Member
      Former Member

      HI Karin,

      You are just amazing contributor to ILM, i read all the blogs of yours and each and every blog is very helpful.

      In this blog u mentioned , Data Archiving -> Media Library -> Literature & Brochures -> Final Deletion of SAP Business Data.

      But unfortunately i couldn't found the Document or manual at this location.

      Is ti removed or i am just referring to a wrong location ?

      With regards,

      Tony.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Tony!  I went and looked for the document and could not find it either.  So, I checked with SAP and they are going to see if it can be put back.  It will probably need to be updated so it may take awhile.  I should know more next week.  Once I have more information, I will reply to this comment again.

      Best Regards,

      Karin Tillotson

      Author's profile photo Satya Veeramachaneni
      Satya Veeramachaneni

      FYI

      From SMP, goto quick links-> ILM - > data archiving -> media library -> Literature & Brochures

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Sorry, but the document is no longer posted, it was removed by SAP.  But, they are going to let me know if they are going to put it back.  If I hear anything, I will let you all know.

      Best Regards,

      Karin Tillotson

      Author's profile photo Satya Veeramachaneni
      Satya Veeramachaneni

      This is really strange , I can see the document on SMP..

      Right click to download document You have read this document Extension PDF Data Management Guide 2011/12 E 627
      Author's profile photo Former Member
      Former Member

      Hello Data Management Guide is different, it only explains about the tables and their Data removal(House keeping, Archiving, delete...etc).

      Author's profile photo Satya Veeramachaneni
      Satya Veeramachaneni

      Hello this guide has info on deletion also , but I dont think there is any such document alone on destruction of data. Ofcourse the new ILM with ERP EHP6  has the tools and methods for such activity

      Author's profile photo Former Member
      Former Member

      Can u specify the tools and methods which is used specifically for Destruction of data in EHP6.

      Author's profile photo Satya Veeramachaneni
      Satya Veeramachaneni

      it is not some quick workaround

      you have to refer to help on SAP EHP6

      Author's profile photo Former Member
      Former Member

      Atleast you can share some useful links..!!! 😉

      Author's profile photo Satya Veeramachaneni
      Satya Veeramachaneni
      Author's profile photo Former Member
      Former Member
      Blog Post Author

      FYI - SAP has updated the document "Final Deletion of SAP Business Data" and has uploaded it here.

      Best Regards,

      Karin Tillotson