# abap-mcp-server
ABAP AI tools - ABAP MCP Server

This repository contains a lightweight MCP server written in Python. It exposes the ABAP MCP tools from the ABAP AI tools so they can be used through an MCP-compatible client.

## Architecture

```mermaid
sequenceDiagram

    participant C as MCP Client (Codex, Copilot, ...)
    participant S as ABAP MCP Server (Python)
    participant F as MCP Function (Python)
    participant I as SAP ICF Service
    participant A as ABAP AI tools MCP
    participant SAP as SAP System

    C->>S: Tool Request
    S->>F: Invoke Tool
    F->>I: HTTP Request
    I->>A: Route Request
    A->>SAP: Execute ABAP Logic

    SAP-->>A: Response
    A-->>I: Response
    I-->>F: HTTP Response
    F-->>S: Tool Response
    S-->>C: MCP Response
```

## Available Tools

### ABAP Dictionary (DDIC) Management

- **Domains**
  - Read, search, create, update domains
  - Manage translations for domain fixed values

- **Data Elements**
  - Read, search, create, update data elements with built-in types or domain references
  - Manage translations for data element labels

- **Structures**
  - Read, search, create, update structures

- **Tables**
  - Read, search, create, update transparent tables

- **Table Types**
  - Read, search, create, update table types

- **CDS views**
  - Read, search, create, update, delete CDS views

### SQL Tools

- **SQL**
  - Perform SELECT, INSERT, UPDATE and DELETE statements on the SAP system

### ABAP Coding

- **ABAP Class**
  - Read, search, create, update, check, activate ABAP Classes

- **ABAP Interface**
  - Read, search, create, update, check, activate ABAP Interfaces

- **ABAP Function Group**
  - Read, search, create, update, check, activate ABAP function groups

- **ABAP Function Module**
  - Read, search, create, update, check, activate ABAP function modules

- **ABAP Program and Include** 
  - Read, search, create, update, check, activate ABAP programs and includes 

### Transport Management

- **Transport Requests**
  - Create workbench and customizing requests
  - Search and read transport request details
  - Release transport requests

### Messages and Message Classes

- **Message Classes**
  - Read, create, update message classes

- **Messages**
  - Read, create, update, translate, delete messages

### ABAP Mass Activation

- **ABAP Mass Activation**
  - Mass activation of objects passing a list of objects or a transport request

## Installation

### Prerequisites

The ABAP system must have the following packages installed:

 - **[ABAP AI tools](https://github.com/christianjianelli/yaai)**
 - **[ABAP AI tools - Function Calling](https://github.com/christianjianelli/yaai_fc)**
 - **[ABAP AI tools - MCP tools](https://github.com/christianjianelli/yaai_mcp)**

```mermaid
graph RL
    A[ABAP AI tools - Function Calling] --> B[ABAP AI tools]
    C[ABAP AI tools - MCP tools] --> A[ABAP AI tools - Function Calling]
    C[ABAP AI tools - MCP tools] --> B[ABAP AI tools]
    D[abap-mcp-server] --> C[ABAP AI tools - MCP tools]
```

You also need a working Python environment that can install the packages from `requirements.txt`.

### Installation Steps

1. Clone the repository:

```bash
git clone https://github.com/christianjianelli/yaai_mcp.git
cd abap-mcp-server
```

2. Create and activate a virtual environment:

```bash
python -m venv .venv
```

On Windows:

```bash
.venv\Scripts\activate
```

On macOS/Linux:

```bash
source .venv/bin/activate
```

3. Install the Python dependencies:

```bash
pip install -r requirements.txt
```

4. Create a `.env` file in the project root and configure the connection to your ABAP backend:

```env
BASE_URL=https://vhcalnplci.dummy.nodomain:44300/sap/yaai/
SAP_USERNAME=<your-username>
SAP_PASSWORD=<your-password>
```

`BASE_URL` is used as the prefix for the individual MCP tool endpoints. Update the host (https://vhcalnplci.dummy.nodomain) and port (44300) to match your ABAP server.

5. Set up your local MCP server in Github Copilot in Eclipse

> Note: The server runs over stdio, so it is meant to be launched by the MCP client.

Click on the Configure Tools button in the Copilot chat window or the click on the Copilot menu -> Edit Preferences -> find the MCP Servers section.

<p>
  <img src="docs/images/github_copilot_eclipse_config_button.png" alt="Github Copilot Configure Tools button" width="300px">
</p>

Edit the MCP server JSON file as shown in the example below. Change the directory path in the args array to the folder on your computer where `main.py` file is located.

 ```json
{
  "servers": {
    "abap-mcp-server": {
      "type": "stdio",
      "command": "uv",
      "args": [
        "--directory",
        "D:\\Python\\abap-mcp-server",
        "run",
        "main.py"
      ]
    }
  }
}
 ```

<p>
  <img src="docs/images/github_copilot_eclipse_config.png" alt="Github Copilot in Eclipe prefeferences" width="500px">
</p>

After completing the configuration, ask Copilot to list the tools it has access to

<p>
  <img src="docs/images/github_copilot_eclipse_mcp_tools_config_check.png" alt="Github Copilot MCP tools access check" width="400px">
</p>

or ask Copilot to use one of the tools

<p>
  <img src="docs/images/github_copilot_chat_domain_tools_use.png" alt="Github Copilot MCP tool use" width="400px">
</p>

<p>
  <img src="docs/images/github_copilot_chat_domain_tool_response.png" alt="Github Copilot MCP tool response" width="400px">
</p>