SAP OData service with mandatory parameters - where to declare in the TDV Data Source

[Philip du Maine 3]

One of the sources that we need to query is a SAP analytical OData service. For this a TDV OData Data Source is created.

Within this OData source, there are 2 mandatory parameters defined, namely ZCUSV_FOTO and ZCUSV_SUBYEAR. I cant find out where to declare those parameters in the TDV OData data source. As both are mandatory in the base url of the OData service, i need to define them. Not defining one of them ends up in an error message.

Can you tell me where i can input these mandatory variables in the created TDV OData Data Source

 

For refference/ as an example: The corresponding (internal) URL for the OData service is:

https://serverurl/sap/opu/odata/sap/ZSFIN_C03_Q0022_SRV/ZSFIN_C03_Q0022(ZCUSV_FOTO='P08',ZCUSV_SUBYEAR='2019')/Results

 

When running the OData source without the variables, the system gives the following error message:

Cause: [bRAIN/629] Voer een waarde voor variabele Subsidieaanvraag jaar in.

[Ajay Mundhra 2]

Are you able to access the below url on the browser or postman

https://serverurl/sap/opu/odata/sap/ZSFIN_C03_Q0022_SRV/ZSFIN_C03_Q0022(ZCUSV_FOTO='P08',ZCUSV_SUBYEAR='2019')/Results

If so then please try using the same url for TDV ODATA data source.