oData Query with parameters using Custom CDS view with I_GLAcctBalance

[SFY50013]

Hello Community,

we've developed a custom CDS view based on I_GLAcctBalance which comes with its parameters.

I managed to successfully read data through Postman with following oData query as discussed here with @Amith Nair and according to SAP note 2600276) :

https://..../sap/opu/odata/sap/YY1_XXX_CDS/YY1_ZZZZZ(P_FromPostingDate=datetime'2019-01-11T14:49:52'...

I'm now struggling to get it work from a custom integration flow. The oData adapter gives the parameters as CDS fields. Is there any standard iflow or discussion/blog link which uses a call to CDS view with parameters from an integration flow? I've searched Blogs without any luck so far.

Thank you

[MartyMcCormick · Accepted solution]

Hi Soufiane

What specific question(s) do you have? To use on CPI, create a security credential and then configure your CPI Sender adapter using request/reply integration pattern. This blog has a good screen shot https://blogs.sap.com/2018/04/10/s4hana-cloud-integration-commercial-project-part-2/

Scroll down to the line "In the receiver OData adapter" for a screen shot.

Basically, your Address would be: https://..../sap/opu/odata/sap/YY1_XXX_CDS/YY1_ZZZZZ

Then after entering your credential name you can press the "Select" button to browse and pick your entity you want to retrieve (i.e. "Results"). In your case, you can then enter filter criteria or you can click ok and on the main screen manually type in the parameters, i.e. : (P_FromPostingDate=datetime'2019-01-11T14:49:52',P_ToPostingDate=datetime'2019-01-12T14:49:52')

Thanks,

Marty

[SFY50013 · Accepted solution]

Hello Marty.

First, thanks a lot for your help. Actually, the oData adapter is a bit tricky when it comes to send a query with parameters. I managed to get it work by using the HTTP adapter. The blog you mentioned is interesting, i'll give it try via an oData service. Thank you