Matrix validations/substitutions process tables of information simultaneously. This function allows you to create a validation or substitution in which individual lines of a table are compared with each other.
Example
1.
A validation of FI invoices can be used to check that the combination of accounts used is valid. It does so by comparing the contents of each line of the invoice with all the other lines.
Example
2.
You can create a validation to check that the total amount posted to one account matches the total amount for another specified account.
To use this function to its fullest capacity, you will have to write user exits in some cases.
Example
A validation step for a complete FI document can either check each BSEG line one at a time or it can determine the average amount for each line by checking all BSEG lines in parallel.
Matrix validations/substitutions are available for:
1. The complete FI document
2. Legal consolidation reports
3. Management consolidation reports
The user interface is almost identical to the user interface for standard validations and substitutions.
Note
: The trace and simulation functions cannot be used with matrix validations or substitutions.
Note
: You should not use fields belonging to a table-like structure (e.g. BSEG) other than the MATHS-construct in matrix validation conditions, since a check does not take place for each line, other than by using a user exit. Fields in a one-dimensional structure (e.g. BKPF) can, however, be used.