Entering content frameProcess documentationLegacy Data Transfer Scenarios Locate the document in its SAP Library structure

Purpose

The Implementation Guide for Consolidation features various tools for legacy data transfer, depending on your specific situation. Some scenarios are described in this document.

Process Flow

Scenario 1: Subsequent Posting of FI Documents

Assume the following situation:

The sender system has FI documents pertaining to the FI beginning balances as well as the day-to-day FI documents of the fiscal year. However, the FI documents do not have the necessary account assignments. The consolidation ledger (consolidation processing ledger, consolidation staging ledger, rollup ledger) already contain data, but it is incomplete - that is, realtime update is already activated.

Procedure:

  1. You customize the assignment of partner companies and consolidation transaction types.
  2. You delete the data that was posted in realtime from the consolidation ledger.
  3. You repost all of the FI documents. On the selection screen of the program you specify that the system should reread the missing assignments from the master data.
  4. You reconcile the reposted balances with General Ledger.

Scenario 2: Manual Entry of the Initial Data

Assume the following situation:

The transfer of legacy data into SAP General Ledger took place over a year ago. For this reason, the effort to repost all FI documents would be too great. It is also possible that the FI documents of preceding years have been archived and no longer exist in the system. No data resides in the consolidation ledger.

  1. You customize the assignment of partner companies and consolidation transaction types.
  2. In the consolidation ledger you manually enter the cumulative balances (including all necessary assignments) and post these to the highest prior-year period that was posted in General Ledger.
  3. You reconcile the entered balances with General Ledger.
  4. You carry forward the balances to the current fiscal year.
  5. You activate realtime update, which posts all FI documents of the current month to the consolidation ledger.
  6. You subsequently post the FI documents for the past months of the current fiscal year. On the selection screen of the program you specify that the system should reread the missing assignments from the master data.

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.

Scenario 3: Manual Entry of the Assignments in the Consolidation Staging Ledger

Assume the following situation:

All FI documents, including the FI legacy data, have been posted to the consolidation staging ledger, but do not contain all of the necessary assignments.

  1. You customize the assignment of partner companies and consolidation transaction types.
  2. In the consolidation staging ledger you enter the missing breakdowns for the existing totals records, using the highest period already posted. The system writes new data records.
  3. You delete the old data records.

Note

Please note that you cannot simultaneously post manual entries. Otherwise, update problems can occur. Therefore, you should organize a posting break during the time you post manual entries.

Result

The data in the consolidation ledger is now correct. Realtime updating of FI documents can now be performed and be transferred as reported financial data to SAP Consolidation.

Note

There are many other combination of the scenarios described above. You need to adjust your procedures to suit your situation when building your data.

 

 

Leaving content frame