Selections

This page shows how to filter the data that is extracted by the Xtract ODP (OData) component. Selections limit the result set of the Xtract ODP (OData) 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. Select one of the following filter types:

   • Single : only extract data that equals a single specified value.
   • Interval: only extract data that lies within a specified range of values.

   

3. Enter values directly into the input fields or assign existing runtime parameters to the selection.

   Note

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

4. Click [OK] to confirm your input.

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

When a filter is defined, the filter statement is displayed next to the Edit option.

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