|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
SAP Data Archiving
By Gayatri Narendra Patil, Infosys
Archiving, in general means deleting the huge volumes of the data that is no
longer required in the database to some file system or any third party storage
system. It is also a service provided by SAP for the
consistent removal of data objects from database tables of the SAP database,
where all table entries that characterize a data object are written to an
archive file outside the database.
of DATA Archiving
Data Archiving Process Flow
Archiving main involves three steps:
the archive file and running the delete programs are the mandatory steps to
follow for data archiving whereas storing the archive files is optional.
Menu (tCode SDMO)
list of transaction codes along-with the short
description required for SAP Archiving can
be found in the dynamic menu. Go to
and enter search for the text as ‘Archive’.
execute button. The screen will be displayed as below.
What is Archiving Object?
Object is the central component of Sap Data Archiving. Archiving Object
specifies which data is to be archived and how. Archiving Objects directs the
SAP Archiving system to get the correct tables associate with the specific
Business Object. The archiving object name can be ten characters long in length.
objects are defined by the transaction AOBJ.
Fig.1. Archiving Object Details (AOBJ).
the Archive Objects
Transaction DB02 is used to identify tables with high growth in data volumes and
to compare the table size after archiving and thus to monitor growth of the
Transaction TAANA which is used to identify the appropriate
archiving object when a table has more than one archiving object
DB15 is used to identify the Archive
Objects, if you know the Database tables or if you know the Archiving Object it
displays the list of associated database tables for that particular Archiving
Object as Shown in Fig.a.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards