New SCV validation rule type to check child records

There are several tables in SCV with the parent-child relationship. For example, SI_PROD_OPEN (header) and SI_PROD_OPEN_OP (child), or SI_ROUTING (header) and SI_ROUTING_INPUT_ITEM (child) tables.

Previously, it has been possible to check if a parent record exists for each child record. It is now possible to check if at least one child record exists for each parent record.

The newly introduced SCV validation rule type Children prevents parent records to be validated even though it does not have any children records. The new rule type is defined on the parent table and uses the FK - Foreign Key references from child tables to the selected parent table.

Currently, the system-defined validation rules of the new type are not delivered as part of the standard content.

Note: By default, this feature is enabled. A new role or privilege is not required to access this feature.