Skip to main content Skip to complementary content

Retrieving SAP BW ADSO

Retrieve the metadata of the SAP BW Advanced Data Store Object (ADSO) using the SAP metadata wizard.


  1. In the Repository tree view, right-click the newly created SAP connection and select Retrieve SAP BW metadata.
  2. Select AdvancedDataStoreObject from the Search in drop-down list.
  3. Fill in the relevant information on the following fields:
    • Name: enter the filter criterion for the object name
    • Description: enter the filter criterion for the object description
    Information noteNote: The filter criteria, Name and Description, act together as an OR operator.
  4. Click Search to list all the objects that match the filter criteria.
  5. Select the tables that you wish to retrieve by marking the checkbox in the Name column.
  6. Wait for the Creation Status to display Success.
    The tables and their schemas of the selected objects are saved in the Repository tree.
  7. Click Next to proceed to the next step.
    All tables of the selected objects are listed in the Table Name area.
    1. Click Refresh Table to display the latest table schema in the Current Table area. You can modify the schema of the selected table in the Current Table area, if needed.
    2. Click Refresh Preview to preview data in the selected table, if needed.
  8. Click Finish to save the tables and their schemas in the Repository tree view.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!