Skip to Content
Former Member
Jun 16, 2016 at 08:59 PM

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


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