Procedure documentation Setting Parameters for SQL Statements Locate the document in its SAP Library structure

Use

In the SQL dialog, you can set parameters for SQL statements. When you execute the SQL statement for which a parameter has been set, a dialog window opens in which you must enter a value for the parameter.

Procedure

  1. When you create an SQL statement, insert square brackets in all the places you want a variable entry to be possible.
  2. If you want to formulate a prompt for the dialog window, enter this prompt within the square brackets.

Example

Table Article with Article No. and Unit Price Columns

If you want to set parameters for the columns Article No. and Unit Price, you can set the following parameters among the selection criteria:

SELECT  "Article No.", "Unit Price" FROM "Article"
WHERE  "Article No." > [article number (from)]
AND  "Article No." < [article number (to)]
AND  "Unit Price" <= [upper price limit]

By setting parameters you can also replace entire sections of an SQL statement.

Example

You can formulate a SELECT statement and add a WHERE condition using a parameter:

SELECT * FROM USERS
[Your WHERE condition]

Note

If you specify a comparison value for the data type CHAR, VARCHAR, DATE or TIME, you must enclose the comparison value in single quotation marks.