Skip to Content
-1

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 02, 2017 at 05:45 AM

    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

    Add comment
    10|10000 characters needed 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";