Legacy Data Transfer (SAP Library - Consolidation (EC-CS))

Legacy Data Transfer

Use

The initial data must be accurate before starting to transfer operational documents via realtime update to the consolidation processing ledger, the consolidation staging ledger, or the rollup ledger (all of which are referred to as "consolidation ledgers" in this text). This concerns both the initial data (legacy data) and the account assignments that are specifically needed for consolidation.

Initial Data

Usually the customer has legacy data from earlier accounting systems when implementing SAP General Ledger. After the implementation team transfers this data to SAP General Ledger, you can start posting entries in the transaction applications for the current fiscal year.

If you start using SAP Consolidation after you are already using SAP General Ledger, and you want to use integrated data collection, you need to transfer the legacy data as well as the FI postings that have already occurred as the initial data for the consolidation ledgers. You will most likely post cumulative (or year-to-date) balances to generate the beginning balances.

Consolidation-related Assignments

When SAP General Ledger is implemented, customers often transfer the legacy data only as cumulative balances. These balances usually do not include the assignments that are specifically needed for consolidation purposes. In particular, this includes partner assignments and consolidation transaction types.

The FI postings of the current fiscal year only include these assignments if the following customizing settings have been made:

The company IDs have been inserted in the vendor, customer and G/L master records.
The consolidation transaction types have been assigned to the asset accounting transaction types.

You must add any missing assignments in the appropriate consolidation ledger.

Features

Various tools are available for preparing the data.

Subsequent Posting of FI Documents

You can adjust the FI documents if they have not yet been archived.

For information on subsequent postings in "non-consolidation" ledgers, such as the profit center ledger, see the documentation of the corresponding component, for example, Profit Center Accounting.

You can perform subsequent posting in the consolidation processing ledger or the consolidation staging ledger in the Implementation Guide under Integration: Preparation for Consolidation ® Preparation in the Sender System ® Tools for Building the Initial Data ® Subsequently Post FI Documents :

For subsequent postings in the consolidation processing ledger you need to make the following settings in Activating Data Transfers :

Integrated consolidation type Company Consolidation or Business Area Consolidation
Data transfer method Realtime Update'

For subsequent postings in the consolidation staging ledger you need to make the following settings in Activating Data Transfers :

Integrated consolidation type Company Consolidation or Business Area Consolidation
Data transfer method Periodic Extract or Rollup

If consolidation-related assignments are missing in the FI documents to be subsequently posted, you can specify in the subsequent posting program that the following assignments should be reread:

Company ID from the customer, vendor and (if applicable) G/L account master records
Country of the customer from the customer master record
Consolidation transaction type from the assignments to the asset accounting transaction types

Note

Please note that you cannot simultaneously make subsequent postings in the period in which operational documents are posted. Hence, you should only subsequently post in past periods, which have been closed for operational postings.

Manual Data Entry

If the FI documents are already archived, you must enter the initial balances manually in the consolidation ledger.

Note

When posting manually to the consolidation staging ledger, please note that simultaneous posting is not permitted. Otherwise, update problems can occur. Therefore, you should organize a posting break during the time you post manual entries.

Deleting Transaction Data

If the consolidation ledger contains incomplete data, it usually makes sense to delete this data and repost the FI documents.

Matching the General Ledger with the Consolidation Staging Ledger

You can reconcile these two ledgers to ensure that all G/L data has been posted to the consolidation staging ledger.