Skip to Content

How to change the annotations sap:filterable and sap:sortable for CDS referenced OData Services

Hello experts,

We are using SAP Gateway as interface for JAVA custom development. To have a documented interface contract and for better understanding, we are thinking of using $metadata/edmx as contract for our JAVA colleagues. This implies we want to have certain annotations always filled - such as sap:filterable - so we know how each interface can be called aka what functionality it has.

We implement OData in 2 flavours, for which the second gives confusion.

1) Code based implementations:

For Code based implementations, we can use the Gateway Builder properties setup, where we can indicate which columns of an entity are filterable.

2) CDS based implementations by means of adding a reference to CDS in Gateway project (hybrid project)

The problem here is that I see no way to generate sap:filterable annotations out of CDS?

It would be great to have annotation in CDS available that automatically maps to the OData annotation. We want to avoid adjusting the MPC_EXT class and program these annotations.

Thanks for the help!


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 31, 2019 at 08:31 AM

    Jelena Perfiljeva thanks for the feedback. I discovered the checkboxes ( properties ) are visible, but not editable ... so it will be set based on the CDS, view which makes sense in a way.

    I also believe this can not be configured via CDS, so not sure what the outlook for this is. Is this something worth creating a OSS message for, to make an official request of this functionality?

    Hopefully Andre Fischer could give some feedback.

    Add a comment
    10|10000 characters needed characters exceeded

    • I'm not an expert on this but using simple logic if some functionality is available in SEGW and a service can be generated from CDS then there should be something to enable the same functionality for the CDS-generated services. Especially since CDS is kid of a big deal. In general, I feel your expectation is valid and the only question is whether this functionality is well hidden or missing. If you don't get any answer here I'd suggest contacting SAP Support. If you do so, include a link to this question.

      Good luck!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.