Product Information

Sarau Shen

October 9, 2019 1 minute read

Export data from SAC model to oData Service

Export to oData Service

You can create a connection that allows you to export data to data sources using oData services.

Export transaction data from SAC to BW

As the first user case for export data to OData Services, we support exporting data to SAP BW/4HANA 2.0 or BW 750 system using oData service(Refer to BW note 2838883 for detailed support packages). But we do NOT support exporting data to sources other than BW.

With oData services, user can:

Export fact data filtered by the selections to BW. Only BW Standard ADSOs with write change log (optional) and write interface-enabled are supported
Map dimensions between SAC and BW, or map a property of SAC dimension to that of a dimension of BW
Set default value for the dimension of BW if there is no source dimension to be mapped
Choose to export the data once, or on a recurring schedule.

SAC/BW Import & Export

User can import data from BW to SAC via BW connection, and can export data from SAC to BW via oData service connection.

15 Comments

You must be Logged on to comment or reply to a post.

Martijn van Foeken

October 11, 2019 at 9:23 am

Hi Sarau,

Can you contact me about joining the pilot program via martijn.van.foeken@interdobs.nl?

Thanks!

Kind regards,

Martijn van Foeken | Interdobs

Sarau Shen

Blog Post Author

March 3, 2020 at 6:24 am

Hi Martijn,

It's avaiable in BW4/HANA 2.0 SP04 now. You can refer to note 2838883.

Sarau

David Sinkmajer

October 23, 2019 at 9:41 am

Hi Sarau,

I would like to join the pilot program as well. Could you please contact me on david.sinkmajer@mibcon.cz.

Many thanks and regards

David Šinkmajer, MIBCON NDC

Lakshmi Narayana Nese

November 10, 2019 at 7:14 pm

Sarau,

I would like to join the pilot program as well. Could you please contact me on lnese@synergyinnovations.io . I am working on connectiong SAC with S/4HANA using oData for Pricing records update from SAC platform.

Thanks in advance.

Lakshmi Narayana N

Chciago IL

Andreas Reiser

February 17, 2020 at 8:11 am

Any news? When will this feature be available?

I can see the ODATA export connection in SAC, however, cannot find any documentation.

Henry Banks

March 3, 2020 at 8:34 am

hi Andreas

you raise a good point. I was looking at the 'fastrack' (biweekly) help pages in this area (Wave 5 2020 at time of writing) : https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.5/en-US/986358761788405e938e68204723676c.html

and indeed there is no mention of it yet!

I expect the 'mapping' and 'filtering' of the export will be broadly similar to BPC, S/4H, and IBP - these are all very similar in their approach.

However i think it's important that we ask Sarau Shen to ensure the documentation is brought into line. I will email internally also.

Thanks for bringing this to our attention.

regards,
H

Krzysztof Grzymala

April 6, 2020 at 10:31 pm

Hello all,

Documentation is here:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.8/en-US/6dc4ed164d174c3c862f88530af7e4fd.html

Regards,

Daniele Comincini

May 14, 2020 at 7:50 am

Hi Sarau Shen,

so it's not possible to export data from SAC to custom table on a database (es HANA) or on S/4 ?

Maybe you can clarify this doubt.

https://answers.sap.com/questions/13047591/export-data-from-sac-to-datawharehouse.html

Thanks in advance

Sarau Shen

Blog Post Author

June 8, 2020 at 6:12 am

Hi Daniele Comincini,

It's not supported currently. Exporting via oData service requires oData services implemented in target system. These oData services are only implemented by BW currently hence only BW is supported as the export target system.

Sarau

JS Irick

August 14, 2020 at 10:48 pm

Hi Sharau-

Can you explain your statement a little more? “These oData services are only implemented by BW currently”

oData is an open data standard, in what way would it only be implemented by BW? From having written an oData import connector into SAC, my current understanding is that SAC uses a somewhat custom fork of oData V2.

Are the SAP customizations to oData for export defined anywhere?

Respectfully,

JS Irick

August 15, 2020 at 5:06 pm

Hi Sharau-

I did some digging and I don't think this needs a response unless you have roadmap details on a real outbound connector.

The answer is that even at the $metadata level, there are tons SAP namespaced attributes (including redefining standard attributes), so a standard oData endpoint won't be able to be leveraged.

For example, here is an SAP BW/4 Entity Type

Respectfully,

Marcos Carvalho

September 28, 2020 at 2:09 pm

Hi JS,

Can you explain how did you get the $metadata level, please?

I’m trying to find an alternative way to export a SAC model, since SAC job for OData Services is only available for SAP BW/4HANA 2.0 or BW 750 targets. I hope to achieve this using a REST API to extract the model as JSON, however I need to access a model using URL.

Best regards.

Martin Stenzig

July 21, 2020 at 12:42 am

Is there any plan to export to generic Odata targets?

I want to get my planning data back into an SAP HDI container but there seemed to be no way to do that.

I a perfect world I would be able to save it on publish, but the standard Export to either HANA HDI container or generic OData 4 service would be good enough.

JS Irick

October 29, 2020 at 9:34 pm

Hello Sarau-

I have implemented the bgRFC endpoints that SAC uses in Python and would be able to support the HANA development team deploy a similar solution in HANA (via an XSC/XSA python buildpack). Please send me a direct message if you would be able to make the initial connections to make this happen.

Respectfully,

Ivan Sukhov

July 2, 2021 at 9:49 am

Hello, JS Irick, may you please tell me if there is any progress on this topic?

Product Information

Export data from SAC model to oData Service

Export to oData Service

Export transaction data from SAC to BW

SAC/BW Import & Export

Assigned Tags