A real SQLite database of a demo SAP Business One company, running inside this page. Write any SELECT you like against it. Nothing is sent to a server — there is no server.
1Start from an example
Click one to load it into the editor. It will not run until you press Run query — that part is yours.
Ctrl ↵
loading SQLite…
2What is in the database
Thirteen tables with the real SAP Business One names. See the schema explorer for every column, or start with these:
| Table | Holds |
|---|---|
OCRD | Customers and suppliers, with GSTIN and state |
OINV / INV1 | Sales invoices, header and lines |
OPCH / PCH1 | Purchase invoices, header and lines |
OITM / OITB | Items and item groups, with HSN and GST rate |
OITW / OINM | Stock on hand and every movement |
ORDR | Sales orders, for the open order book |
3Differences from your HANA database
This sandbox is SQLite, so date handling differs: here you would use julianday() and string comparison where HANA has ADD_DAYS() and CURRENT_DATE. The sandbox exists to let you look around the tables, not to be a HANA emulator.
It is also read-only. INSERT, UPDATE and DROP are refused, so you cannot get the examples out of step with the prose by accident.