Skip to Content

XSOdata accessing Table Function in the calculation view

May 15, 2017 at 03:42 PM


avatar image
Former Member

Hello Friends

I am new to SAP HANA world.

We have built a calculation view, which uses a table returned by a table function. Table function uses WORKDAYS_BETWEEN, for calculating the working days between two dates.

Now, this calculation view is being exposed via XSODATA. We are getting an error, when calling this oData service. "remote query execution failure: could not read working days information from table TFACS "DEV_LTD"."TFACS" - at ptime/session/dist/"

Has anyone come across such a similar situation? The calc view without this table function is being exposed without any issues.

Thanks for your inputs/suggestions for a break through of this error


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
May 16, 2017 at 03:00 AM

So what is the issue here? As according to your description the table function does not work and a proper error message is provided you just have to fix this. As mentioned in the documentation for the WORKDAYS_BETWEEN function, you need the factory calendar table TFACS. As it seems you do not have provided it in your schema.


10 |10000 characters needed characters left characters exceeded