cancel
Showing results for 
Search instead for 
Did you mean: 

Query using $[USER] changes to the id in the query on SAP b1 on HANA

Former Member
0 Kudos

Hi, we are using a fs that varies the results acording to the user, in the query we use this WHERE T10.USERID = (SELECT $[USER]), when we save it and open again in the query manager the query changes to WHERE T10.USERID = (SELECT 1), 1 being the user id of manager, anyone have a fix or sugestion??

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Just a correction we are using from dummy: T10.USERID = (SELECT $[USER] FROM DUMMY)