SAP Data Archiving

How do you identify a SAP Archiving Object?

Transaction DB15 is used to identify the Archive Objects. If you know the database tables or Archiving Object it displays a list of associated database tables for that particular Archiving Object.

Transaction DB02 is used to identify tables with high growth in data volumes. It compares the table size after archiving, thus monitoring data growth.

Transaction TAANA is used to identify the appropriate Archiving Object when a table has more than one archiving object.

What is a SAP Archiving Object?

An Archiving Object specifies which data is to be archived and how. It directs the SAP archiving system to the correct tables associated with a specific Business Object.

The Archiving Object name can be ten characters long and they are defined by the transaction AOBJ.

What is SAP Data Archiving?

SAP data archiving is a decongestion process used to remove large volumes of data, no longer needed, from your live SAP database.

Archived data is moved to a more cost effective storage tier in a format that meets SAP best practice and allows for data retrieval and analysis.

We’ve helped over 500 SAP customers to identify data for archiving or deletion and supported them to complete a SAP data archiving project.

Find out more about SAP Data Archiving

How long does an archiving project take?

An archiving project runs exactly the same as any other SAP project:

  • Blueprint phase – 20-30 days (approximately)
  • Realisation phase – 15 days per module (approximately)

So for a project, archiving from, say, SAP FICO, MM and SD, total days will be between 65 and 75 over a six-month period.

Find out more about SAP Data Archiving

We’ve only been running SAP for a couple of years – do we need to archive yet?

The earlier you start archiving the better. The longer you leave it, the more difficult and time consuming it becomes.

Unfortunately, only around one in six SAP customers archive from day one.

Benefits of archiving from day one (or within the first 18 months) include:

  • The people who configured SAP are available to provide information about the system design
  • Database growth and performance can be stabilised from day one.

Find out more about SAP Data Archiving

I’m upgrading to SAP HANA, Can I manage a data archiving project at the same time?

Yes! If you’re planning a migration to SAP HANA, then archiving should be a key part of the project.

RightSizing your data in readiness for SAP HANA will dramatically reduce TCO

The Benefits include;
  • Manage and streamline your data effectively
  • Access data quickly regardless of where it is stored
  • Lower appliance costs significantly
  • Minimise resources required for migration
  • Reduce SAP HANA total cost of ownership (TCO)
  • Increase SAP HANA return on investment (ROI)

Even a simple ‘housekeeping exercise’ can reduce the SAP HANA appliance requirement.  We have a number of customers who had over 5TB of non-business technical data, that could be deleted with no interaction from other business areas!

 

Find out more about RightSizing in Readiness for SAP HANA here

Does data archiving make it difficult for users to access data?

No, not at all.

For most modules of SAP, such as FICO, MM and SD, users will not notice any difference when accessing archived data.

The only limitation is users will not be able to edit archived data, as it is stored in a read-only format which makes it compliant throughout its retention period.

For some SAP modules, like Project System, archived data may be viewed in a different format.

Find out more about SAP Data Archiving here

Storage hardware is cheaper now, so why not buy more storage, instead of archiving?

Buying more disc storage may solve your immediate problem. However it is not a viable long-term solution. Problems can arise with:

Hardware and system migration

A UK telecoms company had an 8TB database. They wanted to refresh hardware and move from Informix to Oracle. To move 8TB of data would take four to five days. This was not feasible as the business could not be down for that long. By archiving they drastically reduced the database down to about 3TB.

Data recovery

Large databases are also problematic for data recovery. We have worked with a customer who had 27TB of data in Oracle. To recover their data would take an estimated 3.5 days – which is totally unacceptable for a 24/7 operation.

Find out more about SAP data archiving.

I only have a small SAP database – do I need to archive data?

If you have a relatively small SAP database (e.g. 200 GB) and it’s growing by less than 2% a month, archiving is not necessary at present.

If you have a larger database (e.g. 500 GB), that’s growing by 2%+ a month, there will be financial and system benefits to archiving, so we would highly recommend it.

It’s worth remembering that even a small database will reach a point at which it will be beneficial to control growth through archiving.

Find out more about SAP data archiving.

Privacy & Cookie Notice  | © Copyright 2018 Proceed Group | Web design by Shaun Power Design