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.

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.

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.

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

Find out more about SAP data archiving.

I’m upgrading to SAP ECC 6.0. Can I manage a data archiving project at the same time?

Yes! If you’re upgrading from R/3 4.6 or 4.7 to ECC 6.0 then archiving should be a key part of the project.

Upgrading to ECC 6.0 will increase your disc storage by 15% – 25%.  Running a concurrent data archiving project has dual benefits:

  1. Stabilising storage
  2. Quicker upgrade time

Our customers have reduced the time to convert to ECC 6.0 and Unicode by 25%, by also running an archiving project.

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 it becomes.

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

Benefits of archiving from day one (or as early as possible) 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.

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.

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.

What is a SAP Archiving Object?

An Archiving Object specifies which data is to be archived and how. It directs SAP’s 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.

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 SAP S/4HANA?

SAP Business Suite 4 SAP HANA (SAP S/4HANA) is SAP’s next generation business suite.

A new product, built on HANA’s cutting-edge in-memory platform – SAP S/4HANA helps business to run simply.

Innovations include easier customer adoption and improved data model, user experience, decision-making and business processes. It also opens up possibilities across the Internet of Things, Big Data, business networks and mobile-first.

Rightsizing for SAP HANA will help you manage data more effectively for HANA.

What does SAP S/4HANA stand for?

SAP S/4HANA stands for: SAP Business Suite 4 SAP HANA.

It brings the next big wave of innovation to SAP customers, similar to the transition from SAP R/2 to SAP R/3.

What deployment options are available?

Three options are available:

  • On-premise
  • Cloud (public and managed)
  • Hybrid deployments to give real choice to customers.

SAP S/4HANA also gives customers the option to fully leverage the new HANA multi-tenancy functionality as provided by the SAP HANA platform (currently support package 9) for the cloud.

What business scope does each edition cover?

The business scope for each edition is designed to offer maximum choice to customers in alignment with their business requirements.

SAP S/4HANA on-premise edition

Offers a business scope similar in terms of coverage, functionality, industries and languages to the current SAP Business Suite.

SAP S/4HANA also includes the transformational simplifications delivered with SAP Simple Finance (SAP Accounting powered by SAP HANA) as well as a planned integration with SuccessFactors Employee Central and Ariba Network.

SAP S/4HANA managed cloud edition

Addresses a similar business scope as the on-premise edition. Covers essential core ERP scenarios (accounting, controlling, materials management, production planning and control, sales and distribution, logistics execution, plant maintenance, project system and PLM).

It also includes integration with SuccessFactors Employee Central, Ariba Network and SAP hybris Marketing.

SAP S/4HANA public cloud edition

Addresses particular business scenarios of specific businesses and industries. Covers key scenarios in customer engagement and commerce and professional services. This includes 10 core scenarios, plus planned integration with SuccessFactors Employee Central, Ariba Network and SAP hybris Marketing.

Innovation cycles

  • Cloud editions are intended to offer a quarterly innovation cycle.
  • On-premise edition is intended to offer a yearly innovation cycle.

The next simplification and innovation package is planned for the end of 2015.

How does SAP S/4HANA relate to SAP Simple Finance powered by SAP HANA?

SAP Simple Finance marked the first step in our SAP S/4HANA road map for customers. The solution demonstrates the value of simplification – no indexes, no aggregates and no redundancies – and instant insight in Finance.

SAP S/4HANA on-premise edition leverages the full scope of SAP Accounting powered by SAP HANA, included in SAP Simple Finance.

SAP S/4HANA managed cloud edition is intended to leverage the same scope.

SAP S/4HANA public cloud edition focuses on a selected scope of SAP Simple Finance in alignment with the key requirements in finance.

How does SAP HANA Cloud Platform relate to SAP S/4HANA?

In the context of SAP S/4HANA, SAP HANA Cloud Platform serves as an extension platform and agility layer.

It is possible to build specific capabilities extending the scope of SAP S/4HANA by either integrating non-SAP functions or building your own capabilities. The cloud platform not only serves as the development platform but also as the runtime foundation for the developed solutions.

