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

[darshansomaiah1]

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

[pfefferf · Accepted solution]

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

[darshansomaiah1 · Accepted solution]

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";