How to Push Data from SAP Datasphere to SAP S/4 HANA on-premise Tables By using Odata

[Samiksha_mahore]

Hello SAP Datasphere Community,

I hope this message finds you well.

I am currently working on transferring data from SAP Datasphere to an S/4HANA On-Premise system and have encountered some challenges. I don't see an option to directly connect to the On-Premise system as a target in the replication flow. I also explored the data flow feature but found that direct imports to or from S/4HANA On-Premise are not supported.

For context, I have a table named "ZSALES_DEMO" in my S/4HANA On-Premise system his same table also exists in my Datasphere environment.I would like to push data from Datasphere into this On-Premise table. I understand that creating a Generic OData connection might be a potential solution. Can you confirm if it's possible to fetch data from Datasphere and push it into S/4HANA On-Premise directly by using odata connection?

Any guidance, documentation, or examples from those who have tackled similar challenges would be greatly appreciated. I’m eager to hear about your experiences and any recommendations you might have.

Thank you in advance for your help!

Best Regards,
Samiksha Mahore.

[MustafaBensan]

Hi Samiksha, for further context:

1) What type of manipulations must be performed in Datasphere and

2) What is the “future use” of the data after being pushed back into S/4HANA?

[MustafaBensan]

Hi Samiksha,

The reason why you don't see an option to directly connect to an On-Premise SAP S/4HANA system as a target in the replication flow is because this is not a supported flow, as the typical use case is to replicate from SAP S/4HANA to Datasphere and not the other way around.

Given you are transferring to a table named "ZSALES_DEMO", I assume the purpose is for a technical validation of data transfer from Datasphere to SAP S/4HANA for demo purposes.  While there would certainly be various technical approaches to achieve your desired data replication, the question to be asked first is what is the business use case for transferring data from Datasphere to SAP S/4HANA and does it make sense to do so?

Regards,

Mustafa.

[Samiksha_mahore]

Hi Mustafa,
Thank you for your response. This is a customer requirement. They want to pull data from S4hana on-premise, perform some operations in Datasphere, and then push the data back to SAP S/4HANA for future use.

Best regards,
Samiksha.