Mascidon, LLC


SAP Business  One Add-on Products



SAP Book on Tools 

This is a book that I have written.  The long title is: SAP Business One - Taking Advantage of Its Technical Functionality Using SQL Queries.


Our goal in this book is to show SAP users how using SQL queries will enhance the functionality of SAP Business One.  The SQL database structures are described and documented so that users can more readily tap into the data for queries, formatted searches, alerts, approvals and reports. Extending SAP functions using the technical features that are an integral (and free) part of SAP Business One is explained in depth.


The book refers to a series of SQL queries and functions.  Call our office and I'll email these to you.


With over 40 years experience in the ERP world, the last 17 with SAP Business One, I recognize that many users are under utilizing the product.  A whole section of my website - 'Add-ons Based on SAP Only' includes products that I developed using only the software tools provided with SAP B1.  There is no reason why some technically inclined users cannot extend SAP themselves.  Read the book to find out how.  Alternatively, read the book to get ideas on how SAP can be extended - so that you can plan on having your staff, your SAP dealer's staff, or Mascidon do the development work.


Use the downloads below to retrieve either a pdf or Word document of this book.  I would appreciate it if you would provide feedback on any errors or omissions.  Also, if there are SAP technical functions not explained in the book that you want included, let me know.  I have 2 new chapters that I will be researching this winter - spring: Edit the UI on the screen; and Workflow.  Longer term I intend to have a second book tha deals with Hana as the database.