Control Totals
Definition
A control total is a figure calculated by the system, adding the values in one of the fields in a segment. This field is called the
Control totals key figure field. It must be a
numeric type
field. For example, if the control totals key figure field is
Local Currency Amount
in an FI line item segment, then the system adds up all values in the
Local Currency Amount
field, and that is the control total.
Use
You use control totals to verify the integrity of the contents of the data that has been extracted.
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.
Therefore, in addition the debits and credits indicator was defined as a grouping field.
The program
RTXWCHK4
can be used to check all the control totals for company codes and periods included in a data extract.
Example
The following example shows the use of the key figure and grouping fields in control totals.
Assume the following values:
Vendor |
Amount |
A |
1,000 |
A |
2,000 |
B |
4,000 |
B |
7,000 |
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).
Integration
While control totals help you verify the integrity of the data extracted based on its contents, checksums help you verify the integrity of the file containing the data extract.