Creating an Extraction #

The following example shows the creation of an extraction using “SAP Table or View” component.

  1. In the main window of the Xtract Universal Designer click [New].
    Create-New-Table-Extraction The window “Create Extraction” opens.
  2. Field Source (1) states the SAP connection. Choose the SAP connection you created previously from the drop-down menu (1). Table_or_View
  3. Enter a unique name for your extraction (2).
  4. Choose the type of extraction. In the given example: SAP Table or View (3).
  5. Click [OK] (4) to confirm. The window “Extract Single and Joint SAP Tables or Views” opens.
    In this window you can define simple table extractions or join tables for extractions. In the following example, a single table is extracted.

Note: When creating an extraction, the http-csv destination is automatically assigned to the extraction.

Look up a Table #

  1. In the main window of the component click [Add] to add a table. The window “Table Lookup” opens.
    table_main-window_add
  2. In the window “Table Lookup” enter the name of the table to extract (1). Use wildcards (*) if needed.
    Look-Up-Table
  3. Click magnifying-glass (2). Search results are displayed.
  4. Select a table (3) and click [OK] (4).

All relevant metadata information of the table is retrieved from SAP. The application now returns to the main window of the component.

Set Up a Table Extraction #

Set up the Table component to extract SAP tables:

  1. Select the columns you want to extract. By default all columns are selected. Deselect the columns you do not want to extract.
    Table-Form
  2. Optional: Define a WHERE clause or a HAVING clause to filter table records. By default all data is extracted.
  3. Click [Load live preview] to display a live preview of the first 100 records.
  4. Click [OK] to save the extraction.

You can now run the extraction.