Skip to main content
Glama

sap_read_table_data

Read SAP table data with SQL WHERE filtering and field metadata. Returns small to medium datasets directly; large result sets require user confirmation.

Instructions

Reads actual data from a SAP table with optional WHERE clause filtering and metadata inclusion. Use this for small to medium datasets (up to a few thousand rows).

IMPORTANT: If the query returns more than 1000 rows, you will receive a 'requires_confirmation' response with a preview. You MUST ask the user if they want to see all the data before calling again with confirmed=true.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
max_rowsNoMaximum rows to return (default: 10000)
confirmedNoSet to true after user confirms they want large results (>1000 rows)
field_listNoComma-separated field names to return (optional, defaults to all fields)
table_nameYesTable to read
where_clauseNoSQL WHERE condition for filtering
include_metadataNoInclude field structure metadata

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. Changed13 schema fields changedv0.1.2
    • removedInput schema / $schema
      Removed value: -"http://json-schema.org/draft-07/schema#"
    • removedInput schema / additionalProperties
      Removed value: -false
    • addedInput schema / properties / confirmed
      Added value: +{
      +  "default": false,
      +  "description": "Set to true after user confirms they want large results (>1000 rows)",
      +  "type": "boolean"
      +}
    • addedInput schema / properties / field_list
      Added value: +{
      +  "description": "Comma-separated field names to return (optional, defaults to all fields)",
      +  "type": "string"
      +}
    • addedInput schema / properties / include_metadata
      Added value: +{
      +  "default": true,
      +  "description": "Include field structure metadata",
      +  "example": true,
      +  "type": "boolean"
      +}
    • addedInput schema / properties / max_rows / default
      Added value: +10000
    • changedInput schema / properties / max_rows / description
      Previous value: -"Maximum rows to return (default 100)"New value: +"Maximum rows to return (default: 10000)"
    • addedInput schema / properties / max_rows / example
      Added value: +10000
    • changedInput schema / properties / max_rows / type
      Previous value: -"number"New value: +"integer"
    • changedInput schema / properties / table_name / description
      Previous value: -"SAP table name, e.g. LFA1, EKKO, MARA"New value: +"Table to read"
    • addedInput schema / properties / table_name / example
      Added value: +"MARA"
    • changedInput schema / properties / where_clause / description
      Previous value: -"ABAP-style WHERE condition (see tool description)"New value: +"SQL WHERE condition for filtering"
    • addedInput schema / properties / where_clause / example
      Added value: +"MTART = 'FERT' AND ERSDA >= '20230101'"
  2. First observedv0.1.0

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

There are no annotations, so the description carries the full behavioral burden. It discloses the non-obvious confirmation flow: >1000 rows returns 'requires_confirmation' with a preview and requires a follow-up call with confirmed=true. It also signals read-only semantics via 'Reads,' though it does not describe return structure or pagination.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two short paragraphs are tightly scoped: purpose and size guidance first, followed by the critical confirmation rule. Every sentence earns its place, and there is no redundant filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read tool with six parameters, no annotations, and no output schema, the description covers the key operational nuance: the 1000-row confirmation contract. It would be slightly stronger if it explicitly pointed to paginated or streaming siblings for large datasets, but the provided guidance is adequate for correct invocation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all six parameters. The description adds only high-level mention of WHERE filtering and metadata inclusion, which overlaps with the schema rather than adding deeper parameter semantics.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

'Reads actual data from a SAP table' pairs a precise verb with a concrete resource and clearly states optional filtering and metadata behavior. The 'small to medium datasets' scope differentiates it from larger-volume siblings like sap_read_table_paginated and sap_stream_table_data.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives an explicit use condition ('small to medium datasets, up to a few thousand rows') and a required workflow for >1000-row results. It does not name alternative sibling tools for larger datasets, so the when-not-to-use guidance is only implied rather than explicit.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/NicoHern/abapilot-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server