cancel
Showing results for 
Search instead for 
Did you mean: 

Session Variables values in HANA DB SQL Queries

0 Kudos

I have a standard CDS View where Client Handling Annotation is set to below:

@ClientHandling.algorithm#SESSION_VARIABLE

Now, when I am performing a select query on the SQL View name I am not getting the dataset.

As I understand that the session variables for $SESSION.CLIENT is not filled and hence I am not getting any data.

The question I have now is, how do I feel session variables in HANA DB, I novice in this area so any help is appreciated.

Accepted Solutions (0)

Answers (1)

Answers (1)

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

See

https://blogs.sap.com/2018/04/03/abap-managed-database-objects-and-how-to-access-them/

Exactly because of this, you should not access the ABAP managed DB objects directly from HANA.