Skip to Content
0
Jul 03, 2019 at 10:13 PM

ABAP CDS View: Delta-dataExtraction with detectDeletedRecords / functionality & huge tables

857 Views Last edit Jul 04, 2019 at 07:32 AM 2 rev

Dear CDS-experts :)

I have some questions regarding the CDS-annotation "Analytics.dataExtraction.delta.byElement.detectDeletedRecords"

SAP help states following (under https://help.sap.com/viewer/cc0c305d2fab47bd808adcad3ca7ee9d/7.5.13/en-US/c2dd92fb83784c4a87e16e66abeeacbd.html)

"By using this annotation, the system will remember all key combinations of the view that were extracted in delta mode. If a key combination does not occur in the view anymore, this will automatically generate a delete image in the extracted data."

1. How and where is "the system" storing all extracted key combinations technically? Is there any table being created for the keys of each CDS view which has this annotation and which is being extracted? Can this be displayed for checking purposes?

2. Can someone share any experience on extracting such CDS views using ODP CDS into SAP BW/BW4 (according to https://www.sap.com/documents/2017/06/50b7535e-bf7c-0010-82c7-eda71af511fa.html) especially regarding extraction performance while determining deleted records in huge CDS views with > 500 mio records...

Thanks in advance and best regards

Paul