The extensions built on the cloud platform can run against both cloud and on-premise deployments of SAP S/4HANA.

What are the key benefits of SAP S/4HANA?

SAP’s vision and strategy is to help customers run simply, driving the perfect enterprise.

SAP S/4HANA redefines how enterprise software creates value in a digital, networked economy.

SAP S/4HANA allows you to:

  • Reinvent business models
  • Drive new revenues and profits
  • Connect with customers through any channel to deliver value
  • Access the Internet of Things and Big Data
  • Simplify your processes, drive them in real-time and adapt instantly
  • Gain insight to any data, in real-time – supporting instant decision making

SAP S/4HANA will simplify your IT landscape and reduce cost of ownership (TCO), through:

  • Reducing your data footprint
  • Working with larger data sets in one system saving hardware costs, operational costs, and time
  • Choice of deployment: cloud, on premise, or hybrid to drive quick time-to-value

Innovation is also made simple with an open platform (SAP HANA Cloud Platform) to drive advanced applications – for example, predicting, recommending, and simulating – while protecting existing investments.

Finally business users can leverage a simple, role-based user experience based on modern design principles that minimise training and increases productivity.

Rightsizing for SAP HANA will help you manage data to run HANA more efficiently.

What are the key features of SAP S/4HANA?

  • Smaller total data footprint
  • Higher throughput
  • Faster analytics and reporting
  • ERP, CRM, SRM, SCM, PLM co-deployed
  • Unlimited workload capacity
  • SAP HANA multi-tenancy
  • All data: social, text, geo, graph, processing
  • New SAP Fiori UX for any device (mobile, desktop, tablet)
  • Three deployment options: on premise, public cloud and managed cloud

How does the in-memory platform benefit the data model?

SAP S/4HANA delivers high-volume transaction processing (OLTP) and high volume real-time analytical processes (OLAP) based on a unified data model without the redundant data layers typically required by traditional RDBMS based systems.

This reduces TCO while providing new opportunities to increase business value from existing investments.

Examples for redundant data layers are custom-built layers based on database tuning efforts such as secondary indexes, or application built-in performance accelerators such as aggregate tables or multiple general ledger versions for different managerial reporting needs.

The massive simplifications of the data model and the data processing layers enable business and technological innovations on a broad scale across all lines-of-business and industry solutions.

The new application architecture simplifies system landscape architectures and accelerates cloud deployments on an economical scale.

SAP Information Lifecycle Management (ILM)

SAP Legacy System Decommissioning

How do I retrieve data from the SAP Legacy System Data Lock?

We have designed two ways for you to retrieve your data. You can either access the data through a secure portal access or request data to be retrieved via our online request service. The main difference to each service are a detailed below:

Direct Portal Access  

  • Once authorised direct access to data
  • Expertise transfer on how to retrieve your data
  • Data available during normal service hours

Online request

  • Data Lock to manage retrieval of data
  • Data Lock experts on hand to retrieve data
  • Requests will be processed with agreed SLA’s and will be available during normal service hours
  • The frequency of requests to be agreed contractually


Suggested approach: Data moved to the archive that could require a high frequency access should be managed using direct access. Once the data has reached an age where the frequency has bottomed out (normally 2 years), the service can be changed to the online request service

How Secure is my Data in Data Lock?

Using the Direct Portal Access we will ensure your data is accessible only to authorised users. You will be responsible for ensuring only authorised personnel are given access

Online Request – We will ensure any request for data will require approval before the data is given to the requester to ensure the requestor is authorised to receive the data requested

Additional security will be provisioned using off site back-ups and hardware continuity planning

Data insurance can also be provided on critical data if required to give added assurance

Can you decommission non-SAP data in the Data Lock?

Yes – Using the SAP Information Lifecycle Management (ILM) , SAP Landscaoe Transformation (SLT) and  LWB tools we are able to store data (structured and unstructured)  from any non-SAP legacy application

PII Privacy Policy | Privacy Policy | © Copyright 2018 Proceed Group | Web design by Shaun Power Design