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 2: Source: SAP
Agenda is shown above

Figure 3: Source: SAP
Statement of direction for SAP Data Warehousing
“Your investment in BW is safe”

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 6: Source: SAP
Big picture – elements at play with SAP S/4HANA
S/4HANA, BW/4HANA, SAP Analytics on top of HANA
SAP SQL Data Warehouse
Integration options for Data Hub, Data Intelligence
Other systems

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

Figure 8: Source: SAP
Data integration options overview
This session looks at API/CDS views

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

Figure 9: Source: SAP
Summary of options on ECC and have BW and move to S/4HANA, how prepare extractors for move to S/4HANA

S/4HANA readiness check

Guide to use ABAP CDS views for provisioning in BW

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

Figure 10: Source: SAP

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

Figure 11: Source: SAP
How evolve CDS view extractor
Need extractor annotation
in S-API extractor – used to have model specific extraction (e.g. logistics cockpit)

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

Figure 12: Source: SAP
Since 1905 made change data capture available for cloud customers to connect S/4HANA cloud with BW on premise
Config on S/4HANA Cloud side and BW side

Links:

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

Figure 13: Source: SAP
SAP has developed a communication scenario
Steps required to set up communication
S/4HANA tile catalog for communication management
Create communication user, create system (SAP_COM_0042-designed for BW/4HANA communication)

Figure 14: Source: SAP
Create HTTP source system, to SOA manager to configure proxy

Figure 15: Source: SAP
Configure on premise source system

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

Figure 17: Source: SAP

Extract data in full or delta
Hierarchies are supported in full mode

Figure 18: Source: SAP
Open ODS view or persisted object in BW
Load data in BW using ABAP CDS view
Monitoring data load in BW/4HANA using BW/4HANA cockpit

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)

Figure 21: Source: SAP
What do when migrating
Guidance of steps

Figure 22: Source: SAP
Check status quo steps; what reports actually using?

Figure 23: Source: SAP
What to use where?