Variants and Selections
Most queries allow entering selections before query execution. Selections limit the result set of the query to extract only records that match the selection.
A selection variant can be created in SAP, see SAP Help: Query Variants. The purpose of a variant is to minimize the necessity to enter selections when running a query.
Note
Manual selections and variants can be combined. Manual selections overwrite any selections in the variant.
Choose a Variant
Choose a variant from the drop-down-list Variant.
When creating a new variant in SAP after creating the extraction, click [ ] to load the new variant.
The selections of the variant are not displayed in the Selection Screen section of the window. To see the definition of a variant, open the variant in SAP.
Available Filter Options
You can enter filter values directly in the Xtract Query component or define SSIS variables to pass values during runtime.
The Xtract Query component offers the following filter options:
| Type | Operator | Description |
|---|---|---|
| Single | Compare data to a single specified value. | |
| (not) like pattern | True if data values do (not) contain to the specified value. | |
| (not) equal to | True if data is (not) equal to the specified value. | |
| at least | True if data is greater than or equal to the specified value. | |
| more than | True if data is greater than the specified value. | |
| at most | True if data is less than or equal to the specified value. | |
| less than | True if data is less than the specified value. | |
| Range | Check if the data is (not) within a specified range of values. | |
| (not) between | True if data values do (not) lie between the 2 specified values. |
Edit Selections
The Selection Screen in the main window of the component corresponds to the input screen in SAP.
Note
Some selection fields only have a technical name and no description. To understand which field corresponds to a field in SAP, open the input screen in SAP. Click on a selection field and press the function key F1 to display the technical name of the selection field.
Follow the steps below to edit selection fields and filter data:
- In the subsection Selection Screen, click [Edit] next to the field you want to edit. The window “Edit selection” opens.
- Click [Single] or [Range] to add a corresponding filter, see Filter Options.
- In the column Sign , select Include to add the filtered data to the output or select Exclude to remove the filtered data from the output.
- In the column Option , select an operator, see Filter Options.
-
In the column Value, enter values directly into the input fields Low and High or assign existing SSIS variables to the selection fields .
Note
When SSIS variables are available, you can use the icon button inside the input field to switch between static values ( ) and SSIS variables ( ).
-
Click [OK] to confirm your input.
Note that edited selection fields overwrite the selection fields in the variant.
Tip
If you use multiple selection parameters, it is more efficient to create a variant in SAP.
Data Format
Use the following internal SAP representation for input:
- 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.
Warning
Values accept only the internal SAP representation.
Input that does not use the internal SAP representation results in error messages.
Use the internal SAP representation.
Example: