Session Context in HANA SQL AMDP
In recent times we have to use one of the standard interface to do some calculation but we need to pass additional data to this interface but as this is a standard interface we can’t enhance the method parameters(though it is possible to enhance it with optional parameters but the decision is not to disturb the standard interface) . Normal ABAP method we can use SET/GET technique do it but in AMDP with SQL SCRIPT its slightly different.
The below post talks about how to use SET and get by using SESSION_CONTEXT ( ) and UNSET.
Below is a class with few methods- and one AMDP procedure SET_INPUT( )- uses the SET command to put into the session.
Another AMDP Procedure – UNSET_INPUT( ) – clears the session value
and inside GET_INFO( ) – procedure using the function SESSION_CONTEXT( ) we can get our own value. By default few of the session parameters like CLIENT, APPLICATIONUSER, LANGU and SYS DATE are available in a AMDP procedure and similarly we can set our own.
Test Report Program ..
The value is read using SESSION_CONTEXT( ) and passing its ID.
Here is the O/P->