The virtual table refers to a calculation view on a remote system (ABC).
Running a query on the calculation view directly returns the correct result.
But running a query on the virtual table (on XYZ) with HANA Studio or WINSQL, which refers to the same calculation view, it returns a single NULL value.
It is a Hana to Hana connection, so the "built in driver" is in use and connected was made with the same database user.
SAP HANA DB 2.0
smart data access, regional, settings , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.