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 Query — Single Table

Query a single SAP ECC table using the SAP connection profile.

Overview

This guide walks through the SAP ECC Query — Single Table workflow in Data Trust Query Studio. Follow the numbered steps below to configure, execute, and review the results.

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.
• The relevant connection profiles have been configured in the Administration module.

Steps

Path: Data Trust › Query Studio › SAP ECC Query — Single Table

Figure 1: SAP ECC connection-Single table from the query type dropdown

This step configures the SAP ECC connection-Single table from the query type dropdown SAP connection for the query data source. Ensure the SAP connection profile is set up in the Administration module before proceeding with table or InfoProvider selection.

Figure 2: SAP ECC transport

This step configures the SAP ECC transport SAP connection for the query data source. Ensure the SAP connection profile is set up in the Administration module before proceeding with table or InfoProvider selection.

Figure 3: Click the navigator and search the MARA

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 4: Click the search tables icon

This step shows Click the search tables icon in the SAP ECC Query — Single Table workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 5: Search the MARA table

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

Figure 6: Click on execute

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.

Figure 7: Additional Options-Aggregation type-AVG

Navigate to the Query Studio module and select Additional Options-Aggregation type-AVG to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 8: Click on Execute and results tab

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.

Figure 9: Columns and Count()-Click the execute

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.

Figure 10: Click here to 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 11: Applied the multiple filters

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 12: Click on execute and filtered data

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.