Sales and Distribution Controlling with SAP NetWeaver BI

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