on 01-08-2015 10:50 AM
Hi Experts, I need a little help.
I'm doing some calculations views here and I faced a problem: Calculations views are bringing data from all clients(mandt) of SAP.
To solve this I set default client in user that I'm using in SAP HANA in Adm Console and set default client option in Semantics to "Session Client". In graphical calulations views worked without problems but I can't find this option in SQLScript Calculation Views.
How can I do this SQLScript Calculation Views to client(mandt) work like Graphical Calculation View?
Thanks for any help,
Hi Fulvio,
you can read the session client with following statements.
DECLARE lv_client varchar(3) := '';
SELECT SESSION_CONTEXT ('CLIENT') AS lv_client INTO lv_client FROM DUMMY;
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot Florian! Worked fine.
I found a documentation about this in http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/e74dc875191014b20c81d140d67e42/content.htm
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.