The following article shows how to use the Xtract ODP component of Xtract for Alteryx to load sales documents and customer master data from an SAP ERP system.

About this Workflow #

This article leads you through all necessary steps to set up the following workflow:

  • Load all customer master data from the SAP ERP system
  • Process the extracted SAP data
  • Load sales data using the delta mechanism of the Xtract ODP component

The delta mechanism of the Xtract ODP component allows loading only the added or changed data (since the last run) from an SAP ERP system.

SAP System SAP Objects Xtract for Alteryx Component
SAP ERP BW Extractors: 2LIS_11_VAITM (Sales Document Item Data) & 0CUSTOMER_ATTR (Customer Master Data) Xtract ODP

You can download the Alteryx workflow for this application in the Alteryx Community - ODP based Delta Extraction of Sales and Customer Data from SAP ERP with Xtract for Alteryx.

odp-workflow

Prerequisites #

Implement the following SAP notes to use the Xtract ODP component:

Delta Extraction of Sales Documents #

Follow the steps below to load sales data from your SAP ERP system:

  1. Drag & drop the Xtract ODP component into your Alteryx workflow (1).
    xfa_create_odp_extraction_01
  2. Select an SAP connection (2). If no SAP connection is available, create a new connection, see Online Help: Creating an SAP Connection.
  3. Click [Edit] (3) to open the main window of the Xtract ODP component.
  4. In the main window of the component click magnifying-glass. The window “Operational Data Provider Lookup” opens.
  5. In the field Name (4) enter the name of the sales data extractor: 2LIS_11_VAITM. Use wildcards (*), if needed.
    odp-lookup-sales-data
  6. Click magnifying-glass and select the 2LIS_11_VAITM extractor from the displayed list (5).
  7. Click [OK].
  8. Select the fields you want to add to the output of the Xtract ODP component. For more information on selections and filters, see Online Help: Xtract ODP - Selections and Filters. odp-extraction-sales-data
  9. In the section Update Mode select the option Delta Update to only load data from the SAP system that was added or changed since the last run. By default, the first run loads all data from the SAP system. Deactivate the On delta initialization option Extract data to prevent loading of any data on the first run.
    For more information on selections and filters, see Online Help: Xtract ODP - Update Mode.
  10. Click [Load live preview] (6) to display a live preview of the data without running an extraction.
  11. Click [OK] to save your input.

The Xtract ODP component can now be used to access and process the extracted SAP sales data.

Extraction of Customer Master Data #

Follow the steps below to load customer master data from your SAP ERP system:

  1. Drag & drop the Xtract ODP component into your Alteryx workflow (1).
    xfa_create_odp_extraction_01
  2. Select an SAP connection (2). If no SAP connection is available, create a new connection, see Online Help: Creating an SAP Connection.
  3. Click [Edit] (3) to open the main window of the Xtract ODP component.
  4. In the main window of the component click magnifying-glass. The window “Operational Data Provider Lookup” opens.
  5. In the field Name (4) enter the name of the customer master data extractor: 0CUSTOMER_ATTR. Use wildcards (*), if needed.
    odp-lookup-customer-data
  6. Click magnifying-glass and select the 0CUSTOMER_ATTR extractor from the displayed list (5).
  7. Click [OK].
  8. Select the fields you want to add to the output of the Xtract ODP component. For more information on selections and filters, see Online Help: Xtract ODP - Selections and Filters. odp-extraction-sales-data
  9. Click [Load live preview] (6) to display a live preview of the data without executing an extraction.
  10. Click [OK] to save your input.

The Xtract ODP component can now be used to access and process the extracted SAP customer data.