Skip to Content

SQL from ABAP & Calculation View retrieve different results.

Hi,

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?

Regards,

Gaurav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Regards,

    Add comment
    10|10000 characters needed characters exceeded