SAP ECC Join Query

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Querying SAP ECC using multiple tables

• Click the QUERY STUDIO module.
• Hover on Query Builder snippet and click on Query.

• Let’s select SAP ECC Livewire from the Profile drop-down lists.
• By default, Query type (Table) is selected as Single Table.

• Now, select Multiple Tables from the Query type (Table) drop-down list.
• Click the Navigator.

• Let’s select and load MARA table.

• Let’s select and load MAKT table.

• Select the required columns from both the tables.
• Click on Execute Now icon.

• A Results tab is displayed showing the execution results.