Skip to Content
0
Former Member
May 02, 2014 at 07:47 AM

Tracking who is login in sap b1 through the fms..

379 Views

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..