You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Query Studio › Query Builder

SAP ECC Join Query

Join two SAP ECC tables in a single query using the SAP connection adapter.

Overview

This guide demonstrates joining two SAP ECC tables in a single query. The join is performed at the application layer (ABAP) or database layer depending on the configuration selected in the SAP ECC profile.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• An SAP ECC connection profile has been configured.

Steps

Path: Data Trust › Query Studio › SAP ECC Join Query

Figure 1: Info

This step shows Info in the SAP ECC Join Query workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 2: Search Table button

This step shows Search Table button in the SAP ECC Join Query workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 3: Join Tables and Query text

The Join widget merges two data streams based on matching key columns, similar to a SQL JOIN operation. Select the join type (Inner, Left, Right, or Full) and map the key columns from both input streams.

Figure 4: Local Filter

The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.

Figure 5: Local filter for TSPAT

The Filter transformation restricts the records passing through the Query Chain to only those matching the specified conditions. Define the filter expression using field dropdowns, operator selectors, and value inputs, then save the widget.

Figure 6: Execute Query

Click Execute Now to run the query immediately and fetch the result set. The results appear in the Results tab, and the execution status is displayed in the progress indicator.