Runtime parameters can be created in context of using the WHERE clause.
Runtime Parameters in the WHERE Clause Editor #
To create and assign runtime parameters, follow the steps below:
- In the main window of the component click Edit Runtime Parameters.
The window “Edit Runtime Parameters” opens.
- Click [Add Scalar] to define scalar parameters to be used as placeholders for actual values.
The placeholders need to be populated with actual values at extraction runtime.
Tip: Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice. - Click the drop-down menu (2) and assign one of the following data types to a parameter.
The data types may correlate to SAP data types.- String: Can be used for any type of SAP selection field.
- Number: Can be used for numeric SAP selection fields.
- Flag: Can only be used for SAP selection fields, which require an ‘X’ (true) or a blank ‘‘ (false) as input value.
- Click [OK] (3) to confirm.
- Navigate to the WHERE clause tab in the main window of the extraction and open the WHERE clause editor.
- Add a new WHERE clause criteria that uses the [Default with Parameter] template.
- Click on the Parameter component. A drop-down list that displays all available parameters opens.
Select a parameter from the list.
- To test the WHERE clause, click [Load live Preview]. Provide parameter values when prompted.
Runtime parameters are overwritten at runtime, see Extraction Parameters - Custom.
Runtime Parameters in Text Mode #
Add an @ symbol before the value to mark it as a runtime parameter, e.g., enter @myParameter instead of a value.
The marked value is overwritten at runtime, see Extraction Parameters - Custom.
Example:
T001W~WERKS BETWEEN @PlantLow AND @PlantHigh.
