Selections

This page shows how to filter the data that is extracted by the Xtract ODP component. Selections limit the result set of the Xtract ODP component to extract only records that match the selection.

Edit Selections

Follow the steps below to edit selection fields and filter data:

1. In the subsection Fields, click Edit next to the field you want to edit. The window “Edit selection” opens.
   
2. Add one or more of the following filter types:
   
   • Click [Single] to compare the data to a single specified value.
     
   • Click [Range] to check if the data is (not) within a specified range of values.
3. 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.
   

4. In the column Option , select an operator. The operator filters data according to the table below.

   Operator	Description
   (not) like pattern	True if data values do (not) contain to the content of operand 1. Not not all ODP contexts and data sources support this option.
   (not) equal to	True if data is (not) equal to the content of operand 1.
   at least	True if data is greater than or equal to the content of operand 1.
   more than	True if data is greater than the content of operand 1.
   at most	True if data is less than or equal to the content of operand 1.
   less than	True if data is less than the content of operand 1.
   (not) between	True if data values do (not) lie between the values of operand 1 and operand 2.
   elements equal	True if data values are part of operand 1. This option is only available for type List.

5. In the column Value, enter values directly into the input fields Low and High or assign existing parameter to the selection fields .

   Note

   When parameters are available, you can use the icon button inside the input field to switch between static values ( ) and parameters ( ).

6. Click [OK] to confirm your input.

7. Click [Load live preview] in the main window of the component to check the result of your selection. If parameters are defined, you are prompted to populate the parameters with actual values.

The number of defined filters is displayed in square brackets next to the Edit option.

Use SSIS Variables in Selections

To use SSIS variables in selection, create a parameter as a placeholder for the SSIS variable. The parameter can be overwritten by an SSIS variable in the Custom Properties or Data Flow Properties of the component.

Follow the steps below to create a parameter in the Xtract ODP component:

1. In the main window of the component click Edit Parameters. The window “Edit Runtime Parameters” opens.
   

2. 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 runtime.
   

   Tip

   Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice.

3. Select one of the following data types from the drop-down menu. The data types may correlate to SAP data types.

   Type	Description
   Text	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 THAT require an ‘X’ (true) or a blank ‘‘ (false) as input value.

4. Click [OK] to confirm.

The parameter can now be used in selections and can be overwritten by SSIS variables in the Custom Properties or Data Flow Properties of the component.

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.

ERPConnect.ABAPProgramException: RfcInvoke failed(RFC_ABAP_MESSAGE): Enter date in the format \_.\_.\_