Archiving of Consolidation Total Records and Journal Entries (SAP Library

Archiving of Consolidation Total Records and Journal Entries

Use

You use archiving for consolidation totals records and consolidation journal entries to remove mass data you no longer need in SAP Consolidation from the database. By storing such data in a database, you can reduce the data volume.

If your database contains a great number of journal entries, you can archive these data records on a regular basis. If your system has sufficient storage space, you only need to archive your data records once every fiscal year.

Features

SAP Consolidation has the following archiving objects:

CONS_SUM for archiving and deleting totals records

CONS_ITEM for archiving and deleting journal entries

With these two archiving objects, you can archive and delete journal entries and totals records according to your selections in Variant Maintenance.

It is not possible to read from the archive or to restore journal entries and totals records to the database.

Archiving

You can only archive journal entries if

the selected period to be archived is closed and
the fiscal year immediately preceding the period to be archived has been completely closed.

The first quarter 2000 and all preceding fiscal years are closed.

Consequently, with quarterly consolidation, you can archive the journal entries from the first quarter 2000 as well as those from all preceding fiscal years.

Totals records can only be archived if

the corresponding journal entries have been archived
all periods of the selected fiscal year are closed
the preceding and next to last fiscal year are closed. This means, you cannot archive totals records from the current and the preceding fiscal year.

For example, if you archive a totals record in May and create new postings in June, the system creates a new totals record. This would lead to a second totals record for the same time period, and thus to inconsistencies.

You should only archive totals records, when you do not need them any more for reporting purposes.

Delete

You have two options for starting the delete operation:

You can perform the archiving and then start the delete operation manually.

You can specify that the system automatically starts the delete operation once the archiving session is completed (option Archive and Delete in the processing options).

In both cases, the system first performs the archiving for safety reasons (this means, it writes the data to an archive file); the system deletes the data from your database only in the second step.

Further Information

You will find additional information in the hints documentation for each action. In the application menu, choose the symbol , or choose Goto ® Hints.