Xtract Hierarchy
This page shows how to use the Xtract Hierarchy component. The Xtract Hierarchy component can be used to extract Hierarchies and InfoObjects from SAP BW systems.
Note
To extract hierarchies from a BW system, use the Xtract Hierarchy component. To extract hierarchies from an ERP system like ECC or S4, use the Xtract ODP component.
Prerequisites
- A connection to an SAP system is available, see SAP Connection.
- The SAP user has sufficient user rights, see SAP Authority Objects.
Warning
Missing Authorization.
To use the Xtract Hierarchy component, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects accordingly.
Add an Xtract Hierarchy Component
Follow the steps below to add an Xtract Hierarchy component to your workflow:
- Drag & drop the Xtract component to your Alteryx workflow .
- Assign an existing SAP connection .
- Click [ Edit] to open the main window of the component.
The majority of the functions of the component can be accessed in the main window.
Look Up a Hierarchy
- In the main window of the component, click [ ]. The window “Hierarchy Lookup” opens.
- Enter the name of a Hierarchy in the field Hierarchy Name or the name of an InfoObject in the field InfoObject . Use wildcards (*) if needed.
- Click [ ]. Search results are displayed.
- Select a Hierarchy and click [Select].
The application returns to the main window of the component.
Define the Xtract Hierarchy Component
The Xtract Hierarchy component offers the following options for Hierarchy extractions:
-
Define the output format of the Hierarchy in the extraction settings . The Xtract Hierarchy component supports the following output formats:
-
Click [Load live preview] to display a live preview of the first 100 records.
-
Click [OK] to save the component.
You can now run the workflow.