Skip to Content
Technical Articles
Author's profile photo Mahendrakumar D.P.

How To Get Login User Code in SAP B1 Query Manager

In SAP Business One, We can save Query we already created in Query Manager. We can use that Query for multiple purposes such as

  • Reporting,
  • Custom Alerts,
  • Custom Approvals and
  • FMS (Formatted Search)

To get Login User Code in SAP Business One Query and to Enhance the Query We just need to add $[USER].

Hana: SELECT T0.”USER_CODE” FROM “OUSR” T0 WHERE T0.”USERID” = $[USER]

SQL: SELECT T0.USER_CODE FROM OUSR T0 WHERE T0.USERID = $[USER]

 

Thanks,

Mahendrakumar

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ben Grassi
      Ben Grassi

      Is this only available as of 10.0?