Can you use oData to acces a .hdbtablefunction?

[former_member590866]

I tried to create an xsodata file where I have added the .hdbtablefunction as an entity, but I received the following error: "Unsupported object type ...". I thought that it might not work for hdbtablefunctions but I could not find anything regarding this topic. I need this because I have to replace the scripted views with table functions and expose the information using oData. Thank you.

[lbreddemann · Accepted solution]

If your table function should be executed with a constant or no input parameter, then you can simply encapsulate it into a view and expose the view via oData.

[former_member590866 · Accepted solution]

Thank you for the answer , I was hoping to avoid including it into a view, but I will do it since I have no other option.

[thomas_jung · Accepted solution]

XSODATA does not support Table Functions as a source entity. You must wrap them in a calculation view, hdbview, or CDS view in order first.