LEADER 05040nam 2200685 a 450 001 9910456998903321 005 20200520144314.0 010 $a1-283-34958-2 010 $a9786613349583 010 $a1-84968-237-2 035 $a(CKB)2550000000036797 035 $a(EBL)950602 035 $a(OCoLC)797916717 035 $a(SSID)ssj0000524087 035 $a(PQKBManifestationID)11376345 035 $a(PQKBTitleCode)TC0000524087 035 $a(PQKBWorkID)10545544 035 $a(PQKB)10913567 035 $a(MiAaPQ)EBC950602 035 $a(CaSebORM)9781849682367 035 $a(PPN)228023009 035 $a(Au-PeEL)EBL950602 035 $a(CaPaEBR)ebr10477269 035 $a(CaONFJC)MIL334958 035 $a(EXLCZ)992550000000036797 100 $a20110707d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering SQL queries for SAP Business One$b[electronic resource] $eutilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business /$fGordon Du 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Enterprise Pub.$d2011 215 $a1 online resource (352 p.) 300 $aIncludes index. 311 $a1-84968-236-4 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: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 327 $aImportant table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 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 327 $aStep 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 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; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement 327 $aDISTINCT-duplicated records can be removedTOP-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; 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; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report 327 $aORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge 327 $aCase 4-D1: Balance of production for a month 330 $aUtilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook 606 $aSmall business$xManagement$xComputer programs 606 $aSQL (Computer program language) 608 $aElectronic books. 615 0$aSmall business$xManagement$xComputer programs. 615 0$aSQL (Computer program language) 676 $a005.75/85 676 $a650.0285 676 $a658.02/2 700 $aDu$b Gordon$0976641 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456998903321 996 $aMastering SQL queries for SAP Business One$92224804 997 $aUNINA