USE:
Selection criteria are used to fetch relevant records from tables specified in the previous step. For each table, it must be specified how the rows should be selected based on values stored in variables or fetched from records from preceding steps. Technically the configuration is used to prepare WHERE conditions for database queries. The queries that will be generated will be used to fetch references and newly created documents.
PROCEDURE:
- For edited configuration object, select step in the DB Comparision rules screen:
- Double click on Selection Criteria
- Add selection criteria to the particular table selected in step 1.
...
SELECT * FROM VBAK WHERE BSTNK = value from PO_ORDER_NUBER, for example 'PO123'.
Example 2. We would like to fetch all order items for headers that were fetched in the first example.
The tables representing business document (The DB comparison rules screen):
...