run_named_query โ€” Run a Named Query

Runs a SAP pre-registered Named SQL Query by its mcp- code and returns the result rows.

This is a Named SQL Query (SAP /SQLQueries) โ€” dynamic aggregate SQL returning per-query rows, not a fixed Service Layer entity.

Runs a SAP pre-registered Named SQL Query by its code and returns the result rows. The code must start with mcp- (the read-only allowlist), e.g. mcp-ar-summary. Read-only. Reach for it when the user wants a specific pre-registered report or aggregate that has no dedicated tool โ€” “run the AR summary report”, “run the saved AR summary query for Acme”. Discover the available codes first with list_named_queries.

Try these prompts

  • “run the AR summary report”
  • “run the saved AR summary query for Acme”

ื ืกื• ื’ื ื‘ืขื‘ืจื™ืช

  • “ื”ืจืฅ ืืช ื“ื•ื— ืกื™ื›ื•ื ื”ื—ื™ื™ื‘ื™ื”
  • “ื”ืจืฅ ื“ื•ื— ื ื™ืชื•ื— ืžื•ื›ืŸ”
  • “ื”ืคืขืœ ืฉืื™ืœืชืช ื ื™ืชื•ื— ืฉืžื•ืจื””

Arguments

ArgRequiredMeaning
namerequiredThe mcp- query code, e.g. mcp-ar-summary.
paramsoptionalMap of the query’s filter values, e.g. {card_code: "C001"}. Bound server-side.

Example result

mcp-ar-summary for C001 Acme Corp. 8 open invoices, total receivable $14,720 โ€” oldest dated 2026-01-12.

  • list_named_queries โ€” discover the available query codes first.