舉報 
會員
phpMyAdminStarter (Microcontent)
最新章節：
Index
ThisisapracticalguideprovidingcomprehensivesolutionsforSQLqueryproblems,andisfullofconcretereal-worldexamplestohelpyoucreateandtroubleshootyourSQLqueriesinSAPBusinessOne.IfyouareasystemadministratorwhousesSQLqueryasyourtoolofchoiceforsolvingspecificproblemsthroughoutSAPBusinessOne,thenthisbookisforyou.Itmayalsobeusefulifyouareadeveloperorconsultantusingthistechnology,andcanbenefitendusersbyimprovingyoursearchforimportantbusinessinformation.ArudimentaryknowledgeofSAPBusinessOneandSQLServerisrequiredtousethisbookefficiently.ExamplescoveredarerelevanttoSBO2007Ausers,forwhichthe8.8releaseismostlycompatible.AllSQLqueryexampleswithinthebookareverifiedunderSQLServer2005,sotheyareguaranteedtorununderthisrelease,inadditiontoSQLServer2008.Non-SAPBusinessOneuserscanalsogainknowledgefromthemanyexamplesthroughoutthebook.ItishardtofindanotherbookwithsomanySQLqueryexamples.
目錄(82章)
倒序
- 封面
- 版權信息
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- Business Intelligence (BI)
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Part 1. SQL Query Basic
- Chapter 1. SAP Business One Query Users and Query Basics
- Who can benefit from using SQL Queries in SAP Business One?
- SQL query and related terms
- Data dictionary
- Table links—the key for the right query
- 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 wizard
- 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
- Commonly used statements
- Some important functions to return values
- Summary
- Part 2. SQL Query in Action
- Chapter 4. Query Examples
- Why three categories have been chosen
- Defining variables for queries
- Date function—where the most problems emerge
- Orange arrow—an excellent tool for drill down
- Getting a subtotal from the query
- Query for marketing documents
- Query for inventory transactions
- Query for financial transactions
- User query for alert
- Miscellaneous query examples
- Summary
- Chapter 5. Securities and Approvals
- How to handle securities for query usage
- How to use query for approval procedures
- Examples of user queries for approval
- Summary
- Chapter 6. SQL Query for Formatted Search (FMS)
- Formatted Search and User-Defined Values
- How to work with User-Defined Values
- A typical FMS query application: auto code creation
- General FMS query examples
- Summary
- Chapter 7. SQL Query for Reporting Tools
- Query Print Layout Designer (QPLD) and its usage
- Direct query for Crystal Reports (Command)
- Summary
- Chapter 8. SQL Query for a Stored Procedure
- Why Stored Procedure is included in this book
- SBO_SP_TransactionNotification overview
- How to work with SBO_SP_TransactionNotification
- Some example queries for this SP
- Summary
- Chapter 9. More Complicated SQL Query Topics
- The Case expression usage
- Working with a subquery
- Using PIVOT to simplify a cross tab style queries
- Database query for Excel
- Avoiding pitfalls while building queries
- Summary
- Appendix A. Appendix
- Original transaction list by code
- Original transaction list by name
- Object codes and names
- Index 更新時間：2021-04-02 19:18:47
推薦閱讀
- CorelDRAW X6圖形設計立體化教程
- MATLAB計算機視覺經典應用
- 中文版Photoshop入門與提高（CS6版）
- vtiger CRM Beginner's Guide
- 好的PPT會說話：如何打造完美幻燈片
- Puppet 2.7 Cookbook
- Joomla! Social Networking with JomSocial
- ADempiere 3.6 Cookbook
- Joomla! 1.5 Site Blueprints: LITE
- 中文版Photoshop CC平面設計從入門到精通（唯美）
- Lighttpd
- 計算機圖形圖像處理Photoshop CS6項目教程
- 中文版Photoshop CC平面設計實用教程
- 平面設計制作標準教程（微課版 第2版）
- Oracle Fusion Middleware Patterns
- Flash CC動畫制作與應用（第3版）
- 零基礎學Photoshop CS6（全視頻教學版）
- Deep Inside osCommerce: The Cookbook
- Hello HarmonyOS！：鴻蒙應用開發從入門到精通
- Photoshop CC 2015中文版實用教程（第7版）
- AI賦能Rhino產品造型創意設計（視頻教學版）
- MATLAB完全自學教程
- SolidEdge ST10中文版標準教程
- Photoshop網店美工實例教程（全彩微課版）
- CorelDRAW X7標準培訓教程
- 零基礎攝影后期調色 Photoshop照片處理輕松入門
- 精通Microsoft 365云計算管理：SharePoint Online篇
- 玩轉微信6.0
- 從零開始：AutoCAD 2015中文版建筑制圖基礎培訓教程
- Mastering Oracle Scheduler in Oracle 11g Databases
