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

[paulvatter]

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/c2dd92fb83784c4a87e16e66ab...)

"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

[paulvatter]

if someone is interested:

1. a temporary table is being created in the namespace "/BI0/05...", which seems to be reserved for trigger-tables according to https://wiki.scn.sap.com/wiki/display/BI/BW+temporary+database+objects.

2. still open, for a CDS-view with 30 mio records it works without any issues so far, other tests pending.

Best regards Paul