To create SAP connection #

  1. In the main window of the Xtract Universal Designer. Navigate to the menu bar and select the menu item Server > Manage Sources.
    XU-Create-Connection-1
    The window “Manage Sources” opens.
    XU-Create-Connection-2

  2. Click [Add]. The window “SAP Source Details” opens.
    XU-Create-Connection-3-A
  3. Enter a freely selectable connection name in the Name (1) field.
  4. Enter the SAP connection details (2).
    • To connect to a single application server, fill the Host and System Number fields.
    • To connect to a message server using load balancing, fill the Message Server, Group and SID fields.
  5. Set the following parameters:
    • Client (Client) and language (Language) (3)
    • User (User) and password (Password) (4)
  6. Click [Test Connection] (5) to test the successful connection.
    The confirmation window opens.

Tip: If you don’t know the parameters, look in your SAP GUI or ask your SAP Basis.

The SAP connection is set up successfully.
XU-Create-Connection-3

To check the created SAP connection

  1. In the main window of the Xtract Universal Designer. Navigate to the menu bar and select the menu item Server > Manage Sources.
    The window “Manage Sources” opens.
  2. Check if created SAP connection is listed.
    XU-Create-Connection-4

To create 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] (1).
    Create-New-Table-Extraction
    The window “Create Extraction” opens.
  2. Field Source states the SAP connection. Choose the SAP connection you created previously from the drop-down menu (1).
    Table_or_View
  3. Enter a freely selectable, 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 “Define data source for SAP Tables” opens. In this window you can define simple table extractions or join tables for extractions. In the following example, a single table is extracted.

Adding tables #

  1. Within the window “Define data source for SAP Tables” click [Add] to add a table.
    Add-New-Table
    The window “Table Lookup” opens.
    Look-Up-Table
  2. In the field Table name (1) enter the name of the table to extract.
  3. Click [Search] (magnifying glass) (2). Search results appear in the preview window.
  4. Select the desired table (3) and click [OK] (4).

Tip: Wildcard such as * are supported. Make sure to place them after the name of the searched item.

The application now returns to the main window “Define data source for SAP Tables”.

Columns of the table retrieved from SAP are displayed in the subsection Fields.
Table-Form

Filtering tables #

You can select either all or only individual columns for extraction. All columns are automatically selected for table extraction. Deselect the ones you don’t wish to extract.
Click the header fields to sort the columns by name or description.
To search for a certain column name or description, start typing the word in the filter boxes.

Table-Main

Using live preview #

  1. Click [Load live preview] to load 100 records for preview.
  2. Click [OK] to confirm and save the extraction in the repository, i.e. on the server.