Variants and Selections #
Most queries allow entering selections before query execution.
Selections limit the result set of the Query so as to extract only records that match the selection.
A selection variant can be created in SAP at the selection screen of a Query. The purpose of a variant is to save selection settings. This minimizes the need to enter selections each time you run a query.
Note: Manual selections and variants can be combined. Manual selections overwrite any selections in the variant.
Choose a Variant #
- Click the small [binocular icon] (1). The window “Look Up Variant” opens.
- Select a Variant from the list of available variants.
- Confirm your input with [OK].
To remove the variant, click the [X] button (2).
Tip: You can dynamize the variant by using a corresponding parameter in the extraction URL.
Edit Selections #
This section corresponds to the query’s selection screen in SAP. Some selection fields only have a technical name and no description. To understand which field corresponds to a field in SAP, take a look at the query’s selection screen in SAP. Click on a selection field and press function key F1. This displays the technical name of a selection field.
In general, selection parameters overwrite the selected variant. This ensures that there are possible combinations for the selection.
Warning! Values must use the internal SAP representation:
Date: The date 01.01.1999 has the internal representation 19990101 (YYYYMMDD)
Year period: The year period 001.1999 has the internal representation 1999001 (YYYYPPP)
Numbers: Numbers must contain the leading zeros, e.g., customer number 1000 has the internal representation 0000001000.
Input that does not use the internal SAP representation results in error messages e.g.:
ERPConnect.ABAPProgramException: RfcInvoke failed(RFC_ABAP_MESSAGE): Enter date in the format _._._
- Click the [Edit] button next to the selection you want to edit (3). The window “Edit Range” opens.
- Choose if the selection is to be included or excluded (4) from the extracted data under Sign.
- Select an operator (Equal, GreaterThan, etc.) from the drop-down list under Option (5).
- Enter the selection in the respective Low and High fields. The High field is active for input when the between () or not between(][) operator was selected.
- Click [OK] to confirm the selections.
To delete a selection, click the button in the bottom left corner (6).
|”<=”||lower equal than|
|”>=”||greater equal than|
|”][”||not between (Intervall)|
|” * “||contains pattern (Like)|