Skip to Content

ABAP CDS to Composite Provider - Data flow options.

Hi All,

Our current architecture is S4--> BW4HANA --> SAP Analytics Cloud

We would need to consume ABAP CDS views in BW4HANA and were looking at some of the options.

1. ABAP CDS --> Open ODS --> Composite Provider

2 . ABAP CDS --> BW Datasource --> aDSO --> Composite Provider

My questions are:

a. Is Option #1 supported? I could not find any reference to Open ODS connecting to S4 views but technically, I guess it should be possible- right?

b. Are there any limitations in Option #1?

c. Between Option #1 and #2 (if both work without any limitations), would the deciding factor be a tradeoff between performance and data footprint in BW?

d. From what I understand, SAC would require a BW Query on top of this Composite provider for data access. Is that correct?

Thanks in advance.

Shyam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 01 at 03:25 PM

    Hi Shyam,

    Please find my answers inline to the questions.

    a. Is Option #1 supported? I could not find any reference to Open ODS connecting to S4 views but technically, I guess it should be possible- right?

    Sure this is supported. Please look at the document here to understand how this needs to be done.

    https://www.sap.com/documents/2017/06/50b7535e-bf7c-0010-82c7-eda71af511fa.html

    If you are creating a query just on this CDS view, you wouldn't need to have a composite provider on top of this as queries could be created directly on the Open ODS View.

    b. Are there any limitations in Option #1?

    Please refer to the note https://launchpad.support.sap.com/#/notes/2198480 -- look at point 12 in this note which talks about the restrictions and what needs to be done to overcome them.

    c. Between Option #1 and #2 (if both work without any limitations), would the deciding factor be a trade-off between performance and data footprint in BW?

    Sure, the deciding factor would be the performance or data foot-print in BW . In this case though, the open ODS view would extract data using RFC connection, so the performance might not be as bad

    d. From what I understand, SAC would require a BW Query on top of this Composite provider for data access. Is that correct?

    SAC should be able to consume all of the infoproviders of BW. But we would need to validate on these providers as they are virtual.

    Best Regards

    Bhavani

    Add comment
    10|10000 characters needed characters exceeded