This repository contains various SQL queries optimized for the SAP Business One enterprise database. The queries provided cover different relevant topics for business management, such as supplier registration, products, vendors, order analysis, and purchasing processes.
This project aims to centralize and share useful SQL queries for managing data in SAP Business One.
The queries were created to facilitate the extraction of important information from the business database, promoting efficiency in analyses and strategic decisions.
📌 Cad_fornecedores.sql: Detailed information about suppliers.📦 Dados_produtos.sql: Details of the product registry.🧑💼 Codigo-vendedores.sql: Vendor list.📈 Pedidos_Faturados.sql: Data on invoiced orders.📋 Pedidos_em_carteira.sql: Open orders.🛒 Processo_de_compras.sql: Details of the entire purchasing process.
If you encounter any issues or need support with any query, I am available to assist.
Feel free to open an issue or contact me directly.
Contributions are welcome!
If you have suggestions for improvements or new queries, fork the repository and submit a pull request.
Author: [Emily Garcia]
Email: kristin.fullstackdev@gmail.com