The following section gives an overview over the settings that can be changed for the ODP component. The settings can be changed in the window “Define data source for SAP ODP”. There are two ways to open the “Define data source for SAP ODP” window:

  • Create a new extraction (see Define an Extraction with the “SAP Table or View” component as an example)
  • In the main window of the designer, choose an existing ODP extraction and click [Edit].

The settings are located the left side of the window “Define data source for SAP ODP” under subsections:

  • Operational Data Provider
  • Additional info
  • Update mode

    ODP Settings

Operational Data Provider #

shows the name of the source object

Additional info #

shows the ODP provider context

shows the data type of the source object

Update Mode #

Full update:
extracts the data in full mode

Note: The Delta update option is ready for input only if the ODP provider in the SAP source system supports delta updates.

Delta update:
runs a delta initialization, in case there is none for this subscriber. Runs a delta update, in case there already is a delta initialization for this subscriber.

  • On delta initialization
    checking the Extract data checkbox, allows extracting data when running a delta initialization. Leaving the checkbox unchecked runs a delta initialization without extracting data.
  • Auto-sync subscription
    allows deletion of the existing subscription and creates a new one if required. Each extraction has an internal ID, which is part of the subscriber. If you then change the filter of an extraction after the delta initialization, this option automatically deletes the existing subscription and creates a new one. A subscription is deleted if the error message “Illegal change in selection parameters” returns from the SAP system.

Delta recovery:
re-runs the last delta update

Subscriptions #

To display more details about the subscriber process, depending on the product, either click Show Subscriptions / Show active subscriptions at the top or at the bottom of the “Define data source for SAP ODP” window:


Tip: The information displayed in the “Delta Subscriptions for product” window can also be viewed in SAP transaction ODQMON.

ODP Subscriber

Column name Explanation
Queue Technical name of all subscriptions of a specific Theobald Software Xtract product (e.g., Xtract Universal).
Process Technical name of a subscription
R. (number of requests) Number of executed delta requests
Last request Timestamp of the last delta request
Created Timestamp of the init request

To delete a subscription click on the dustbin icon on the right side of the window.

Filtering - dynamic setting of the selection filters #

Filtering options are located in the window “Define data source for SAP ODP” under subsection Fields.
ODP Fields

The number of defined filters, e.g. [1], is displayed in the square brackets to the left of the field name under Selections.
Choose a field under Selections and click [Edit] to define a filter.
The window “Edit selection” opens.
ODP ABAP CDS View Filter Within the window “Edit selection” you can add new, edit and delete existing fiters.