You use the SQL Query Details screen in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbench to do the following:
Select tables and columns
Enter selection, filtering, ordering, and grouping criteria
Note
If the mode on the Data Source screen is set to Query, this screen is enabled.
The join, filter, sort, and group expressions can be entered manually.
If you enter a DateColumn parameter value, the system automatically appends the appropriate SQL syntax for the date range configured on the Date Rangescreen.
You must select at least one table and one column.