hi.
i need a small information..
ie.
through the fms i want to know who is login into the sap b1...
SELECT T0.[U_NAME] FROM OUSR T0 WHERE internal_K = $[user]
i am running above quey it is working fine the answer is 'manager' ok
i have one more requirement i want to track employee details using fms i am running below query..
SELECT T1.[lastName] +' ,' +T1.[firstName] FROM OUSR T0 INNER JOIN OHEM T1 ON T0.USERID = T1.userId WHERE T0.U_NAME IN('MANAGER')
working fine..
but if if use
below query i am not able to get the data
what is the mistake i have done.....
SELECT T1.[lastName] +' ,' +T1.[firstName] FROM OUSR T0 INNER JOIN OHEM T1 ON T0.USERID = T1.userId WHERE T0.U_NAME IN('SELECT T0.[U_NAME] FROM OUSR T0 WHERE internal_K = $[user]')
i need your valuable suggestion..