Skip to Content
0
Dec 26, 2014 at 08:24 AM

Current logged in User Query for SAP B1 on HANA

1804 Views

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