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