ABAP-Specific Session Variables in SAP HANA

light111ABAP-Specific Session Variables in SAP HANA

Session Variables are global variables of the database system that contains information about the current context. SAP HANA DB has special ABAP specific session variables whose counterparts matches with the ABAP system fields.

Access in AMDP Methods

The predefined function SESSION_CONTEXT( )  is used to access the session variables of SAP HANA database . Few session variables are as below:

CLIENT                                   –   sy-mandt

APPLICATIONUSER            –   sy-uname

LOCALE_SAP                       –   sy-langu


How they can be Accessed:

SESSION_CONTEXT(‘CLIENT’) 

SESSION_CONTEXT(‘APPLICATIONUSER’)

SESSION_CONTEXT(‘LOCALE_SAP’)   

Example:

METHOD get_session_variables_amdp 
                                    BY DATABASE PROCEDURE FOR HDB 
                                    LANGUAGE SQLSCRIPT. 
  clnt := session_context(‘CLIENT’); 
  unam := session_context(‘APPLICATIONUSER’); 
  lang := session_context(‘LOCALE_SAP’); 
ENDMETHOD.


Access in CDS Views

Syntax – $Session.vname  can be used in CDS views to access the ABAP-specific session variable. The VNAME are as below:

client                               –   sy-mandt

user                                 –   sy-uname                     

system-language      –  sy-langu


Example:

@AbapCatalog.sqlViewName: ‘CDS_SESSIONVAR’ 
define view CDS_SESSIONVAR_DEMO
   as select from demo_expressions {  

         $session.client                         as sys_client,
         $session.user                           as sys_user 
         $session.system_language   as sys_language     
        }


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s