You use control totals to verify the integrity of the contents of the data that has been extracted.

You must be familiar with the data in your R/3 applications to use the control totals figure calculated for the first extract. You compare this control total figure with a figure you calculate or estimate manually, or by using other means.

Sometimes adding all the values in a single field does not provide you with sufficient information. For example, if the control totals key figure field is an Amount field in a line item of a document, and it contains debit and credit amounts, then the resulting control totals figure may be zero. This is a positive indication that the credit amounts are equal to the debit amounts. However, this does not provide you with the actual sum of the debits or credits.

DART allows you to define a grouping field for calculating control totals. If you specify a grouping field for calculating control totals, then the system calculates a separate total for each possible value of the grouping field. If the grouping field is a field containing a debit and credit indicator, for example, then the system calculates one control total figure for all debit amounts, and one control total figure for all credit amounts. Using these you can verify that the amounts balance, and you can also compare the actual amounts to figures you estimate or calculate.

The program RTXWCHK4 can be used to check all the control totals for company codes and periods included in a data extract.

The following example shows the use of the key figure and grouping fields in control totals.

Assume the following values:

Using this example:

• If you specify Amount as the key figure field for control totals, then the control total is 14,000.
• If you specify Vendor as the grouping field for control totals, then the system creates one control total for Vendor A (3,000), and one control total for Vendor B (11,000).