Data Aging on SAP HANA

If cold data is accessed, will the partition(s) be loaded to the in-memory part of SAP HANA?

Cold partitions make use of Paged Attributes. While ordinary columns are loaded entirely into memory upon first access, Paged Attributes are loaded page-wise. Ideally only the pages that hold the requested rows are being loaded. In the context of data aging/cold partitions there are only a few (release dependend) constraints which columns cannot be paged: Some…

Is it possible to modify the data in cold partitions?

Yes, you can modify historical data. But usually, business complete data is aged, so modifications are exceptionally rare.

How to enable the data access of cold data in ABAP?

You can enable data access from historical area by using the classes CL_ABAP_SESSION_TEMPERATURE and CL_ABAP_STACK_TEMPERATURE

What are typical tools to administer Data Aging in SAP S4/HANA?

Several ABAP transactions are available for Data Aging. A detailed list can be found in the SAP Help Portal Data Aging – Data Aging Transactions. Additionally Data Aging can be administered via the following Fiori applications: Manage Data Aging Groups Monitor Data Aging Objects Database Table Growth

Can the customer define own Data Aging Objects?

Mainly the SAP application suggests and delivers Data Aging Objects and Partition Objects. However,  there is a list of Data Aging objects and enhancements provided by the individual SAP application in the transaction Data Aging Objects (DAGOBJ). Customers can implement their own Aging-Objects only for custom tables. The Data Aging Framework provides APIs to implement-Aging Objects….

What Data Aging Objects are currently available?

In SAP Business Suite on HANA only Basis Documents are available for Data Aging like e.g. Application Log, IDocs, and Workflow. In SAP S/4HANA Basis and Application Documents are available for Data Aging like e.g. FI Document, Material Document, and Billing Document. A complete list of all available objects can be found in the SAP…

On which Technologies is Data Aging based in SAP HANA?

Data Aging in SAP HANA uses: Time selection partitioning: The column, _DATAAGING, is used to split tables into one hotand some cold partitions No uniqueness checks: The uniqueness checks on the cold data is switched off (the application will enforce uniqueness) to improve performance Page-loadable columns/Paged attributes: The memory management of an attribute is based…

How does Data Aging in SAP S/4HANA function technically?

The data aging mechanism for ABAP applications is based on a new data aging framework provided by SAP NetWeaver ABAP. ABAP developers use this framework to specify the data aging objects that are aged as one unit, to identify the involved tables, and to implement the logic for determining the data temperature. The data temperature…

What is cold data?

Historical data is data that is not used for day-to day-business transactions. By default, historical data is not visible to ABAP applications. It is no longer updated from a business point of view. The application logic determines when current data turns historical by using its knowledge about the object’s lifecycle. The application logic validates the…

What is hot data?

Current data is the data relevant to the operations of application objects, needed in the day-to day-business transactions. The application logic determines when current data turns historical by using its knowledge about the object’s life cycle. The application logic validates the conditions at the object level from a business point of view, based on the status,…

How to include Data Aging statistics into the Early Watch Alert (EWA)?

A chapter on data aging was designed, which displays the activation status and the ratio between current (hot) and historical (cold) data. This ratio will give an indication in which extent data aging is implemented. The prerequisite is having software component ST-PI with Support Package 4 or higher. For earlier support packages it is required…

What needs to be considered during sizing?

The potential on how much the SAP HANA memory footprint can be reduced by the usage of Data Aging is estimated by the sizing report available in SAP Note 1872170 – Business Suite on HANA and S/4HANA sizing report.