Is it possible to getting the data of the analysis query or report by Odata interface?

[former_member631468]

 There is a standard report named 'Production cost analysis' in S/4Hana Cloud. There is a requirement to obtain the analysis results of production cost by order and pass them to the third-party system. The Odata source for this report is FCO_PRODUCTION_COST_ANALYSIS_SRV.Is  it possible to getting the data of the analysis query or report by Odata interface? 

[Amith_Nair · Accepted solution]

Hi Ruirui,

Unfortunately, I could not find a whitelisted CDS view for Production Cost Analysis, although closest I could find was C_PRODUCTCOSTBYORDERQUERY, but this is not available as custom CDS view.

Now, you mentioned the OData source for this report is FCO_PRODUCTION_COST_ANALYSIS_SRV, however, this does not mean that this app is extensible. In On Premise world, they reference these services(ICF node) in the backend to activate and use the app, with Cloud it is not applicable, this is why you see these services under Configuration and not under extensibility 🙂

However, I would still suggest if you could search for the corresponding view in the app Custom CDS view, then you could expose this is as OData service to external system. Here is a blog that explains how you can expose a CDS View and consume as an API.

https://blogs.sap.com/2018/01/23/create-cds-views-in-sap-s4hana-cloud-and-consume-them-as-apis/

We would also encourage you to raise improvement request in the Influence portal in parallel https://influence.sap.com/

Good Luck!

Amith Nair

[Amith_Nair · Accepted solution]

Hi Ruirui

I forgot to mention a new feature that is available in our API hub: api.sap.com, where you will be able to identify CDS views segregated based on Line of Business, which is actually cool approach:-)

Here is a link in our community that explains how you can make the best use of it: https://blogs.sap.com/?p=746

Thank you! Amith Nair