Extracting Delta from S/4HANA CDS View to Datasphere using Replication Flow

[puneetc]

Hi Experts 

Need your help. Here's the scenario we have a delta enabled CDS view and we use Replication flow (all one to one from CDS and target table in replication flow and the replication flow projection , no filters applied) to extract data from CDS view to datasphere. 

The number of records in CDS and also extracted in datasphere visible as Initial Load Operation in Data Integration Monitor matches but the records finally loaded to the target table in datasphere replication flow are different and less than the number of records that CDS view displays in output or even the number of records that are visible in initial Load operation

Here i am attaching the snapshot of two scenario which shows the target table records in datasphere and the Initial load operation in data integration matches vs the snapshot that has discrepancy. Please suggest why the records do not match as its all one to one between CDS and datasphere

Attaching the Png files for both the scenarios

your help and inputs will be much appreciated

@SAPSupport 

@junwu 

@Vera_Jiang 

@RaymondGiuseppi 

@William_Yu 

@DonWilliams 

@Chandan_ 

@vinaymittal 

@hoerzenbergers 

@mauriciolauffer 

[n_gaertner]

It could be (depending on the design of the CDS View) that the view contains duplicate records.
These duplicates would be eliminated due to the unique primary key constraint of the local table in Datasphere.

Without further details it is unfortunately hard to tell what happened.

[puneetc]

Thanks for the quick response.. we did download one of the CDS view data into excel and based upon the primary key we did not find any duplicate records.. please suggest what other details i could provide to give more insight to the problem

[n_gaertner]

If you have the possibility to download the cds view in excel from the source, then also download the view from datasphere into excel and compare the primary keys. If you find the keys that are missing you might be able to find out if there is a pattern. If you are not able to figure out the problem by yourself open a ticket for CA-DI-IS-ABA.