MCP Server for SAP ERP

Build 25.0.9440

CreateQuerySchema

Builds a schema file for a specified SAP query, allowing external tools to understand the input and output fields for data extraction.

Input

Name Type Description
Query String The query for which to generate a schema. This must match the query defined in SAP Query (SQ01).
UserGroup String The SAP user group that owns or has access to the specified query.
Variant String The default variant to apply when executing the query. This can predefine field selections and filters.
QueryDescription String Optional description of the SAP query, used for documentation or display purposes.
Workspace String Optional workspace name for organizing or categorizing the generated schema.

The allowed values are Global, Local.

The default value is Global.

TableName String Name to assign to the resulting table or schema file. If not specified, the query name is used by default.

Result Set Columns

Name Type Description
Result String Indicates whether the schema generation succeeded or failed.
SchemaFile String Path or filename of the generated schema file that represents the structure of the query results.
Columns String Total number of columns identified in the query and included in the generated schema.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440