Show TOC

Function documentationFixed Query Details Locate this document in the navigation structure

 

You use FixedQuery mode for your SQL query in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbench to enter SQL code or execute stored procedures in the data source.

You can use the Fixed Query Details screen to do the following:

  • Select tables and columns

  • Enter SQL query text and query parameter values

You use the query parameters on this screen as input parameters for stored procedures.

Note Note

If the SQL query mode is set to Command, FixedQuery, or FixedQueryWithOutput, the Fixed Query Details screen is enabled.

End of the note.

Activities

You can enter the query manually or use the expression buttons to build the query. You must enter the query parameters manually.