Data Ageing and the Simplified Data Footprint
Data ageing is an S/4HANA mechanism that moves business-complete records from the in-memory hot area of a table into a compressed cold partition within the same database, reducing RAM footprint without deleting or archiving anything. The simplified data footprint refers separately to the removal of redundant aggregate and index tables in S/4, now consolidated into tables like the universal journal, which shrinks the database independently of ageing.
This page covers how ECC managed data volume through classic archiving and secondary index tables, and how S/4HANA instead separates two distinct mechanisms: table-level simplification that removes redundant aggregates, and data ageing that reclassifies old records as cold without moving them off the database. It focuses on why teams conflate the two, what breaks when custom code assumes ECC-era table structures, and what a conversion project must decide before go-live rather than after.
Published 16 Sept 2026· 1,135 words
Classic ECC behaviour
In ECC, database growth was managed almost entirely through classic archiving using the Archive Development Kit, run via SARA, per archiving object. Archiving physically wrote data out to archive files and deleted it from the database tables, after which it was retrievable only through the archive infocenter or by re-reading the archive files. Alongside archiving, ECC relied heavily on secondary index and aggregate tables to keep reporting fast on disk-based databases: BSIS and BSAS for open and cleared FI line items, BSID and BSAD for customer items, COSP and COSS for CO totals, GLPCA and GLPCT for profit center accounting. These tables existed purely to avoid full table scans on BSEG and the CO line item tables. Volume management was a Basis-led housekeeping exercise, run on a schedule, with functional teams occasionally consulted on retention periods. There was no concept of hot and cold data within a live table; a record was either in the operational database or it was gone into an archive file.
S/4HANA behaviour
S/4HANA changes two separate things that projects frequently treat as one. First, the simplified data footprint: HANA's calculation speed removed the need for most of the aggregate and redundant index tables listed above. FI, CO, and profitability data now converge into the universal journal, and the old tables survive only as compatibility views for backward-reading code, not as populated physical tables. This alone shrinks the database substantially, independent of any archiving or ageing decision. Second, data ageing is a new, separate mechanism that operates on tables like the universal journal itself. Once a record is flagged business complete by object-specific rules, a background job moves it from the table's hot partition to a cold partition. The record stays in the same table, on the same database, fully queryable by SQL and by ABAP Open SQL, but excluded from the in-memory working set that HANA keeps loaded, which is what sizing is based on. Data is not deleted and disk consumption does not shrink; only memory pressure and column-load time for reporting on the hot set improve.
Project impact
The two mechanisms hit different people in different ways, and the confusion between them causes most of the project pain.
- Custom ABAP or interfaces that SELECT directly from BSIS, BSAS, COSP, COSS, or GLPCA return nothing or partial data because those tables are compatibility views over the universal journal rather than populated tables; the fix has to be in the code, not in the data.
- Sizing teams who assume data ageing will shrink disk requirements are wrong; it shrinks memory requirements only, and a hardware sizing exercise based on that misunderstanding under-specifies storage or over-promises RAM savings to the business.
- Month-end and year-end closing jobs that do full-period scans across FI or CO line items can slow down once large volumes sit in the cold partition, because cold reads still happen, just at lower priority and with a decompression cost.
- Functional teams are asked to define what business complete means for their object (a closed FI document, a delivered and invoiced sales order, a settled CO object) and this decision, not a technical one, determines when and whether ageing produces any benefit.
- Authorisation and audit teams need reassurance that ageing is not archiving: nothing has left the system of record, so legal hold and audit trail obligations are unaffected, but this has to be demonstrated, not assumed.
Migration actions
Table simplification is not optional and is not a project task; it happens automatically during the technical conversion and is the reason so many custom objects fail the simplification item check.
- Run the simplification item check early and treat every finding that touches FI, CO, or MM aggregate tables as a mandatory remediation item, not a nice-to-have; this is a pre-conversion gate, not post-go-live cleanup.
- Inventory every custom report, interface, and extractor that reads BSIS, BSAS, BSID, BSAD, COSP, COSS, GLPCA, or GLPCT directly, and redirect them to the universal journal or its released compatibility views before cutover.
- Decide separately, and later, whether to activate data ageing; this is a sizing and cost decision that belongs with the technical architect and the Basis sizing exercise, informed by functional definitions of business complete per object, and it is genuinely optional.
- If data ageing is adopted, define and test the business complete logic per object in a volume-representative environment, because logic that never marks records complete produces zero ageing benefit despite the feature being switched on.
- Keep classic archiving in the roadmap regardless of the ageing decision; ageing addresses memory, archiving addresses disk and retention, and dropping archiving on the assumption that ageing replaces it leaves storage costs unaddressed.
Whose problem this is
Both. Table simplification remediation is technical, owned by whoever maintains the custom code touching legacy aggregate tables. The decision to activate data ageing is architectural, owned jointly by the technical architect running HANA sizing and the functional leads who define business complete per object; neither side can make that call alone.
Common pitfalls
The most common and costly misunderstanding is treating data ageing as a replacement for archiving. It is not; disk usage is unaffected, and teams that skip archiving on that assumption discover the storage bill has not moved at all.
- Test systems are usually a fraction of production volume, so cold-partition read performance issues in reporting and closing only appear once production-scale data exists, well after go-live.
- Business complete rules copied from a reference implementation without adaptation to local closing cycles or document flows either age nothing, giving no benefit, or age records still needed for open reporting periods, causing confusing gaps in current-period reports.
- Once ageing has run for a period, reversing the decision to deactivate it and reload everything into the hot partition is a real project of its own, not a configuration toggle.
- Custom code that assumes any record found via Open SQL is automatically fast forgets that a hit against the cold partition carries a real, sometimes significant, latency cost that shows up as a mysterious slowdown in month-end batch windows rather than a clear error.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-s4hana-changes/data-ageing-and-the-simplified-data-footprintERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.