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
About the author
About the reviewers

SAP Business ONE reporting tools "hands-on"

Now, let’s finally log in to SAP and run some reports. The simplest form of a report in SAP is a plain query that is saved with a title. This can be run at any time in the system. Therefore, if you know how to design a query, then this is a fast and simple solution. In case you do not know how to create a query, let me show you how. I am explaining this to ensure you are making good use of your SQL skills when using SAP Business. In most business solutions, it may be hard to find the right tables and columns to run a query. In SAP Business ONE, you can switch on System Information via View | System Information. Then, as you browse with the mouse over fields in a form, the table name will be displayed in the footer section of the SAP Business ONE interface.

I have added a screenshot that shows the table name and column name for the Business Partner Master record. You can see that the cursor is in the Code section. In the footer, it shows OCRD, CardCode...