Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Mastering SQL queries for SAP Business One [[electronic resource] ] : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du
| Mastering SQL queries for SAP Business One [[electronic resource] ] : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du |
| Autore | Du Gordon |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise Pub., 2011 |
| Descrizione fisica | 1 online resource (352 p.) |
| Disciplina |
005.75/85
650.0285 658.02/2 |
| Soggetto topico |
Small business - Management - Computer programs
SQL (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-34958-2
9786613349583 1-84968-237-2 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; 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
Important 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 Step 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 DISTINCT-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 ORDER 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 Case 4-D1: Balance of production for a month |
| Record Nr. | UNINA-9910456998903321 |
Du Gordon
|
||
| Birmingham, U.K., : Packt Enterprise Pub., 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering SQL queries for SAP Business One [[electronic resource] ] : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du
| Mastering SQL queries for SAP Business One [[electronic resource] ] : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du |
| Autore | Du Gordon |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise Pub., 2011 |
| Descrizione fisica | 1 online resource (352 p.) |
| Disciplina |
005.75/85
650.0285 658.02/2 |
| Soggetto topico |
Small business - Management - Computer programs
SQL (Computer program language) |
| ISBN |
1-283-34958-2
9786613349583 1-84968-237-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; 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
Important 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 Step 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 DISTINCT-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 ORDER 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 Case 4-D1: Balance of production for a month |
| Record Nr. | UNINA-9910781227403321 |
|
Du Gordon
|
||
| Birmingham, U.K., : Packt Enterprise Pub., 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering SQL queries for SAP Business One : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du
| Mastering SQL queries for SAP Business One : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / / Gordon Du |
| Autore | Du Gordon |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise Pub., 2011 |
| Descrizione fisica | 1 online resource (352 p.) |
| Disciplina |
005.75/85
650.0285 658.02/2 |
| Soggetto topico |
Small business - Management - Computer programs
SQL (Computer program language) |
| ISBN |
9786613349583
9781283349581 1283349582 9781849682374 1849682372 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; 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
Important 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 Step 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 DISTINCT-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 ORDER 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 Case 4-D1: Balance of production for a month |
| Altri titoli varianti | Mastering Structured Query Language queries for SAP Business One |
| Record Nr. | UNINA-9910970581703321 |
|
Du Gordon
|
||
| Birmingham, U.K., : Packt Enterprise Pub., 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SAP Business ONE implementation [[electronic resource] ] : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert
| SAP Business ONE implementation [[electronic resource] ] : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert |
| Autore | Niefert Wolfgang |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
| Descrizione fisica | 1 online resource (320 p.) |
| Disciplina | 658.02/2/0285 |
| Collana | From technologies to solutions |
| Soggetto topico | Small business - Management - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-282-11196-5
9786612111969 1-84719-639-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Getting Ready to Implement SAP Business ONE; Setting the stage for the book-how does your business ""tick""; Sales leads and follow-up; Delivery; Inventory; Warehouse; Service and support; Manufacturing; E-commerce; Industry; ROI and budget for your own system; What this chapter will cover; Toolbox for your business; Identify the problem areas-asking the right questions; Solutions for problem areas-paper and pencil; Proven examples-case study; Fix It-project plan and tips; The case study-why your company is like the ""Lemonade Stand""
Start with a piece of paperSAP Business ONE-a business engine; Introducing key terms and concepts; Real-time information instead of islands of data; Positioning SAP Business ONE against mySAP-All-In-One and Business ByDesign; Real-world note; What is profitable growth; What is real time; Establish metrics-the cost of no investment; Designing ""metrics"" for your own business; What is prototyping; The virtual enterprise; SAP 100-word definition of SAP Business ONE; Why projects fail?; Summary; Chapter 2: SAP Business ONE Express Implementation Walk-through Configuring a new SAP Business ONE company Lemonade Stand Inc.Prerequisites for the case study; Options to configure a system quickly; The ad hoc prototyping method; Use a template database; Use an industry solution; Perform a thorough analysis; Problems with this simple example; Future way for SAP implementation; Your own project; The Lemonade Stand case study; Company Name; Database Name; Local Settings; Chart of Accounts; Base Language; Define Posting Periods; Walk-through configuration; Choose Company; Exchange Rates and Indexes; Company details and settings; Company details What is the valuation method?Essential configuration parameters; G/L Account Determination; Default payment terms for banking; Tax; Payment terms for customers and vendors; Setting the stock system; Getting ready for transactions; Business partners and marketing documents; Office integration; Don't rush-details will always catch up; Business partner master data; Add sales people; Item groups; Almost done; Sales stages; Entering master data; Transaction digestion; Summary; Chapter 3: Reporting and Analysis: Getting Ready for Growth; Reporting architecture Reporting requires a forward-looking visionReal-time reporting; What is BI-business intelligence?; The difference between data and information; User-defined fields; API programming and certified add-ons; How to create a UDF?; Adding a UDF to Marketing Documents; How can the new field be used for reporting?; Developing an efficient UDF concept; Components of a reporting strategy; Establishing the data collection framework for your project; Report delivery based on information requirements; SAP Business ONE reporting tools ""hands-on""; SQL for managers; Using the Query Generator Using the Query Wizard |
| Record Nr. | UNINA-9910456109303321 |
|
Niefert Wolfgang
|
||
| Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SAP Business ONE implementation [[electronic resource] ] : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert
| SAP Business ONE implementation [[electronic resource] ] : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert |
| Autore | Niefert Wolfgang |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
| Descrizione fisica | 1 online resource (320 p.) |
| Disciplina | 658.02/2/0285 |
| Collana | From technologies to solutions |
| Soggetto topico | Small business - Management - Computer programs |
| ISBN |
1-282-11196-5
9786612111969 1-84719-639-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Getting Ready to Implement SAP Business ONE; Setting the stage for the book-how does your business ""tick""; Sales leads and follow-up; Delivery; Inventory; Warehouse; Service and support; Manufacturing; E-commerce; Industry; ROI and budget for your own system; What this chapter will cover; Toolbox for your business; Identify the problem areas-asking the right questions; Solutions for problem areas-paper and pencil; Proven examples-case study; Fix It-project plan and tips; The case study-why your company is like the ""Lemonade Stand""
Start with a piece of paperSAP Business ONE-a business engine; Introducing key terms and concepts; Real-time information instead of islands of data; Positioning SAP Business ONE against mySAP-All-In-One and Business ByDesign; Real-world note; What is profitable growth; What is real time; Establish metrics-the cost of no investment; Designing ""metrics"" for your own business; What is prototyping; The virtual enterprise; SAP 100-word definition of SAP Business ONE; Why projects fail?; Summary; Chapter 2: SAP Business ONE Express Implementation Walk-through Configuring a new SAP Business ONE company Lemonade Stand Inc.Prerequisites for the case study; Options to configure a system quickly; The ad hoc prototyping method; Use a template database; Use an industry solution; Perform a thorough analysis; Problems with this simple example; Future way for SAP implementation; Your own project; The Lemonade Stand case study; Company Name; Database Name; Local Settings; Chart of Accounts; Base Language; Define Posting Periods; Walk-through configuration; Choose Company; Exchange Rates and Indexes; Company details and settings; Company details What is the valuation method?Essential configuration parameters; G/L Account Determination; Default payment terms for banking; Tax; Payment terms for customers and vendors; Setting the stock system; Getting ready for transactions; Business partners and marketing documents; Office integration; Don't rush-details will always catch up; Business partner master data; Add sales people; Item groups; Almost done; Sales stages; Entering master data; Transaction digestion; Summary; Chapter 3: Reporting and Analysis: Getting Ready for Growth; Reporting architecture Reporting requires a forward-looking visionReal-time reporting; What is BI-business intelligence?; The difference between data and information; User-defined fields; API programming and certified add-ons; How to create a UDF?; Adding a UDF to Marketing Documents; How can the new field be used for reporting?; Developing an efficient UDF concept; Components of a reporting strategy; Establishing the data collection framework for your project; Report delivery based on information requirements; SAP Business ONE reporting tools ""hands-on""; SQL for managers; Using the Query Generator Using the Query Wizard |
| Record Nr. | UNINA-9910780432403321 |
|
Niefert Wolfgang
|
||
| Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SAP Business ONE implementation : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert
| SAP Business ONE implementation : bring the power of SAP enterprise resource planning to your small-to-midsize business / / Wolfgang Niefert |
| Autore | Niefert Wolfgang |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
| Descrizione fisica | 1 online resource (320 p.) |
| Disciplina | 658.02/2/0285 |
| Collana | From technologies to solutions |
| Soggetto topico | Small business - Management - Computer programs |
| ISBN |
9786612111969
9781282111967 1282111965 9781847196392 184719639X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Getting Ready to Implement SAP Business ONE; Setting the stage for the book-how does your business ""tick""; Sales leads and follow-up; Delivery; Inventory; Warehouse; Service and support; Manufacturing; E-commerce; Industry; ROI and budget for your own system; What this chapter will cover; Toolbox for your business; Identify the problem areas-asking the right questions; Solutions for problem areas-paper and pencil; Proven examples-case study; Fix It-project plan and tips; The case study-why your company is like the ""Lemonade Stand""
Start with a piece of paperSAP Business ONE-a business engine; Introducing key terms and concepts; Real-time information instead of islands of data; Positioning SAP Business ONE against mySAP-All-In-One and Business ByDesign; Real-world note; What is profitable growth; What is real time; Establish metrics-the cost of no investment; Designing ""metrics"" for your own business; What is prototyping; The virtual enterprise; SAP 100-word definition of SAP Business ONE; Why projects fail?; Summary; Chapter 2: SAP Business ONE Express Implementation Walk-through Configuring a new SAP Business ONE company Lemonade Stand Inc.Prerequisites for the case study; Options to configure a system quickly; The ad hoc prototyping method; Use a template database; Use an industry solution; Perform a thorough analysis; Problems with this simple example; Future way for SAP implementation; Your own project; The Lemonade Stand case study; Company Name; Database Name; Local Settings; Chart of Accounts; Base Language; Define Posting Periods; Walk-through configuration; Choose Company; Exchange Rates and Indexes; Company details and settings; Company details What is the valuation method?Essential configuration parameters; G/L Account Determination; Default payment terms for banking; Tax; Payment terms for customers and vendors; Setting the stock system; Getting ready for transactions; Business partners and marketing documents; Office integration; Don't rush-details will always catch up; Business partner master data; Add sales people; Item groups; Almost done; Sales stages; Entering master data; Transaction digestion; Summary; Chapter 3: Reporting and Analysis: Getting Ready for Growth; Reporting architecture Reporting requires a forward-looking visionReal-time reporting; What is BI-business intelligence?; The difference between data and information; User-defined fields; API programming and certified add-ons; How to create a UDF?; Adding a UDF to Marketing Documents; How can the new field be used for reporting?; Developing an efficient UDF concept; Components of a reporting strategy; Establishing the data collection framework for your project; Report delivery based on information requirements; SAP Business ONE reporting tools ""hands-on""; SQL for managers; Using the Query Generator Using the Query Wizard |
| Record Nr. | UNINA-9910975432603321 |
|
Niefert Wolfgang
|
||
| Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
