bw-modeling-mcp

概述

这是一个全面的MCP服务器，通过SAP BW/4HANA系统的内部REST API使AI助手能够直接操作BW建模对象。它提供广泛的功能，包括读取、创建和修改aDSO、InfoObject、转换、DTP和BW查询等。服务器支持元数据操作和实时数据查询，具有依赖分析、数据流导航和角色管理等功能。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• bw_search

  Search BW objects by name or description with optional wildcard support and object type filtering.

  试试:Find all aDSOs with 'sales' in the name试试:Search for InfoObjects with 'customer' in description
• bw_xref

  Find all objects that reference a given BW object (where-used analysis) including source systems for DataSources.

  试试:Show all DTPs connected to aDSO Z_SALES试试:Find which queries reference InfoObject Z_CUST
• bw_get_adso

  Read the full structure of an aDSO including fields, key fields, settings and version state.

  试试:Show me the structure of aDSO Z_SALES试试:Get details of aDSO including key fields
• bw_create_adso

  Create a new aDSO from template or empty, supporting all aDSO type presets including write-interface.

  试试:Create a new write-interface aDSO from template Z_TEMPLATE试试:Make an empty aDSO with name Z_TEMP
• bw_update_adso

  Modify an existing aDSO by adding/removing fields, managing keys, updating properties or changing settings.

  试试:Add field Z_COST to aDSO Z_SALES试试:Make field Z_REVENUE a key field in aDSO Z_SALES
• bw_query_data

  Execute a BEx Query or preview data from any InfoProvider with variables, filters and axis layout control.

  试试:Run BEx query Z_SALES_Q1 with 2023 as fiscal year试试:Preview data from aDSO Z_SALES with region filter
• bw_get_roles

  Read the full role hierarchy including folders and roles in BW system.

  试试:Show all roles in BW system试试:Get the full role hierarchy structure
• bw_set_query_roles

  Publish or remove a query from a role or specific sub-folder in BW role management.

  试试:Publish query Z_SALES_Q1 to role Z_SALES_MGMT试试:Remove query Z_SALES_Q2 from role folder Z_2023
• bw_get_dataflow

  Trace the complete structural data flow graph of any BW object in any direction.

  试试:Show the data flow for aDSO Z_SALES试试:Trace sources and targets for query Z_SALES_Q1
• bw_list_datasources

  Recursively list all DataSources under a source system with full APCO hierarchy path.

  试试:List all DataSources under source system SAP_ERP试试:Show all FILE system DataSources
• bw_get_composite_provider

  Read a CompositeProvider structure including view node types, source providers with mappings and join conditions.

  试试:Show structure of CompositeProvider Z_SALES_CP试试:Get join details for CompositeProvider Z_MERGE
• bw_activate

  Activate BW objects including aDSO, InfoObject, Transformation and DTP.

  试试:Activate aDSO Z_SALES试试:Activate Transformation Z_SALES_TRFN

可对比工具

安装

# 通过npm安装（推荐）
npm install -g bw-modeling-mcp

# 或克隆并构建
git clone https://github.com/dnic-dev/bw-modeling-mcp.git
cd bw-modeling-mcp
npm install
npm run build

{
  "mcpServers": {
    "bw-modeling-mcp": {
      "command": "node",
      "args": ["/path/to/bw-modeling-mcp/dist/index.js"],
      "env": {
        "BW_URL": "https://your-bw-host:50001",
        "BW_USER": "YOUR_USER",
        "BW_PASSWORD": "YOUR_PASSWORD",
        "BW_CLIENT": "001",
        "BW_LANGUAGE": "EN"
      }
    }
  }
}

FAQ

支持哪些SAP系统？

完全支持所有版本的SAP BW/4HANA。不支持SAP BW on HANA (7.5)，因为HTTP版本协商问题。

如何获得BW系统的API访问权限？

您需要对BW/4HANA系统的/sap/bw/modeling/端点具有REST API访问权限。请联系您的SAP管理员启用此访问。

bw-modeling-mcp 对比