Skip to Content
avatar image
Former Member

XSOdata accessing Table Function in the calculation view

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/RemoteQueryExecution.cc:234"

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

Regards/Sudhakar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded