Show TOC

Function documentationSQL Query Details

 

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 Note

    If the mode on the Data Source screen is set to Query, this screen is enabled.

    End of the note.

Features

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.

Activities

You must select at least one table and one column.