Data Volume Management

Having a system running for months or years we need to properly maintain it. We need to ensure the system is available during business hours and performance is at the required level. As the system is growing together with your company, at one moment, you must decide what to do with data that is no longer used before migrating to S/4HANA system.

Growth in data volumes can be driven by numerous factors. As a result too much data tends to remain on the live database. In many cases, data that is never used is stored on the live database. Retaining too much data or keeping it when it is no longer useful or required can lead to rising IT costs, complex system management, and decelerated system performance.

Data Volume Management is the key process to be done to clean the unwanted data from your system.



If no actions are taken for the huge storage of unwanted data, your business is exposed to the following,

  1. Continued cost of higher storage of expired data
  2. Exposure to compromise/lost data during upgrade
  3. Declining performance of the systems


Data Types

Do I really require historical data for my current business scenario?

  • Volume:    The more data you need to store, the more complex these problems will become. What works cleanly for a small volume of data may not work the same for bigger demands.


  • Predictability:   You might not be able to predict your short- term or long-term storage needs. This makes it                       nearly impossible to respond with agility or                accurately forecast your future demand.



Data archiving is the process of moving data that is no longer actively used to a separate storage device for long-term retention. Archive data consists of older data that is still important to the organization and may be needed for future reference, as well as data that must be retained for regulatory compliance.

It is 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.


  1. Reduces the costs of memory, disk and administration costs.
  2. Ensures cost efficient system upgrades and migration.
  3. Improved system performance due to shorter response time.
  4. Reduces the cost of maintenance and run of growing application infrastructure.

2.How to perform Data Aging in S/4HANA?

Data aging is new possibility to manage outdated information and helps to move sets of data within a database by specifying a data temperature.

Hot data resides in current area of the database, when the warm / cold data is moved to historical area.

Data Volume Management Evolution

For performing data aging, carry out several manual activities defined as a series of process by SAP.


SFLIGHT data generation

For data aging using SFLIGHT data SAP prepared separate set of tables:

DAAG_SPFLI – Flight schedule


DAAG_SBOOK – Single Flight Booking

The idea in data aging is to partition hot and cold data in the system separately.

Partitioning object is a set of tables that will be partitioned together. In our case it consists of two tables: DAAG_SBOOK and DAAG_SFLIGHT:

Partitioning Objects

Before performing partitioning all the records reside in the current area.

Display hot and cold data

After carrying out several activities the hot and cold data are partitioned separately based on a selection criteria in our example (based on Starting and Ending Dates).

Display hot and cold data partitions of table

Tired of performing numerous activities to clean up the data? Here is an easy solution!

The best approach is to use an automated tool that when provided with your system credentials will automatically clean up the data and provide you with only the necessary data before migrating to HANA system.

Get in touch with Akilesh at to know more.

Supriya Ashok

Related Posts
Comments ( 2 )
  1. Prasad Maitra
    February 29, 2020 at 9:27 pm

    I am glad that I found this blog helpful because I am getting trained from a sap institute in Kolkata. the information provided offered me great benefits over learning about different sap technologies.

  2. yogesh
    March 4, 2021 at 5:11 pm

    The information on Hot, warm and Cold data is really interesting. Thank you for the blog

Leave a reply
Captcha Click on image to update the captcha .