← Semua panduan
Panduan Playbook · Gratis

Read Your SAP S/4HANA Data Through HANA SQL and Your Muse

Terverifikasi 2026-11-12

Through a custom connector, your muse can answer business questions straight from an SAP S/4HANA system on-premise or in Private Cloud, reading its HANA database with read-only SQL, after checking SAP's own data dictionary.

What it does

The connector adds 10 tools and only reads. Before it queries, the muse looks up what SAP's short field names mean in the data dictionary, so it sees the business label of each field, the currency or unit field that belongs with each amount, what a field's codes mean, and how tables join. It can list company codes, plants, and sales organizations, search tables and released CDS views, describe a table, and run one read-only query at a time, for questions such as revenue per posting period, customers with invoices over 60 days overdue, and the top customers by net sales.

How to use it

  1. Ask your SAP Basis team to create a HANA database user with SELECT grants only, covering the dictionary tables and the business tables and views you want read.
  2. Run AnythingMCP yourself on a host inside the network that can reach the HANA SQL port.
  3. Add the SAP S/4HANA (HANA SQL) connector and enter the host, port, tenant, schema, client, language, user, and password. A test call reads your organization structure.
  4. In Muse, open Settings, then Connectors, and add a custom connector with the address AnythingMCP gives you. Sign in and approve. Only this address is published, never the HANA port.
  5. Ask a scoped question, naming the company code and period you mean.

What you need

  • A Muse account that can add custom connectors
  • A self-hosted AnythingMCP that can reach the HANA SQL port
  • An SAP S/4HANA system on-premise, in Private Cloud, or in HANA Enterprise Cloud
  • A read-only HANA database user created by SAP Basis

What to watch for

  • Reading is enforced in HANA itself: one SELECT per call, a read-only session, a 1,000 row cap, and a 60-second timeout. Writes are refused.
  • SQL does not apply SAP's application authorizations. The database grants are the whole boundary, so grant only tables and views that are fine to read. A grant on the whole schema includes HR data.
  • Check your SAP license before connecting a production system. A runtime license bundled with S/4HANA usually does not cover direct SQL access by another application; a full-use license does.
  • This is a custom connector, and Meta does not review custom connectors. You can disconnect it in Settings at any time. The muse prepares, you decide.

Sudah mencoba panduan ini?

Ceritakan ke komunitas bagaimana hasilnya, atau minta bantuan agar bisa berjalan.

Bahas ini di MuseFM →

Playbook Pro

Mau melewatkan pelajarannya?

Bantu agen kamu mempelajari semuanya sekaligus. 1,015 skill, satu pass, $49 untuk 90 hari.

Dapatkan Pro Pass
Panduan lainnya →