cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC (SQL) access for CDS view that uses @ClientHandling.algorithm: #SESSION_VARIABLE

u0ila
Explorer
0 Kudos

Hello,

We try to use controlled access to S/4 HANA data using CDS views.

Some of Standard CDS Views (like I_MATERIAL oder I_BUSINESSPARTNER) use @ClientHandling.algorithm: #SESSION_VARIABLE to determine which set of data is to be returned.

We tried to set Client session variable using JDBC connection String, "jdbc:sap://ourHANAhost:31044?sessionVariable:CLIENT=200" but it didn't help.

The result to the query SELECT * FROM SAPABAP1.IMATERIAL is empty result set.

Are we doing something wrong?

Thanks in advance for any hint.

Sincerely

I. Lastric

u0ila
Explorer
0 Kudos

The result to the query SELECT * FROM SAPABAP1.IMATERIAL performed on the JDBC connection is an empty result set.

Are we doing something wrong?

We also tried setting default session client on HANA user, but it didn't helped either.

Thanks in advance for any hint.

Sincerely

I. Lastric

View Entire Topic
timgr
Newcomer
0 Kudos

Sorry for late response!

This was giving me problems too. Managed to find a solution though:

jdbc:sap://ourHanahost:31044/?autocommit=false&sessionVariable:CDS_CLIENT=200

Hope this helps someone else.