This book teaches you how to define, evaluate, and report key figures for sales and distribution controlling in SAP using SAP NetWeaver Business Intelligence 7.0. Readers discover how raw data is prepared in SAP NetWeaver BI, and develop an in-depth understanding by following the authors through a guided tour of a detailed sample SD data model. From there, you’ll learn the most important sales and distribution key figures, and understand how they fit together with your sales and distribution processes.

By reading this book, you will find out exactly how raw data is extracted, formatted, and modeled in SAP NetWeaver BI, and quickly familiarize yourself with reporting in Microsoft Excel and on the Web.You'll uncover the options provided by the standard SAP content and learn how to extend them based on an SD sample scenario. In addition, the authors illustrate clearly how raw data is created in SAP ERP and how it changes along the sales and distribution process chain based on the key figures from the quotation, order, delivery, billing, and cross company areas. Readers can quickly master the design of key figures in SAP NetWeaver BI and learn how to implement the requirements of sales and distribution in the BI system. Last but not least, you will also learn how best to evaluate objects, such as customer or material, across several components, and familiarize yourself with the SAP NetWeaver Visual Composer and Web Application Designer tools.

Highlights

• Data retrieval, modeling, reporting
• Data flow from the source system to the key figures
• Sales and distribution key figures definitions and mapping in SAP NetWeaver BI
• Visual Composer, Web Application Designer

About the Author(s)

Susanne Hess, Stefanie Lenz, and Jochen Scheibler work for the consulting and software company PIKON International Consulting Group. Susanne Hess is responsible for SAP NetWeaver BI projects, Stefanie Lenz manages the BI department, and Jochen Scheibler, cofounder and member of the board, primarily focuses on process-oriented SAP ERP implementations.

Table of Contents

1 ... Introduction ... 11
... 1.1 ... Goals and Basic Principles ... 11
... 1.2 ... Sales in SAP ERP with the Sales and Distribution Component ... 12
... 1.3 ... Overview of SAP NetWeaver BI ... 15
... 1.4 ... Summary ... 18


2 ... SAP NetWeaver BI ... 19
... 2.1 ... The Basic Principles of Modeling in SAP NetWeaver BI ... 19
... 2.2 ... The Basic Principles of Data Retrieval ... 26
... 2.3 ... Reporting Options in Microsoft Excel ... 33
... 2.4 ... Web Reporting ... 59
... 2.5 ... Summary ... 73


3 ... SD Sample Scenario ... 75
... 3.1 ... The Basic Principles of Data Models ... 75
... 3.2 ... DataSources ... 76
... 3.3 ... Data Staging ... 77
... 3.4 ... InfoProviders ... 87
... 3.5 ... MultiProviders ... 88
... 3.6 ... Extended Data Model ... 88
... 3.7 ... Summary ... 100


4 ... Key Figures in the Sales and Distribution Process ... 101
... 4.1 ... Sales and Distribution Key Figures -- General Basics ... 101
... 4.2 ... Quotation Key Figures ... 102
... 4.3 ... Order Key Figures ... 118
... 4.4 ... Excursus: Orders on Hand and Incoming Orders via the SIS ... 141
... 4.5 ... Delivery Key Figures ... 144
... 4.6 ... Billing Key Figures ... 154
... 4.7 ... Key Figures in the Cross-Company Business ... 156
... 4.8 ... Summary ... 162


5 ... Implementing the Key Figures in SAP NetWeaver BI ... 163
... 5.1 ... Quotation Key Figures ... 164
... 5.2 ... Order Key Figures ... 180
... 5.3 ... Delivery Key Figures ... 203
... 5.4 ... Billing Key Figures ... 211
... 5.5 ... Key Figures in the Cross-Company Business ... 216
... 5.6 ... Summary ... 220


6 ... Cross-Sectional Evaluations ... 221
... 6.1 ... Tools ... 221
... 6.2 ... Evaluation via Visual Composer ... 222
... 6.3 ... Evaluation via the Web Application Designer -- The Sales and Distribution Overview Web Template ... 235
... 6.4 ... Summary ... 240


7 ... Summary ... 241


... The Authors ... 243