ODP OData Filters

This page shows how to filter data that is extracted by the ODP OData service type. Filters limit the result set of the ODP OData service type to extract only records that match the selection.

The ODP OData service type supports the following filter options:

• Single static value: Extract data that equals a single specified value.
• Single dynamic value: Extract data that equals a single value that is passed at runtime.
• Static interval: Extract data that lies within a specified range of two values.
• Dynamic interval: Extract data that lies within a range of two values passed at runtime.
• Multiple static values: Extract data that is part of a list of specified values.
• Multiple dynamic values: Extract data that is part of a list of values that is passed at runtime.

Apply Static Filters

To filter the data of an SAP OData service:

1. Open an ODP OData service type.
2. Open the Filters tab.
3. Click [Add Column Filter]. The window “Add Column Filter” opens.
4. Select one of the following filter types from the Filter Type dropdown:
   • Single: only extracts data that equals a single specified value.
   • Interval: only extracts data that lies within a specified range of two values.
   • Multiple Values: only extracts data that is part of a list of specified values.
5. Select the column that contains the values you want to filter from the Column dropdown.
6. Depending on the selected filter type, enter filter values:
   • Single: Enter the filter value directly into the Value input field.
   • Interval: Enter filter values directly into the From (start value) and To (end value) input fields.
   • Multiple Values: Enter the filter values, separated by commas, directly into the Static list input field.
7. Click [OK]. The window "Add Column Filter" closes.

The filter is applied and added to the list of filters.

Apply Dynamic Filters

Xtract Universal.iQ supports dynamic filters where filter values are passed to custom runtime parameters at runtime. There are two types of custom runtime parameters:

• Scalar parameters represent a single value.
• List parameters represent multiple values, separated by commas.

To create and apply custom runtime parameters in filters:

1. Open an ODP OData service type.
2. Open the Filters tab.
3. Click [Add Scalar] to add a parameter for a single value or click [Add List] to add a parameter that holds multiple values, separated by commas.

4. For scalar parameters: Select a data type from the Type dropdown:

   Type	Description
   Text	Can be used for any type of SAP field.
   Number	Can be used for numeric SAP fields.
   Flag	Can only be used for SAP fields that require an ‘X’ (true) or a blank ‘‘ (false) as input value.

5. Name the parameter by overwriting the default name (Parameter0...n) in the Parameter column.

6. Click [Add Column Filter]. The window “Add Column Filter” opens.
7. Select one of the following filter types from the Filter Type dropdown:
   • Single : only extracts data that equals a single specified value.
   • Interval: only extracts data that lies within a specified range of two values.
   • Multiple Values: only extracts data that is part of a list of specified values.
8. Select the column that contains the values you want to filter from the Column dropdown.
9. Depending on the selected filter type, assign runtime parameters:
   • Single: Switch to the Custom Parameter tab and select an existing scalar parameter from the Parameter dropdown.
   • Interval: Select existing scalar parameters from the From Parameter (start value) and the To Parameter (end value) dropdowns.
   • Multiple Values: Switch to the List Parameter tab and select an existing list parameter from the Parameter dropdown.
10. Click [OK]. The window "Add Column Filter" closes.

The filter is applied and added to the list of filters. Values are passed during runtime, see Runtime Parameters.

Remove Filters

To remove a filter from an ODP OData service:

1. Open the ODP OData service type.
2. Open the Filters tab.
3. Choose the filter you want to delete from the list of filters at the bottom of the menu.
4. Click Edit in the Edit column of the filter. The window “Add Column Filter” opens.
5. Click [Clear].

The filter is removed from the service.

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 \_.\_.\_