Skip to Content

SQL from ABAP & Calculation View retrieve different results.

Apr 23 at 02:57 PM


avatar image


I have made a query using CL_SQL_CONNECTION class which fetches data from a Calculation View from the HANA DB. The number of results returned are less than the data preview of same calculation view.

I tried to configure the authorization trace according to note 1809199, but no luck. Nothing is captured in the trace file as well. I am not sure what privileges are missing.

Could any one please guide me on how should I proceed further to check what authorization/privilege is missing from the user?



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

1 Answer

ROBERTO Forti Santos Apr 24 at 09:03 PM

Hi Gaurav,

Has SAP HANA performed Union node?

In this case, going to the Properties of the corresponding data source and in the Mapping tab you can see "Empty Union Behavior" field value which was configured.


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Roberto,

No there is no union performed. Calculation View is simple SQL Calc view fetching data from just 1 table.