Skip to Content

Current logged in User Query for SAP B1 on HANA

Hi Experts,

               I am trying to achieve the current logged in user detail , below query  i tried on SAP B1 on SQL and it is working fine

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

but it is not working in B1 on HANA , I tried the below query

SELECT T0."U_NAME" FROM OUSR T0 WHERE T0."INTERNAL_K" = (SELECT CURRENT_USER FROM DUMMY)

any help will be appreciate

Regards,

Manish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 27, 2014 at 01:18 AM

    Hi,

    Please refer thread

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 08:27 AM

    Hi

    Check the below link

    How to know the current user LOGIN status in 9-Version

    With Regards

    Balaji Sampath

    Add comment
    10|10000 characters needed characters exceeded