Skip to content

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.

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 the column to filter from the Pick a Column to Analyze dropdown.
  5. Select one of the following filter operations from the Choose a Condition dropdown:
    • equals: only extract data that equals a single specified value.
    • is between: only extract data that lies within a specified range of two values.
    • matches any of these values: only extract data that is part of a list of specified values.
  6. Depending on the selected filter type, enter filter values:
    • equals: Enter the filter value directly into the Target Values input field.
    • is between: Enter filter values directly into the From (start value) and To (end value) input fields.
    • matches any of these values: Click + Add another value for each value you want to add.
  7. Click [Save]. The window "Add Column Filter" closes.

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

Runtime Parameters in Filters

Xtract Universal.iQ supports dynamic filters where filter values are passed to custom runtime parameters at runtime. To create and apply custom runtime parameters in filters:

  1. Open an ODP OData service.
  2. Open the Filters tab.
  3. Click [Add Scalar] to add a parameter for a single value.
  4. 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 the column to filter from the Pick a Column to Analyze dropdown.
  8. Select one of the following filter operations from the Choose a Condition dropdown:
    • equals: only extract data that equals a single specified value.
    • is between: only extract data that lies within a specified range of two values.
  9. Depending on the selected filter type, assign runtime parameters:
    • equals: Switch from the Value tab to the Parameter tab and select an existing scalar parameter from the Target Value dropdown.
    • is between: Switch from the Value tab to the Parameter tab and select an existing scalar parameter from the From Parameter (start value) and the To Parameter (end value) dropdowns.
  10. Click [Save]. 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.

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:

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


Last update: November 5, 2026