Check for Referential Integrity 

Use

The check for referential integrity occurs for transaction data and master data if they are flexibly updated. You determine the valid InfoObject values.

Prerequisites

The check for referential integrity functions only in conjunction with the function Error Handling on the scheduler tab page Update.

See also Treating Data Records with Errors.

In order to use the check for referential integrity, you have to choose the option Always Update Data... . If you choose the option Do Not Update Data..., you override the check for referential integrity. This is valid for master data (with flexible updating) as well as for transaction data.

Difference in Treating Data Records with Errors

Check for referential integrity	Treating data records with errors
For all data targets	For all data targets
Check in the transfer rules	Check according to update rules for each data target
Only for selected InfoObjects	For all InfoObjects
Error treatment	Terminates after first incorrect record
Possible for all ODS Objects	BW 2.0: Only for ODS objects for which BEx Reporting is switched on
Check against master data table or against an ODS object possible	Checked against master data table

 

Functions

The verification occurs after filling the communication structure and before filling the update rules. What is displayed in the InfoObject metadata is checked against the master data table (meaning the SID table) or against another ODS object.

If you create an ODS object for checking the characteristic values in a characteristic, in the update rules, and in the transfer rules, the valid values for the characteristic are determined from the ODS object and not from the master data.