Querying SAP ECC using multiple tables

• Click the QUERY STUDIO
• 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 tables.
• Click on Execute Now icon.

• A Results tab is displayed showing the execution results.