by Vasiliy Kharitonov
You can use SQL Command Editor to execute a custom SQL query. Open it via
ST04, navigate to Performance -> Additional Functions -> SQL
Command Editor. There you can provide your query in the textarea Input Query.
Then press Execute (F8) to send it to the database.
SELECT COUNT(*) FROM "/SCWM/ORDIM_C" WHERE “LGNUM”='0001' will
show how many completed tasks there are in the warehouse number
This can be useful to create complex reports with joints of multiple tables automatically analyzing data with the certain perspective. Result can be easily exported to an Excel sheet via corresponding button.