list_named_queries โ€” Named Queries

Lists the SAP pre-registered Named SQL Queries (codes starting mcp-) โ€” the analytics and reporting queries you can run against the live system.

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

Lists the SAP pre-registered Named SQL Queries โ€” the analytics and reporting queries (codes starting mcp-) that can be run against the live system. Returns each query’s code (e.g. mcp-ar-summary) and its human name. Read-only. Use it to discover which reports exist before running one. Takes no arguments.

Try these prompts

  • “what reports can I run?”
  • “list the analytics queries”
  • “which named queries are available?”

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

  • “ืื™ืœื• ื“ื•ื—ื•ืช ืืคืฉืจ ืœื”ืจื™ืฅ?”
  • “ื”ืฆื’ ืืช ืฉืื™ืœืชื•ืช ื”ื ื™ืชื•ื—”
  • “ืื™ืœื• ื“ื•ื—ื•ืช ืžื•ื›ื ื™ื ื–ืžื™ื ื™ื?”

Arguments

No arguments.

Example result

3 named queries available. mcp-ar-summary โ€” A/R Summary ยท mcp-ap-aging โ€” A/P Aging ยท mcp-revenue-monthly โ€” Monthly Revenue.

  • run_named_query โ€” executes a query by its code (optionally with filter params).