Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor


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-warehou...
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/327833022dcf42159a5bec55266...

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/7d2bae1d9f2643c3bbaa398d...

https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/bdedce5247a74b658d3eb7ca1e...

https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/af11a5cb6d2e4d4f90d344f58f...


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/2e84a10c430645a88bdbfaaa...

Creating Source System of type ODP:

https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/bdedce5247a74b658d3eb7ca1e...

 


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?

1 Comment
Labels in this area