Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
replied

Hi,

Please refer thread $[User] alias for SAP B1 on HANA

Thanks & Regards,

Nagarajan

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question