Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Consuming CDS views in SAP BW


what is the best practice to consume a CDS view in SAP BW?

Example scenario - let's say we have an SRM system with embedded BW running on HANA. We have built some ABAP managed CDS Views on top of the SRM tables. Now we would like to reuse the results of those views in SAP BW - combine it with some other data loaded into BW from other sources, use the BW authorization concept etc.



Former Member
Former Member replied

Hi, Marek.

If CDS view have no input parameters (i.e. it is a common view inside DB, not a table function), you can import it into BW as OpenODS View based on the corresponding view inside HDB and use it for reporting. Then put it into Composite Provider in order to make transformations available (Composite Provider can be the source of a transformation, OpenODS View cannot). In such way you can consume also HANA information views.

But keep in mind, that OpenODS view is like a proxy object to HDB (not an ABAP dictionary), so it doesn't know of changes in its source. You have to keep changes in sync manually.

Another way is a Virtual Provider based on FM (inside FM you can use Dictionary-managed CDS) to work only with ABAP objects, but it looks to cumbersome and unnecessary.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question