Skip to Content

Query the current logged in user on SAP B1 HANA 9.3 PL05

Hi Experts,

How can I get the current logged in user detail on SAP B1 HANA? I tried the following query but it was not work

SELECT "USER_CODE" from "OUSR" WHERE "USERID" = $[user]

SELECT $[user] FROM DUMMY

Add comment
10|10000 characters needed characters exceeded

  • Hi Akina,

    Try this if you want the logged user from Sales order screen

    SELECT T0."U_NAME" FROM OUSR T0 WHERE T0."INTERNAL_K" = $[ORDR."UserSign"]


    Regards,

    Kennedy

  • Follow
  • Get RSS Feed

4 Answers

  • Jan 06 at 04:01 AM

    Dear Akina,

    Use the following menu option to check the current logged in users:

    Modules - Administration - Utilities - Connected Clients

    This will show you all the connected users and there system details

    Hope this information is useful

    Regards

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Dinesh,

      Thanks for your feedback. But, I mean, i want to get Current user login, aims to write query or notification.

      Ex: i login by account "manager". So, I want to know query to get account manager that login.

      For SAP - SQL, i know query for that. But for Hana I don't know.

  • Jan 07 at 05:03 AM

    Dear Akina,

    It is a FMS you need to assign this in a field on any screen.

    For example :

    Save this query and select a field from any marketing data click Alt + Shift + F2 assign this query when you click it will display the user name.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 29 at 05:28 AM

    You can see the list of all logged in users in the "Connected Clients" so why there is the requirement of query.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07 at 04:04 AM
    -1

    Dear Akina,

    I have this FMS to get current user in SAP B1 HANA : check if its working for you :

    SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = $[USER]

    Regards

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded