cancel
Showing results for 
Search instead for 
Did you mean: 

How to Push Data from SAP Datasphere Back to SAP S/4HANA

tejas_hatwalne
Explorer
0 Kudos
475

Hello SAP Community,

I have successfully established a connection between SAP S/4HANA and SAP Datasphere, allowing me to fetch data from SAP S/4HANA into SAP Datasphere. In SAP Datasphere, I am performing ETL operations to clean and transform the data. Now, I need to push the transformed data back into SAP S/4HANA.

Here's a brief overview of my process:

  1. Data Extraction: I am extracting data from Table1 in SAP S/4HANA and l oading it into SAP Datasphere.
  2. ETL Operations: In SAP Datasphere, I am performing various ETL (Extract, Transform, Load) operations to clean and transform the data.
  3. Data Transformation Result: The result of the ETL operations is a new table, Table2, in SAP Datasphere containing the cleaned and transformed data.
  4. Data Pushback Requirement: Now, I need to push Table2 from SAP Datasphere back into SAP S/4HANA.

My Questions:

  1. What are the steps to push data back to SAP S/4HANA from SAP Datasphere?
  2. Are there any best practices or recommended methods for this process?
  3. What tools or features in SAP Datasphere facilitate the data pushback to SAP S/4HANA?

Additional Context:

  • The connection between SAP S/4HANA and SAP Datasphere is already established and working for data extraction.
  • I need to ensure that the data in Table2 in SAP Datasphere is accurately and efficiently pushed back to a new table in SAP S/4HANA.

Any guidance, detailed steps, or examples would be greatly appreciated. Thank you in advance for your help!

Best regards,
Crave Infotech

Martin_Kuma
Active Participant
0 Kudos

Hi there, did you try replication flow?

Replication flow allows you to push back. You need to ensure to have the authorizations for the container / schema of course. 

Martin

tejas_hatwalne
Explorer
0 Kudos
Hi Martin we tried Replication Flow but Its not working for S4HANA Cloud, Probably It's not Supported. Crave
View Entire Topic
tejas_hatwalne
Explorer
0 Kudos

Hi Martin


we tried Replication Flow but Its not working for S4HANA Cloud, Probably It's not Supported.

Crave

Martin_Kuma
Active Participant
0 Kudos

You are correct. You cannot push back to S/4 HANA. Neither on-premise, nor cloud.

https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/eb85e157ab654152bd68a87140...

Martin_Kuma_0-1723102020485.png

 

I could push back to S/4 on-premise with HANA Connection however using replication flow and then read the data again with a data flow... According to documentation, this is OK - HANA Connection is source/target. 

So I guess you need to create a HANA connection to your S/4 Cloud first. Then you will be able to push back as well. 

Can you post a screen shot of your connections? I bet you do not use the HANA connection.

 

What you need: 

https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/e6b63f176d3640609adcf06297...

 

what you have: 

https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/a98e5ffdf47c44d9a845dca01a...

 

tejas_hatwalne
Explorer
0 Kudos
We are using SAP HANA connection on datasphere side , as we come to know that SAP HANA is a database layer , but dont know how to create connection in S4hana on-premise platform, is there is any way? we are thought to create table in sap hana directly and then we can use that in datasphere