Datasphere Replication flow - Delta load of LO or SAPI extractor from ECC

[yatendra_soni]

Dear Datasphere Experts,

This pertains to the extraction of LO extractors (2LIS*) from ECC to a third-party target, such as AWS, using a "replication flow" facilitated by premium outbound connectivity.

According to SAP documentation, only an initial load is supported when the source object lacks a primary key for ODP artifacts.

Reference: https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/2267a9f6a5724ec0ae5632db4f...

Here are my questions:

1. What are the possible workarounds for this limitation, considering LO extractors (2LIS*) are widely used across organizations, and delta functionality is essential?
2. Is there a plan in SAP's roadmap (I couldn’t locate one) to provide delta functionality for all standard and custom extractions without primary key?

This is a common requirement as It work perfectly in SAP BW, and I believe it warrants attention. I would appreciate your guidance.

BR,

Yatendra

[Alpho]

Hi Yatendra,

We have a similar scenario where we need to get data from ECC to datasphere using standard 2LIS* extractors. What is the solution that worked for you? Were you able to establish the delta from ECC to Datasphere using 2LIS* extractors? Please advise.

Thanks,

Alpho

[Martin_Kuma]

Consider CDS views. Extractors are obsolete 🙂

https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/5418de55938d1d22e1000000...--> S/4 CDS views for extraction

Check OSS 2500202 as well. 

I also found a nice blog while searching: https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/cds-views-vs-lis-in-pm-how-to...

Cheers

Martin 

[yatendra_soni]

Thank you, Martin.

Currently, we are still on ECC and might take a few more years to transition to S/4HANA, where we can leverage CDS views instead of extractors. In the meantime, we are seeking a solution to continue utilizing SAPI extractors or any insights on SAP's plans for supporting delta functionality for extractors moving forward in replication flow.

[Martin_Kuma]

Hi Yatendra, right, you wrote ECC :). Means my response is irrelevant. I never had such a challenge, therefore can only suggest the following: 

#1 ABAP CDS views. Limited compared to HANA CDS, but still a good option. 

#2 try to create the delta in the DSP instead. Something like generic delta, but... you can do this only for tables/cds/ODP, not for the extractor self. 

https://community.sap.com/t5/technology-blogs-by-members/sap-datasphere-delta-extraction/ba-p/136993...

Approach will be complex and error-prone. Because you need to rebuild the extractor logic and the LIS ones are a level more complex then the rest due to the two-steps delta mechanism (I was always 'very happy' to enhance the LIS extractors. Getting a posting free time slot was always quite a long-run)  

#3 Can you try ODP? I am not sure if LIS can be used in ODP. 

Cheers,

Martin 

[yatendra_soni]

Thank you for analyzing the issue. The alternative solution appears to be quite complex, and in my opinion, Datasphere should ideally provide delta functionality for LIS / SAPI extractors. Regarding point 3, yes, we are using the ODP framework, and LIS can indeed be utilized within ODP.

[Martin_Kuma]

Here I found the similar issue

https://community.sap.com/t5/technology-q-a/migrating-from-sap-bw-to-datasphere-using-2lis-13-vdhdr-...