Use

You can analyze the data streams of a Data Basis with this function and correct any data inconsistencies if necessary. Data inconsistencies can occur, for example, if you make subsequent changes to Customizing settings – such as, inadvertently resetting number ranges for documents. In this example, the system would overwrite documents without warning.

We recommend that you use this function after tests and before the system is used live to identify and remove any inconsistencies as early as possible.

Prerequisites

You have authorization for authorization object R_UC_RECON (field CONS_AREA in connection with ACTVT ).

You have activated the Tools view in the Consolidation Workbench.

Features

The selection screen contains selection parameters for consolidation units, versions, time, and currency. In addition, you can use other characteristics to restrict the data selection within a consolidation area.

Which other characteristics and data streams are offered for selection depends on the fields contained in the data basis and the data modeling of the Consolidation Area . The system determines the relevant Customizing settings at runtime and dynamically forms the screen.

Note that the screen can contain an unusually large amount of fields due to the very extensive data model. This means you need to scroll down the screen to see all elements.

In the Technical Settings group box you define what exactly the function should do when you execute it:

The different subfunctions are used partly for analysis and partly to repair any inconsistencies of the data streams analyzed. Whereas the analysis functions have read-only access to the data basis, the repair functions also have write access. We recommend that you use the analysis functions first and depending on the results of the check implement the repair functions.

Display Records from…/Delete Records from... : You use these options to specify whether the system displays or deletes data records from the data basis. For both options, you also specify which data streams shown on the screen should be accessed by the function. Which data streams are shown depends on which data basis is assigned to the current consolidation area.

Compare Journal Entries with Totals Records : You can compare the aggregated totals from journal entries (data stream documents) and totals records with each other to check whether the aggregated journal entries and the relevant totals records match. The system checks whether:

Matching documents exist for the totals records.

Matching totals records exist for all documents.

The key figure values of the totals records are equal to the totals aggregated from the documents.

If you post documents in local currency only, differences in group currency are reported for information only and not as errors. These differences in group currency can be the result of a subsequent currency translation: In this case the document database contains documents for which no value exists for the key figure for group currency (when the group and local currency is different).

The key figures for group currency also do not contain any values in the totals records before currency translation. The key figures for group currency are written to the totals database after currency translation, which only operates on the totals. Since currency translation does not generate any documents, there are differences between the documents and totals records for the key figure group currency . This is not an error.

Amounts in group currency are not included in the comparison in the following cases:

Document type is translated to group currency or document type posts in group currency and additionally in local or transaction currency

Document type does not post in group currency, but in local or transaction currency and is not translated to group currency

At posting level 00 only totals records are managed and no journal entries. So a comparison is not useful for this posting level. If you still include the posting level in the comparison, the system warns you with a message.

Create Totals Records from Journal Entries : There is an inconsistency if differences have been established during the comparison of journal entries and totals records, which are not the result of a subsequently executed method, for example, currency translation with rounding. Possible causes are incorrect or subsequently changed Customizing settings (for example, a change to the Customizing of rounding).

At posting level 00 and in period 0, only totals records are managed and no journal entries. Use this option only if you have excluded posting level 00 and period 0 from the selection. Otherwise you could lose your reported financial data.

In principle, methods that only work with totals cannot reverse a task that has already been executed. Executing this method again does not correct the totals. Therefore, you must rebuild the totals records from the journal entries to create a consistent dataset.

Check Consistency of Document Numbers : You check the documents for the current selection. The system checks whether:

The documents contain sequential document line items.

The key figures in the documents have a zero balance.

The document contains more than one row (exception: statistical documents).

All characteristics that are normally constant for each document, are unchanged (characteristics fixed in the consolidation area, version characteristics, posting level, document type).

An appropriate offsetting line with (inverted) key figures exists for every line of a reversal document or an inverted document.

This check delivers reliable results only if you do not restrict the selection to specific financial statement items. Specifying certain items can cause document data to be read incompletely. This could result in error messages even if the document numbers are consistent.

Test Run : If you set this indicator, the system performs the analysis or repair run without saving any changes in the data basis. This provides you with an overview of the consequences of a repair and you can then decide whether you want to execute the function in update mode.

Activities

Go to the Tools view of the workbench.

In the navigation area, choose Transaction Data → Analyze and Repair Data Streams

Make the appropriate settings in the detailed area of the screen and choose Execute

Depending on the settings you made, the system analyzes or repairs the selected elements.

Check the results in the log. If the system performed an analysis and found inconsistencies, execute the function again with the necessary repair options.