Session Variables values in HANA DB SQL Queries

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.