Getting S/4HANA Cloud Data via OData with ABAP CDS Views, with SAP CPI into SQL Server

[venkat_kodi]

Hi all,
We have new SAP S/4HANA Cloud as source system and we want to get this data via OData Services & ABAP CDS Views, with SAP CPI into SQL Server. How to get this S/4HANA data into SQL Server, please?

Regards,
Venkat.

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[PrasanthPadmanabhan · Accepted solution]

Hi Venkat,

If you want to utilize SAP Cloud Integration(Formerly SAP CPI), you can leverage the released APIs in SAP S/4HANA Cloud which are listed in API hub to pull the data you require and then send it to SQL Server. Additionally, if you want to pull the data from CDS views, you can create custom CDS views and pull the data by exposing the CDS views via custom communication scenarios.

You could do this by designing the iflow based on your requirement.

As an example, you can follow the blogs https://blogs.sap.com/2022/09/06/extract-and-integrate-data-from-sap-s-4hana-cloud-using-cpi-part-i/ and https://blogs.sap.com/2022/09/06/extract-and-integrate-data-from-sap-s-4hana-cloud-by-using-cpi-part...

Best Regards,

Prasanth