Limit search to available items
Book Cover
E-book
Author Du, Gordon

Title Mastering SQL Queries for SAP Business One
Published Birmingham : Packt Pub., 2011

Copies

Description 1 online resource (520 pages)
Contents Mastering SQL Queries for SAP Business One; Mastering SQL Queries for SAP Business One; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; Business Intelligence (BI); What this book covers; Section 1: SQL Query Basic; Section 2: SQL Query in Action; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions
1. SQL Query Basic1. SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables; Important table examples; Table links-the key for the right query; Primary key; Foreign key
Example of table links within SAP Business OneBase tables versus target tables; Keeping it simple-The key to build a good query; Summary; 2. Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders; Step 4-Conditions and relations; Step 5-Query wizard completion
What is the difference between Query generator and Query wizard?Benefitting from built-in system queries; Summary; 3. Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; A single value; A group of values; Return a single database table column; Return a group of database table columns; Return complete database table columns; Used in a subquery
The numbers of columns to be includedColumn name descriptions; Clauses can follow this statement; DISTINCT-duplicated records can be removed; TOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; Left Outer Join; Right Outer Join; Full Outer Join; Self-Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition
Summary Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook
Notes LIKE-similar records can be found
Print version record
SUBJECT SAP Business one. http://id.loc.gov/authorities/names/n2005045777
SAP Business one fast
Subject Small business -- Management -- Computer programs
SQL (Computer program language)
Small business -- Management -- Computer programs
SQL (Computer program language)
Form Electronic book
ISBN 9781849682374
1849682372