Copying Historical Data (SAP Library - Consolidation (FI-LC))

Copying Historical Data

The entries proposed by consolidation of investments always deal with the activities of a specific year (or range of periods for periodic consolidation). Therefore, the postings that occurred in the past, for example those for first consolidation, must be reconstructed.

You can perform posting for each of the previous years, or cumulatively for the year prior to the year in which consolidated financial statements are to be prepared for the first time. You need to carry forward the entries to the current year. Only those entries are then posted in the current year which correspond with business transactions for that year.

Perform the following steps for the previous year:

Maintain year and period of first consolidation in the Company Master

Create the subgroup and carry it forward into the current year

Enter the investment book values in the Changes in Investments table

Enter the equity book values in the Changes in Investee Equity table

Calculate group share

Enter hidden reserves (FVAs)

Complete all of the steps in Status Management

Post entries manually, or generate postings in the Consolidation of Investments program, and if necessary, intervene in the posting process when the batch input sessions are processed

Carry the postings forward using the Balance Carry-Forward program

Procedure

Company/Subgroup Maintenance

First, maintain the date of the first consolidation (year and period) as well as the amortization start date of goodwill for your companies in Company Maintenance or in Subgroup Maintenance, in a company-specific manner. Furthermore, maintain the subgroup for the previous year.

Table entry

Maintain the consolidation of investments-related tables to enable automatic postings in the Consolidation of Investments program (also see General Information on Table Maintenance). When creating manual postings to reconstruct the status of your old system, you only need to post the accumulated values of the changes since first consolidation up to and including the previous year. If, on the other hand, you want to use the program’s cumulative posting function, the historical detail must be entered for each year and period.

Status Management

Before starting postings, perform all steps of Status Management up to the end of currency translation first (see Managing the Consolidation Status).

Creating postings

If the date of first consolidation dates back several years, it is generally recommended to post the historical data manually. To receive an accurate amortization of hidden reserves for subsequent years, you can maintain the amortization accordingly using the data entry function in the table of Eliminated Hidden Reserves.

In simple cases you can generate the Consolidation of Investments program as a basis for posting with the option Batch input session. The name of the batch input session is listed on the last page of the log. Then run the session using the step System ® Services ® Batch input ® Edit. If you process this session with option A, you are able to change values and influence the document posting.

Alternatively, the system can post cumulative entries from the first year in the simple case of the purchase method. For further information, see the topic Transferring Historical Data in the section "Consolidation of Investments". For cumulative posting, you need to maintain a selected item under the classification key KKK. This should be the profit carry-forward item.

Balance carried forward

Carry forward the generated postings into the current year using the Balance Carry-Forward program (see Fiscal Year End). You have thus laid the foundation for subsequent consolidation which assumes that historical data has already been completely posted.