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

[tejas_hatwalne]

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]

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]

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

[Martin_Kuma]

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...

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/be

[tejas_hatwalne]

Hi Martin
we have already created HANA On premise Connection in Datasphere side, but now question is that how to access S4HANa tables from that connection as that tables are not directly visible in that connection containers and we also found 1 way that we can create our Z table in HANA Db directly but that is not preferable as our main DB is HANA DB

[Martin_Kuma]

Hey Tejas, regardless S/4 of on-premise, or cloud, you have to use the HANA connection. If you cannot see any folders/schemas/containers, you may have an issue with authorizations. The Replication Flow allows you to push back from DSP. I use the RFC_DWC as target container. Fetching data from S/4 - via the HANA Connection- either data flow tables, or replication flow for ODP / CDS Views.. I do this on my own :). Works well. Check the link for the HANA connection. Martin

[tejas_hatwalne]

Hi Martin

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

Crave

[Martin_Kuma]

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...

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]

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