Mastering SQL Queries for SAP Business One Packt’s new book, is aimed at helping readers gain in-depth SQL query knowledge to bring more Business Intelligence into SAP Business One. Written by SAP Business One expert Gordon Du the book contains detailed steps to create and troubleshoot SQL queries for Alerts, Approvals, Formatted Searches, and Crystal Reports.
SQL Server for SAP , is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses.
Mastering SQL Queries for SAP Business One begins by teaching the reader a clear definition of the SQL query, and covers the data dictionary and table links. The book then covers a higher level of complex SQL queries, discussing features like FMS. Along the way more advanced SQL Query topics will be covered, such as extending the scope of basic SQL queries for more complicated cases.
The book will first quickly acquaint the readers with SAP's Query Generator and Query Wizard, best practices for creating SQL queries for use with SAP Business One and assign SQL query security within the company. Readers will learn to optimize user queries for alerts, build special queries for Formatted Search and understanding how to utilize the SBO Transaction Notification stored procedure. The book also covers more advanced content like using queries with Crystal Reports.
Written as a practical guide, with numerous real-world examples, the book is ideal for system administrators who use SQL query as a tool of choice for solving specific problems throughout SAP Business One. A fundamental knowledge of SAP Business One and SQL Server is required to use this book efficiently. This book is out now and more information about it can be found here : www.packtpub.com/mastering-sql-queries-for-sap-business-one/book.
Note: All SQL query examples within the book are verified under SQL Server 2005, so they are guaranteed to run under this release, in addition to SQL Server 2008.
|Mastering SQL Queries for SAP Business One|
| Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business
For more information, please visit: www.packtpub.com/mastering-sql-queries-for-sap-business-one/book