Consistency Check of Transaction Data

Use

The system performs specific checks when creating transaction data to ensure that the data remains consistent.

Features

Transaction data is automatically checked for consistency whenever transaction data is created – both in manual posting and automatic posting, and also in automatic data collection. The individual checks are discussed below.

Note Note

You also can use the function Breakdown Check and Correction of Transaction Data to manually trigger the checking of already posted data records (for example, after changing breakdowns). The breakdown check performs the checks listed below for the data streams that contain the characteristic with the role financial statement item .

End of the note.

Checks for Each Data Record

The following checks are performed for each data record (these are discussed in detail later):

Overview: Consistency Checks of Transaction Data for Each Data Record

No.	Consistency Check	Totals Records and Documents(*)	Additional Financial Data That Contains Characteristic with Role Item (Investments, Equity, Inventory Data, Supplier Data)(*)	All Other Additional Financial Data
1	Is master data contained in the data record?	X	X	X
2	For characteristics with activated validity check:Is master data valid?	X	X	X
3	Do characteristic combinations exist (consolidation unit, partner unit, investor unit, investee unit)?	X	X	X
4	When a validity check is activated for characteristic combinations:Are characteristic combinations valid?	X	X	X
5	Is the local currency key in data record the same as in the consolidation unit?	X	X	X
6	Does the posted entry contain a value for the characteristic with the role consolidation unit ?	X	X	X
7	Does the posted entry contain a value for the characteristic with the role financial statement item ?	X	X
8	Are the subassignments of the breakdown type compatible with the settings for the document type, posting level, and data stream type?	X	X
9	When posting to posting levels 02, 12, 22, or 30:Is the characteristic with the role consolidation group being posted to? When posting to other posting levels:Is the value for the characteristic with the role consolidation group initialized?	X
10	If the currency keys are the same:Are the values in the currency fields equal?	X
11	Specific checks in additional financial data		X	X

(*) Checks for totals records and documents, and for additional financial data with the characteristic with the role financial statement item are performed by the breakdown check .

The Individual Consistency Checks in Detail

No.	Explanation
1	Is master data contained in the data record? The system checks if master data exists. This check is independent of the data stream.
2	For characteristics with activated validity check: Is the master data valid? In the data basis on the Authorization/Validity Check tab page, you determine whether and to what extent the system performs validity checks. The following options are available for each characteristic: No check Time-dependent check Version-dependent check Time- and version-dependent check If you choose “no check” for all characteristics, no checks are performed for the characteristics. These checks are independent of the data stream.
3	Do characteristic combinations exist (consolidation unit, partner unit, investor unit, investee unit)? For example, if there are two characteristics with the role consolidation unit , the system checks whether the data record uses any permitted combinations. This check is independent of the data stream.
4	If a validity check is activated for characteristic combinations: Are the characteristic combinations valid? In the data basis on the Authorization/Validity Check tab page, you determine whether and to what extent the system performs validity checks. For characteristic combinations, the same options exist as for “simple” characteristics: No check Time-dependent check Version-dependent check Time- and version-dependent check This setting applies to all characteristic combinations. For example, the system issues an error message if a value exists for a characteristic combination, but not for the date or version you specified. These checks are independent of the data stream.
5	Is the local currency key in the data record the same as in the consolidation unit? The check is performed for all data streams that contain the currency key.
6	Does the posted entry contain a value for the characteristic with the role consolidation unit? The consolidation unit field must be filled.
7	Does the posted entry contain a value for the characteristic with the role financial statement item? The item field must be filled.
8	Are the subassignments of the breakdown type compatible with the settings for the document type, posting level, and data stream type? For each data record, the system checks whether a subassignment complies with the breakdown category. For example, the system issues a message if the breakdown category requires a transaction type, but the data record does not contain this transaction type. If necessary, the system overrides the breakdown category settings depending on the document type, posting level, and the data stream type. Examples: If entries are posted with a document type with the use consolidation of investments , then the investee unit must always be specified. A partner unit must always be specified when posting two-sided elimination entries (posting level 20). The additional financial data for investments must always contain the investee unit. Breakdown checks automatically make the following corrections: If no breakdown is stipulated, but the data record contains a breakdown, the system removes the breakdown and issues an informational message. If a financial statement item has a breakdown but a default value is stipulated, the system automatically writes the default value to the data record. For more information, see Breakdown Check and Correction of Transaction data .
9	When posting to posting levels 02, 12, 22, or 30: Is the characteristic with the role consolidation group being posted to? When posting to other posting levels: Is the value for the characteristic with the role consolidation group initialized? Note: The consolidation group is not a subassignment.
10	If the currency keys are the same: Are the values in the currency fields equal? This check is performed if the local currency is the same as the group currency, or the same as the transaction currency.
11	Specific checks in additional financial data Examples: In additional financial data for investments with activity “reclassification”:In reclassifications the system checks that there is only one selling and one buying consolidation unit. When an elimination of interunit profit/loss in transferred inventory processes a supply chain, the system checks that all supplier shares are positive.

If any errors are discovered in checks 1 through 9, the system always issues error messages. For check 10, the system issues an informational message.

Checks for the Entire Document

In addition to the checks for each document line item, the document data stream includes the following checks with regards to the document as a whole:

Does the document (excluding the statistical items) balance to zero?
Depending on the document type settings: Is the sum of the statistical items equal to zero?
Are the values on the selected items compatible (clearing item for balance sheet, clearing item for income statement, deferred taxes)?