Welcome to the SQL Server and SAP HANA queries project repository for SAP Business One. This document provides various queries from simple to complex for the SAP Business One system.
We are pleased to announce that the localized SAP Business One demo databases have been updated to the latest feature pack and are now available for download. Along with the updated environment, we provide enhanced and recent transactional data to make you test your queries. Localized demo databases contain a pre-configured SAP Business One environment. They are based on the OEC Computers model company and are offered for both the MS SQL version and the SAP HANA version of SAP Business One.
Link 1 - Download database The database link is inside the PDF.
Link 2 - Download database Group "Implementation", "Localized Demo Databases for SAP Business One(PDF)".
To use the SAP database, use SQL Server Express, a free version of Microsoft SQL Server for testing database queries. SQL Server Express is a good choice for development and testing because it is free to download and use.
Download and install SQL Server Express
Install SQL Server Management Studio (SSMS)