best way to extract Purchasing data from S/4HANA Cloud to BW/4HANA

[former_member680235]

Hi,

currently there are several ways to extract batch (non-realtime) data from S/4 to BW/4:

• ODATA, REST API
• HANA/ABAP CDS Views
• ODP Datasources
• SDA, SDI
• ...

I need to implement a standard Procurement Reporting in BW/4 (EKKO, EKPO,...). With S/4, is still ODP Datasources the best way to extract data from S/4 Cloud to BW/4 or are there already some limitations compared to other extraction methods? So whats best?

Thanks & BR

Robert

[AndreasTenholte · Accepted solution]

Hi Robert,

it is a question how 'cloudy' your SAP S/4HANA Cloud solution is.

If we are talking about the pure S/4HANA Cloud Edition (that is the one where you do not have access to the ABAP layer of the S/4HANA system, only Web UIs provided) the answer is clear: use ABAP CDS views for extraction.

For purchasing there is one ABAP CDS view available for extraction including delta :

C_PURCHASEORDERITEMDEX (purchase order items)

For the less cloudy S/4HANA single tenant edition (which is kind of hosted S/4HANA onPrem), here you still have access to the ABAP layer via SAP GUI and you have the choice to use either the ABAP DataSources or the new ABAP CDS views for extraction.

All the best for your project,

Andreas

[vinaysaraf · Accepted solution]

Hi,

What if the BW/4 HANA is on Cloud as well? Do we still use CDS View and 0DATA adapter for extraction?

[AndreasTenholte · Accepted solution]

In case the SAP BW/4HANA is running as IaaS or as Private Cloud Edition, the integration to be used is still the same compared to SAP BW/4HANA on Premise: via ODP-SAP source system connection, after setting up the communication scenario to SAP S/4HANA Cloud.

[vinaysaraf · Accepted solution]

Thanks! So if S/4HANA is on cloud (IAAS) then we could still go-ahead with the application layer. So we could extract the data from S/4 HANA to BW/4HANA using the ODP/ODQ source connection