Delta loading in SAP CPI based on the ABAP CDS view

[dirugadr]

Hello experts!

I have an integration request that needs to send "new" information from our S/4 Hana to an external system, using SAP CPI as middleware.

My first idea was to ask the ABAP team to create an ODATA service pointing to the data I have to get and handle the deltas using a timestamp field. So, every time I query the service, I'll add a condition like $filter=DTField > [LastValueStored in CPI].

Even when this approach will meet our requirements, I've seen that CDS views can include an annotation called "Change Data Capture", that allows you to handle the delta loadings in a more "transparent" way.

I find a lot of articles about this feature, and how to use it, but no one using CPI. I mean, it's clear that there's not a "CDS sender adapter", but I couldn't find how to use an ODATA service, created from a CDS view with this annotation, that can be queried from CPI.

I found this article: https://community.sap.com/t5/technology-blogs-by-members/delta-loading-in-sap-datasphere-based-on-th... and in there is mentioned something " ODP framework". Is this something that can be used with CPI?

Any piece of information about this will be very welcomed.

Regards

Adrián

[ajos]

Hi Adrian,

I haven't done this scenario yet. But it looks like it is possible using ABAP CDS->ODP->ODATA. SAP CPI can then use OData sender adapter to read the  OData service.

Here's a reference architecture from AWS - https://aws.amazon.com/blogs/awsforsap/sap-odp-based-change-data-capture-with-amazon-appflow-sap-oda... that shows how it is done. Here AWS appflow reads the data. In your case SAP CPI will read the data using the Odata adapter. 

Different querying options for odata including reading delta changes are mentioned here - https://help.sap.com/docs/SAP_NETWEAVER_750/ccc9cdbdc6cd4eceaf1e5485b1bf8f4b/50f4ee6253134d3cafa25b9...