Filters in Cross-Database Comparison
You can use various types of filters in the cross-database comparison to restrict the data that is compared. You can create filters for both source systems or for one source only.
Prerequisites
You have administration authorization for cross-database comparison (role SAP_CDC_ADMIN
).
Features
The following filter types are available in cross-database comparison. You specify the filters at source level for the relevant fields when you map the comparison tables (see Mapping Data Fields).
Filter Type | Comparison | Comparison Run |
|---|---|---|
Fixed filter with fixed values | You can define fixed filter values at source level, either for both sources or only one source. The value is used during the generation to create a hard-coded where-clause. | Fetches data from generated extractor using the hard-coded where-clause. |
Variable filter with variable values | The | The comparison run passes the filters to the extractor, which handles the filter values dynamically. |
Fixed filter with relative dates | If a filter for a comparison contains the syntax for relative dates (starting with $), it is not generated as a hard-coded filter in the extractor. | The comparison run translates the relative date syntax into an absolute time stamp and passes the filters to the extractor, which handles the filter values dynamically. |
Variable filter with relative dates | The You can maintain the relative date syntax (starting with $) in the comparison. The filters are used for all comparison runs of this comparison. | The comparison run translates the relative date syntax into an absolute time stamp and passes the filters to the extractor, which handles the filter values dynamically. |