Floemdata
ERP & SAP B1

What is SAP Business One (SAP B1)?

What SAP Business One covers, which tables hold its data, and why reporting needs a separate layer rather than queries against the live database.

Floemdata · · 6 min read

SAP Business One is SAP's ERP product for small and mid-sized companies. It is a different product from S/4HANA: a smaller installation, a shorter implementation, and one integrated database behind all modules.

What it covers

  • Sales: quotation, order, delivery, invoice, credit note
  • Purchasing: order, goods receipt, supplier invoice
  • Inventory: warehouses, batch and serial tracking, stock movements
  • Finance: journal entries, incoming and outgoing payments, periods
  • Production: bill of materials, production orders, consumption
  • CRM: business partners, opportunities, service calls

Where the data lives

SAP B1 runs on Microsoft SQL Server or SAP HANA. Table names follow SAP's convention: document headers start with 'O' (OINV for sales invoices, OITM for item master), line tables carry a number (INV1). The layout is stable across versions, but columns do differ — which is why any integration should verify the real schema before trusting documentation.

Why reporting needs its own layer

An ERP database is tuned for transactions: write one order, read it back fast. Analytical queries scan wide and aggregate millions of rows. When both compete for the same database, the person entering orders feels it.

The second reason is history: costs and documents get corrected retroactively, so a report without versioning shows a different number for last month today. The third is scope — sales sits in the ERP, shipping and payments usually do not.

Floemdata connects to SAP B1 read-only, moves the data into a separate warehouse, and reconciles every figure against SAP's own reporting.

← All guides