Skip to Content
-1

How to design using graphical calculation model for User name (Session user) detail as output

Oct 01, 2017 at 04:51 PM

52

avatar image

Dear Moderators -

Before posting this question, I had referred the archived post on the same request, but it was not answered.

https://archive.sap.com/discussions/thread/3526738

Hence, request not to close this thread.

Dear SCN Team Members -

Please suggest on achieving a design via graphical calculation view for getting the output of User name (Session user) detail.

Currently, yes we can get it through TFs using a following SQL Script statement:

SELECT SESSION_USER FROM DUMMY; 

Thanks,

Nachappa S

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Oct 02, 2017 at 05:45 AM
1

The other option you have - if you do not wanna use a table function - is to create a view or a CDS view which determines the session user using the same SESSION_USER variable. Then you are able to use the view/CDS view as datasource in your graphical calc. view.

Regards,
Florian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you Florian for this approach!

Steps: Create a cds view MY_VIEW_SESSION_USER.hdbview which is in code section and then consume in a graphical calculation view.

It solves for not using TF consumption in a view.

schema="MYSCHEMA";
query="SELECT SESSION_USER
FROM DUMMY";
0