Show TOC

 Verifying FI Control Totals

Use

DART allows you to use control totals to verify the integrity of the extracted data.

The FI document line item segment (TXW_FI_POS), which is a SAP-provided segment, is defined with control total fields. The Local currency amount field (DMBTR) is defined as the control total key figure for the segment, and the Debit/credit indicator field (SHKZG) is defined as the grouping field.

If a data extract includes FI document data, then the system calculates control totals for the TXW_FI_POS segment. It sums up all the values in the Local currency amount field for each of the Debit/credit indicator field values. The result is a control total sum for all debit amounts in all the FI document line items that were extracted, and a control total sum for all credit amounts.

If your system was open for posting to the FI document since the data have been extracted, then the extracted data may be outdated in that it does not contain all the data that should be retained for the period.

The item totals are also checked against the account balance data (segment TXW_BBACC in the extract and the table GLT0 in the online system).

You can use the FI control total values to check that no additional postings occurred since the data had been extracted. This utility provides you with a report comparing the data in the database with the control totals of the extracted data.

Prerequisites

The extracted file must include data for the FI document line item segment, meaning that the user that extracted the data must have selected the FI document for the extraction.

If you include data retrieved from an archive in the comparison, then make sure that the temporary archive retrieval tables have not been cleared since the data was extracted to the file you are comparing it with.

Procedure

  1. Choose Start of the navigation path Extras Next navigation step Verify FI control totals End of the navigation path

  2. Enter the following data:

    Field/Group

    Action

    Selection criteria

    Enter the company code and period for which to perform the check.

    Total per account type

    If this indicator is set, the totals are calculated separately according to customer, vendor and G/L account.

    If this indicator is not set, the total is calculated for the entire account type.

    Extract

    Enter the name of the extract file whose data you wish to compare with the database and its directory set.

  3. If required, choose the message type – Information, Error, Termination to be issued in the case of a negative result.

  4. Choose Execute .

Result

The system produces a report comparing the total amount of credits and the total amount of debits between the Local currency field in the database and the same field in the data extract file. It also compares the number of debit and credit records in the database and the extract file.