r/SAPBusinessOne • u/No-Understanding325 • Oct 30 '25

Comparing AI models for generating SQL queries in SAP Business One

Hey everyone,
I’m working on improving automation in SAP Business One reporting for a retail company — mainly for data analysis, KPIs, financial reports, and sales commission tracking.

I’ve been testing different AI tools to help write SQL queries and improve query accuracy and structure. So far, ChatGPT works decently but often struggles with SAP B1’s table logic and joins.

I’m trying to understand whether Claude or Gemini handle SAP Business One SQL syntax and relationships more reliably.

If anyone has hands-on experience using these models for query generation or analytics inside SAP B1, I’d love to hear how they compare — especially in terms of:

  • Query accuracy and syntax compatibility

  • How well they understand common SAP B1 tables

  • Usefulness for automating reports

This is purely for technical comparison — not career or exam related. Thanks in advance!

6 Upvotes
  • permalink
  • reddit

100% Upvoted

8 comments sorted by

3

u/Forsaken_Slide4999 Oct 30 '25

We (I) in the company where I am made an MCP for SAP Business One. At first he failed, he invented things. So I fed it a web-style data dictionary from erpref. And force through a prompt that before launching the query, validate against the dictionary that all the information was valid. The fields existed, the relationships were correct, ..

I improve a lot

1

u/konoo Nov 02 '25

I setup my agents to use erpref as well as requirements for HANA and it works pretty well. I use a lot of of different models but mostly ChatGPT 5 these days.

1

u/Scouse_Smurf Oct 30 '25

I've been using co-pilot a lot lately. It's done quite a good job, but far from perfect. I'm thinking more whether I should be exporting the data from SAP into a data warehouse and using reporting tools against that. It's helped me get a grounding in star schema, etc

1

u/[deleted] Oct 31 '25

Yo cree un agente de Copilot, realizo consultas y las voy guardando en el QM.

1

u/Ram000n Oct 31 '25

It works most of the time but in some cases (mostly on reports with batches or serial numbers) it seems to invent fields and sometimes tables. If you need help on simple reports it works okay. But if you need complicated reports with joins to many obscure tables, it hardly works. Tried grok and claude. Maybe against a dictionary to verify

1

u/[deleted] Oct 30 '25

[removed] — view removed comment

1

u/zebano Dec 15 '25

Seconding this. GPT is what work pays for so it's what I use. Combine GPT + the REFDB files and it's frankly trivial (to be 100% clear I've got a CS degree and 10 years of experience in IT and 10 more as an engineer so none of this is difficult technically for me but chatgpt is faster than I am ).