Product Information
Introduction to Extracting Data from SAP S/4HANA with ABAP CDS Views Webcast Recap
Figure 1: Source: SAP
This was a great webcast with SAP’s Eva Szabo and her colleague Dayanand Karalkar. It’s been a long time since we discussed extractors in detail on a webcast. Special thanks to Ingo Hilgefort for setting this up.
Figure 4: Source: SAP
BW/4HANA complements S/4HANA
Figure 5: Source: SAP
Natively integrate embedded analytics in SAP S/4HANA
Out of box connectivity
Embedded BW in S/4HANA – can it be used? It is not recommended for data outside of SAP; it has a technical function to support embedded analytics
It is not a BW for HANA solution
Link to blog https://blogs.sap.com/2015/11/23/unified-solution-sap-s4hana-embedded-analytics-sap-business-warehouse-powered-by-sap-hana/
Document: https://archive.sap.com/documents/docs/DOC-68337
See SAP Note https://launchpad.support.sap.com/#/notes/1661202
Figure 7: Source: SAP
High level architecture overview
CDS models for analytical/transactional purposes – CDS views also for embedded analytics, or bring data to BW
Past over 6K API extractors (still available)
Full cloud support is only for ABAP CDS views; API extractors are not available for S/4HANA Cloud
Documentation link: https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.9/en-US/327833022dcf42159a5bec552663dc51.html
SAP Note: https://launchpad.support.sap.com/#/notes/0002500202
SAP Note: https://launchpad.support.sap.com/#/notes/2232584
How to use ABAP CDS for Data Provisioning in BW: https://www.sap.com/documents/2017/06/50b7535e-bf7c-0010-82c7-eda71af511fa.html
Replication link:
https://archive.sap.com/documents/docs/DOC-55432
If your company is moving to S/4HANA Cloud, need to do additional configuration to extract to BW on premise
First wave content available in S/4HANA Cloud 1811, with each new release, new content
For on-premise can create your own extractors; not possible in S/4HANA Cloud
Links:
https://help.sap.com/viewer/788fa4c7585e415187e347e904010cee/1811.500/en-US/7d2bae1d9f2643c3bbaa398df8256c01.html
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/bdedce5247a74b658d3eb7ca1e6cb46a.html
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/af11a5cb6d2e4d4f90d344f58fa0fb1d.html
CDS views – used to use generic delta based on date/timestamp; expensive in terms of performance
With latest release of S/4HANA 1905 cloud and 1909 on premise, SAP uses change data capture, based on database triggers, similar to SLT concept
Initialize CDS view triggers, change data capture engine looks for inserts in tables included in CDS views and transferred using ODQ
Also used for Data Hub, SDI services
Move delta logic from app layer to database layer
Communication Management: https://help.sap.com/viewer/f544846954f24b9183eddadcc41bdc3b/1905.500/en-US/2e84a10c430645a88bdbfaaa23ac9ff7.html
Creating Source System of type ODP:
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/bdedce5247a74b658d3eb7ca1e6cb46a.html
Link 2716363, authorizations required explained in now
Figure 16: Source: SAP
For ABAP CDS view, when create extractor or find extractor, need to provide SQL name of ABAP CDS view
Add analytics data category annotation – master data, text data, hierarchy, transaction data
Extract data in full or delta
Hierarchies are supported in full mode
Figure 19: Source: SAP
How to find CDS views delivered from SAP – use view browser in S/4HANA – search for analytics annotation
What can be extracted – master data, text, hierarchies, transactions
ODP BADI’s – used to have user exits to enhance extractors from SAP; since it is now different, these are not applicable/possible
Figure 20: Source: SAP
Available content that contains the extractor annotation that makes them available as an extractor (can use S/4HANA view browser)
Thank you Tammy for yet another useful re-cap!