PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

How to Get Login User Code in SAP Business One Query Manager

How to Get Login User Code in SAP Business One Query Manager

In SAP Business One, we can save the query we already created to Query Manager. We can use that query again for multiple purposes such as :
• Reporting
• Custom Alert
• Custom Approval
• FMS (Formatted Search)
Here, we give you quick tips on how to get Login User Code in Query Manager, so you can enhance your query. In fact, It’s actually quite simple, but not many know yet. And, we are here to spill it for you. You just need to add $[USER] in your Query.
Example :

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

Result :

SAP Business One Tips - How to Get Login User Code in SAP Business One Query Manager

SAP Business One Tips – How to Get Login User Code in SAP Business One Query Manager

Now, you are ready to enhance your query for specific login users, good luck!

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , ,