SAP HANA SESSION VARIABLES ABEXA

Get Example source ABAP code based on a different SAP table

SAP HANA, ABAP-Specific Session Variables
This example demonstrates potential Native SQL reads on session variables on the SAP HANA database.

ABAP_SOURCE_CODE
DEMO CL_DEMO_HANA_ABAP_VARIABLES

ABAP_DESCRIPTION
This class calls the following methods of the class CL_DEMO_HANA_SESSION_VARIABLES:

GET_SESSION_VARIABLES_EXEC_SQL
METH CL_DEMO_HANA_SESSION_VARIABLES=>GET_SESSION_VARIABLES_EXEC_SQL This method calls the built-in function SESSION_CONTEXT for the four ABAP-specific session variables on the SAP HANA database in three static Native SQL statements between EXEC - ENDEXEC. The result is returned as a column of the SELECT list of an access to the pseudo table DUMMY.

GET_SESSION_VARIABLES_ADBC
METH CL_DEMO_HANA_SESSION_VARIABLES=>GET_SESSION_VARIABLES_ADBC This method replaces the static Native SQL statements of the preceding method with corresponding Native SQL statements in ADBC.

GET_SESSION_VARIABLES_AMDP
METH CL_DEMO_HANA_SESSION_VARIABLES=>GET_SESSION_VARIABLES_AMDP This method is an AMDP method and shows how the result of the built-in function SESSION_CONTEXT can be used directly in SQLScript.