Book Image

SAP Business ONE Implementation

By : Wolfgang Niefert
Book Image

SAP Business ONE Implementation

By: Wolfgang Niefert

Overview of this book

SAP Business ONE brings the power of the SAP ERP platform to small and mid-size companies. It offers fast-growing companies the same ERP capabilities used in world-wide conglomerates and major corporations. SAP Business ONE is powerful, and to fully harness it takes careful planning. This book will provide you with a guide to install and implement SAP B1 in your business. It starts with the basic tasks of installing and configuring, but moves at a fast pace and goes on to cover topics such as advanced CRM, e-commerce, and modern Distribution Center configurations for inventory optimization and Warehouse Management. The book is divided into two main sections. The case study starts out in section one with an ad-hoc implementation of a simple Lemonade Stand business. This section is focused on getting SAP B1 up and running quickly. In the second section the Ad-Hoc Implementation is taken to the next level , and we professionally expand this idea and develop a Beverage Distribution Center with outsourced production. This includes advanced inventory optimization. The workflow is optimized using existing functionality and also using Add-Ons to expand the standard functionality and transform the generic SAP Business ONE business engine into an Industry Solution. The book is full of examples with detailed step-by-step explanations. We will be implementing a complete SAP Business System including add-ons as part of a case study. Finally we connect SAP to the Web and introduce a solution that presents SAP features in a web interface with real-time integration. The book is completed with a chapter focusing on growth. Franchise architecture for SAP Business ONE is introduced and applied to the case study to help you learn how to get started with this. Each chapter has a section that assists you with applying knowledge for your own project. You will have your business set up and ready to go by the time you complete this book.
Table of Contents (18 chapters)
SAP Business ONE Implementation
Credits
About the author
About the reviewers
Preface
Index

Standard terms related to reporting


Before we continue defining the aspects of a reporting strategy, I would like to summarize the most important terms related to reporting.

SQL, query, and stored procedure

When reports are discussed, SQL, queries, and stored procedures are frequently mentioned. SQL stands for Structured Query Language. It is a method to extract information from relational tables in the form of a machine-type language called a query. In SAP, you can see the names of tables by switching on the System Information in the menu. If you move the mouse over the cardcode column while the business partner screen is open, you can see the table is called OCRD. You can see this in the footer section of the SAP application. A query to get all of the customer information will look like this: Select * from OCRD. A stored procedure in this environment is a query, which uses parameters to calculate the results.

Crystal Reports

Crystal Reports, formerly owned by Business Objects, is now an...