Initial Data Set in the Consolidation Staging Ledg (SAP Library

Initial Data Set in the Consolidation Staging Ledger

Creating the initial data set in the consolidation staging ledger

The following scenarios assume that the initial data set is missing from the consolidation staging ledger. Depending on the situation, data for the current fiscal year may already exist in the ledger. This data contains the required additional account assignments, and so the master data is correctly maintained.

Scenario 1: Documents exist with additional account assignments

Documents for the initial data set and the current postings for the fiscal year exist in the FI system with the appropriate additional account assignments.

The following situations are possible:

No data exists in the consolidation staging ledger.

In the "Preparations for Consolidation" Implementation Guide, activate periodic extract and thereby the updating of the ledger. Then start the program for automatic posting of FI documents.

Data for the current year already exists in the consolidation staging ledger.

Ledger update is already active, but data is incomplete because the initial data set is missing. You can determine this by reconciling the consolidation staging ledger with the general ledger. In this case, proceed as follows:

If the initial data set exists in the current fiscal year, you only need to post the documents for the initial data set. In order to ensure that the data is now complete, you should reconcile the databases again.

Alternatively, you can delete the current data from the consolidation staging ledger data and then post all documents in full.

If the initial data set exists in the previous fiscal year, you need to perform a full posting of documents for that year. The system will then carry forward the ledger balance to the current year. You should then reconcile the databases again.

Scenario 2: Documents for the initial data set exist without additional account assignments

Both FI documents for the initial data set and the current postings for the fiscal year exist in the system, however the additional account assignments for the initial data set are missing from the documents.

The following situations are possible:

No data exists in the consolidation staging ledger.

Activate periodic extract and realtime update for the consolidation staging ledger.
Post the documents in full.
Enter the additional account assignments manually.

If the system cannot derive partner information from the master data, you will need to carry out further processing. You will also have to do this if the consolidation transaction has not been simultaneously assigned in the document. You need to enter additional account assignments manually in the latest period posted to in the fiscal year. The system writes new data sets with the additional account assignments. It compares the balances with those of the general ledger and identifies differences in old and new data sets caused by redundancy. You should delete the old data sets.

If you manually enter additional account assignments in a period which is not the latest period posted to, you will not be able to delete the old redundant data sets. The system will not delete the data sets; it will protect the values for subsequent data set periods. You should therefore manually enter the additional account assignments in the latest period.

Alternatively:

Activate the periodic extract and thereby the realtime updating of the consolidation staging ledger.
Post documents for the initial data set (period of the opening balance sheet). You should then manually enter the missing additional account assignments and delete the old data sets.
Post documents for the next period.

If the initial data set lies in the previous year, you will need to carry forward the balance to the current year.

Data for the current year already exists in the consolidation staging ledger.

Ledger update is already active.

Delete data from the consolidation staging ledger, then follow the procedure described in the previous point.

If the data for the current year cannot be re-posted (if it is not possible to organize a posting stop), it is recommended that you manually create the final data set for the previous year in the latest period posted to in that year and carry forward the balance to the current fiscal year. To ensure that data is complete for the current fiscal year, you should reconcile the consolidation staging ledger with the general ledger.

Scenario 3: Documents for the initial data set have already been archived

Documents are no longer available for subsequent posting to the initial data set.

You should manually enter the final data set for the previous year with its additional account assignments in the latest period posted to in that year, then carry forward the balance for the ledger.

The following situations are possible:

Data for the current year already exists in the consolidation staging ledger.

Ledger update is therefore already active. You should reconcile the consolidation staging ledger with the general ledger to ensure that data is complete.

If differences are found during reconciliation, data for the current year is incorrect. You should therefore delete data for the current fiscal year.

Carry forward the balance again. Then post the documents for the current year.

If no differences are found during reconciliation, data for the current year is correct.

No data for the current year exists in the consolidation staging ledger.

You should activate periodic extract in the "Preparations for Consolidation" Implementation Guide. Then post the balances for the current year. If the documents have already been archived, you will need to manually enter the balances for the current year.

Initial data set already exists in the consolidation staging ledger, but additional account assignments are missing

Additional account assignments may be missing from initial data set postings or in the postings for the current year.

If the additional account assignments are also missing in the postings for the current year then the master data has not been correctly maintained. In this case you need to maintain the master data in the "Preparations for Consolidation" Implementation Guide.

You should manually enter the breakdowns in the latest period posted to. The system writes new data sets with the additional account assignments and you should delete the old data sets.