Mastering SQL Queries for SAP Business One

This is a practical guide providing comprehensive solutions for SQL query problems, and is full of concrete real-world examples to help you create and troubleshoot your SQL queries in SAP Business One. If you are a system administrator who uses SQL query as your tool of choice for solving specific problems throughout SAP Business One, then this book is for you. It may also be useful if you are a developer or consultant using this technology, and can benefit end users by improving your search for important business information. A rudimentary knowledge of SAP Business One and SQL Server is required to use this book efficiently. Examples covered are relevant to SBO 2007A users, for which the 8.8 release is mostly compatible. 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. Non-SAP Business One users can also gain knowledge from the many examples throughout the book. It is hard to find another book with so many SQL query examples

Table of Contents

Chapter 1: SAP Business One Query Users and Query Basics
Chapter 2: Query Generator and Query Wizard
Chapter 3: Query Manager and Query Statements
Chapter 4: Query Examples
Chapter 5: Securities and Approvals
Chapter 6: SQL Query for Formatted Search (FMS)
Chapter 7: SQL Query for Reporting Tools
Chapter 8: SQL Query for a Stored Procedure
Chapter 9: More Complicated SQL Query Topics