How exactly ABAP external view over a HANA Calculation View works?

[srujan_gannamaneni]

Hey

I am facing a scenario where there is a calculated column in a Calculation View for which I have created an external view to consume the same in ABAP layer.

When I apply filter over this column at HANA View or in the SQL Console(using external view), The filter is working properly but when I am applying the same filter in ABAP, Its returning 0 Records.

Can you guys explain me how exactly the external view works?

[lbreddemann]

The first guess on "it returns results in HANA studio but not in ABAP" is: client dependency. Does the view filter for a session client?

[srujan_gannamaneni]

No its for a Cross Client.
Can u explain how exactly External view works when it gets executed in ABAP?

[lbreddemann]

Please provide the relevant code bits that you run in HANA Studio and in ABAP to produce the results.