USE:
During full SAP end-to-end testing of an application interface, the final document that Int4 IFTT created in the SAP backend will be checked against the reference document stored during test cases creation. From the technical point of view, the validation is performed by comparing the selected database tables and table fields of both documents: the reference and the new one created during the test case execution. We make a business document’s database model representation and choose the tables, relations, and fields we want to be compared to achieve this. Optionally we can configure rules for matching original and new document lines and join conditions in more complex object models.
| Info |
|---|
The rules are configured per configuration object. However, it is possible to reuse the rules by another object without replicating the same configuration. To achieve that, the second object must refer to the first one by header field - reference object ID. In such a case, the second object needs to have variables with the same names as they are used by DB comparison rules. |
PROCEDURE:
- Database comparison rules are created per configuration object. Select the particular object by marking the row and double click on the Database Comparison Rules node in the navigation tree.
- Enter step numbers & database table names in which SAP business document is stored
The tables are processed in sequence based on Step number. Each step has following parameters:
...
See Selection Criteria subchapter to see how this selection works in detail.
| Info |
|---|
During S/4 HANA migration projects there might be a requirement to compare data which is no longer available in the same tables of the target system e.g. due to data model simplifications. For example status fields of Sales document which was stored in tables VBUK and VBUP in S/4 HANA is moved to VBAK/VBAP, LIKP/LIPS. Most of the time there is a compatibility view which allows to query the old tables also in S/4 HANA system. In case the compatibility view has different name you can maintain the mapping in /INT4/IMG > Landscape configuration > Table replacement configuration. In the example above VBUK data can be compared by maintaining compatibility view V_VBUK_CDS. |