Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
Mastering SQL Queries for SAP Business One Paperback – May 24, 2011
|New from||Used from|
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
Frequently Bought Together
Customers Who Bought This Item Also Bought
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 85%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
Top Customer Reviews
The specialisation to SAP Business One means that you have this already installed on your computers. While the book does offer an introductory chapter on the general basics of SQL, it's pretty rudimentary. You really should be already up to speed on SQL. The second chapter moves onto SAP, with an all too brief description of their Query Generator and Query Wizard.
But it is the third chapter, on the Query Manager, that you should start to focus. It lets you make complex queries and just as importantly to group them into categories. You can use its user interface to build a first attempt at a query. Then, from looking at the text of how the Manager has instantiated the query, you can if necessary manually edit it to customise it further for exactly your situation.
The ability to group queries is the other key valued added aspect of Manager. Introductory books on SQL rarely talk about this. But in practical situations, and not restricted to the SAP packages, once you starting building a set of interrelated tables and writing queries against them, you start accumulating many queries. In itself, this can be a source of complexity and error.
The rest of the book then goes into several extended examples that let you learn about how to use these tools.
I might have some skin in the game on this one, but if you deal with SAP Business One (SAP B1) at all, you quickly realize one of the most useful tools to have around is the ability to write SQL to provide additional information which users require throughout the life of SAP B1's usage. The author might refer to it as "Business Intelligence" and "Data Mining", but I tend to be old school and think of SQL's purpose as: the user needs information which is in the databases, and IT needs some special SQL written to get it into the hands of the users.
Besides the obvious benefits of the skills you will receive from the book, an additional benefit of this publication deals with the author: Gordon Du is widely and openly recognized in the SAP B1 Forums as being a complete, well-rounded expert on SAP B1, and one of the best SQL writers to be found in helping others straighten out or improve the SQL that is posted on the SAP B1 sites. If you are at all slightly familiar with the SAP sites, you know this fellow has some pretty incredible credentials.Read more ›
I am a SAP Certified SAP B1 consultant and have done multiple implementations and going forward, I will use many queries right out of this book and modify a few others slightly to fit into my client needs such as client UDFs, UDTs etc.
Mr. Du has done a wonderful job of covering everything one needs to know about Query generation, reports and screen formatting, great real product pictures to show how it is actually customized, securing the queries, great insight into why something is done and not to forget Stored Procedures which may be 10% of implemented query customization.
Mr. Du is very well known to SAP Community and he has been helping them for many years actively and now this great book is a giveaway and will save months if not years of effort and hard learning!
Most Recent Customer Reviews
I have found it very useful. Would have give it 5 stars if the book had included some compendium about operators, sap tables and relationship and the formatting for kindle were... Read morePublished 12 months ago by Karla
Good tool with lots of típs. Clear and to the point
Dis not like that Gordon never gets into actual detail, he looses a lot of time saying, "we'll cover this... Read more