Tuesday, April 9, 2013

Referential Integrity

Purpose:
 
If u check the INTEGRITY box for any particular Object then.....the values which are coming are checked with masterdata table.......if the value are not existing in the masterdata then those records are not updated to the target..............

Example:

o    I will have all Customer numbers coming from R/3 to 0Customer....
If     If I am getting a transaction from non R/3 system...if in case that non-SAP system is having a Customer who is not defined in SAP ...... when you are loading data from non-SAP to BW you have to check Ref-Intg in transformations to omit records with a customer that is not there in 0Customer....