Preface |
|
xvii | |
Copyright and Trademark Acknowledgments |
|
xix | |
Introduction |
|
1 | (3) |
|
|
4 | (1) |
|
|
4 | (1) |
|
|
5 | (2) |
|
What Is the R/3 Business Blueprint? |
|
|
7 | (1) |
|
|
8 | (5) |
|
|
13 | (3) |
Section 1 Reporting Basics: A MAPP for Enterprise Reporting |
|
16 | (60) |
|
|
19 | (10) |
|
Reporting Within the Enterprise |
|
|
20 | (2) |
|
The Main Activities of Enterprise Reporting |
|
|
22 | (1) |
|
SAP: The Foundation for Enterprise Reporting |
|
|
23 | (1) |
|
Enterprise Reporting with Business Objects |
|
|
24 | (1) |
|
Business Processes and Enterprise Reporting |
|
|
25 | (1) |
|
Enterprise Reporting with Microsoft Excel |
|
|
26 | (1) |
|
|
27 | (2) |
|
|
29 | (16) |
|
The Cycle of Information Delivery |
|
|
29 | (2) |
|
|
30 | (1) |
|
|
30 | (1) |
|
|
31 | (1) |
|
|
31 | (1) |
|
|
31 | (2) |
|
|
32 | (1) |
|
|
32 | (1) |
|
|
33 | (1) |
|
|
33 | (1) |
|
The MAPP Method in Detail |
|
|
33 | (10) |
|
|
33 | (3) |
|
|
36 | (2) |
|
|
38 | (3) |
|
|
41 | (2) |
|
|
43 | (2) |
|
|
45 | (31) |
|
R/3 Information Organization |
|
|
46 | (10) |
|
|
46 | (1) |
|
|
46 | (2) |
|
Application Component View |
|
|
48 | (1) |
|
R/3 Value Chain and Business Process View |
|
|
48 | (2) |
|
Business Process Scenario View |
|
|
50 | (1) |
|
|
50 | (2) |
|
|
52 | (1) |
|
|
53 | (3) |
|
Basic R/3 Reporting Tools |
|
|
56 | (11) |
|
|
56 | (1) |
|
|
57 | (1) |
|
Finding Reports with the General Report Selection Tool |
|
|
58 | (1) |
|
|
59 | (4) |
|
Information System Reports |
|
|
63 | (1) |
|
Creating and Running Reports |
|
|
63 | (3) |
|
|
66 | (1) |
|
Excel-Based R/3 Reporting with ActiveSheets |
|
|
67 | (1) |
|
|
68 | (1) |
|
|
69 | (3) |
|
ActiveSheets Report Gallery |
|
|
72 | (4) |
Section 2 Business-to-Business Sales |
|
76 | (86) |
|
Understanding R/3 Sales Information |
|
|
79 | (12) |
|
Typical Business Drivers in Sales |
|
|
80 | (1) |
|
Assessing R/3 Sales Information |
|
|
81 | (1) |
|
Understanding Sales Business Processes |
|
|
82 | (9) |
|
Business-to-Business Sales in SAP R/3 |
|
|
82 | (1) |
|
Direct Sale to Business Customer Value Chain |
|
|
83 | (8) |
|
Analyzing R/3 Sales Information |
|
|
91 | (16) |
|
Understanding Sales Business Objects |
|
|
91 | (8) |
|
Sales Order Business Object |
|
|
92 | (2) |
|
Customer Delivery Business Object |
|
|
94 | (1) |
|
|
94 | (3) |
|
|
97 | (2) |
|
Understanding Organizational Structures in Sales |
|
|
99 | (4) |
|
Product and Channel Organization in Sales |
|
|
100 | (1) |
|
Personnel Organization in R/3 Sales |
|
|
101 | (1) |
|
|
102 | (1) |
|
Understanding Sales Performance Measures |
|
|
103 | (4) |
|
|
103 | (2) |
|
|
105 | (1) |
|
|
106 | (1) |
|
Understanding the R/3 Sales Information System |
|
|
107 | (8) |
|
|
107 | (1) |
|
Standard Analyses in the R/3 Sales Information System |
|
|
108 | (2) |
|
|
109 | (1) |
|
|
109 | (1) |
|
|
110 | (1) |
|
|
110 | (1) |
|
Characteristics, Key Figures, and Ratios |
|
|
110 | (3) |
|
|
113 | (2) |
|
Sales Information Delivery |
|
|
115 | (18) |
|
Web-Based R/3 Sales Publishing |
|
|
116 | (4) |
|
Internet Information Portals |
|
|
116 | (1) |
|
Enterprise Information Portal |
|
|
117 | (1) |
|
|
117 | (3) |
|
|
120 | (4) |
|
|
121 | (3) |
|
|
124 | (5) |
|
|
125 | (1) |
|
|
126 | (2) |
|
|
128 | (1) |
|
|
129 | (4) |
|
|
130 | (3) |
|
Putting It All Together: Creating an R/3-based Sales Reporting System Using the MAPP Method |
|
|
133 | (29) |
|
Manage the Sales Reporting Environment |
|
|
133 | (9) |
|
|
134 | (3) |
|
Identify Business Processes |
|
|
137 | (1) |
|
|
137 | (2) |
|
|
139 | (1) |
|
|
140 | (1) |
|
|
141 | (1) |
|
Analyze the Sales Reporting Solution |
|
|
142 | (4) |
|
|
142 | (1) |
|
|
143 | (1) |
|
|
143 | (1) |
|
|
143 | (1) |
|
|
144 | (1) |
|
The Sales Report Analysis at GCP |
|
|
144 | (1) |
|
Creating the Sales Info Structure |
|
|
144 | (2) |
|
|
146 | (9) |
|
Creating the Report Template |
|
|
147 | (1) |
|
The Dos and Don'ts of Report Design |
|
|
148 | (1) |
|
Creating the Sales Report in SAP |
|
|
149 | (2) |
|
Incoming Sales Report in Excel |
|
|
151 | (4) |
|
|
155 | (7) |
|
Facilitating Knowledge Transfer |
|
|
155 | (2) |
|
Designing a Circulation Plan |
|
|
157 | (2) |
|
|
159 | (1) |
|
The Publishing Plan Document |
|
|
160 | (2) |
Section 3 Business-to-Business Procurement |
|
162 | (82) |
|
Understanding R/3 Procurement Information |
|
|
165 | (12) |
|
Typical Business Drivers in Procurement |
|
|
166 | (2) |
|
Assessing R/3 Purchasing Information |
|
|
168 | (1) |
|
Understanding External Procurement Business Processes |
|
|
168 | (9) |
|
Business-to-Business Procurement in SAP R/3 |
|
|
170 | (1) |
|
|
171 | (1) |
|
Procurement of Stock Material Business Process Scenario |
|
|
172 | (5) |
|
Analyzing R/3 Procurement Information |
|
|
177 | (16) |
|
Understanding Purchasing Business Objects |
|
|
177 | (11) |
|
Purchase Order Business Object |
|
|
178 | (1) |
|
|
178 | (4) |
|
Purchasing Material Business Object |
|
|
182 | (2) |
|
Purchase Requisition Business Object |
|
|
184 | (2) |
|
Vendor Invoice Business Object |
|
|
186 | (2) |
|
Understanding Organizational Structures in Procurement |
|
|
188 | (1) |
|
Organizational Entities in Procurement |
|
|
188 | (1) |
|
Understanding Procurement Performance Measures |
|
|
189 | (4) |
|
|
189 | (1) |
|
|
190 | (1) |
|
|
191 | (2) |
|
Understanding the R/3 Purchasing Information System |
|
|
193 | (10) |
|
Purchasing Information System |
|
|
193 | (1) |
|
Standard Analyses in the R/3 Purchasing Information System |
|
|
194 | (1) |
|
|
194 | (1) |
|
|
195 | (1) |
|
|
195 | (1) |
|
|
195 | (1) |
|
|
195 | (1) |
|
Characteristics, Key Figures, and Ratios |
|
|
195 | (2) |
|
Example Purchasing Information System Report: The Order Value Analysis |
|
|
197 | (6) |
|
|
197 | (1) |
|
|
197 | (1) |
|
Analysis Using Comparison Periods |
|
|
197 | (1) |
|
|
198 | (1) |
|
Running an Analysis of Order Values |
|
|
198 | (5) |
|
Procurement Information Delivery |
|
|
203 | (12) |
|
Publishing with Microsoft Exchange |
|
|
204 | (2) |
|
|
204 | (2) |
|
|
206 | (5) |
|
|
207 | (1) |
|
|
208 | (1) |
|
|
209 | (2) |
|
|
211 | (2) |
|
|
213 | (2) |
|
|
213 | (2) |
|
Business-to-Business Reporting for R/3 Procurement |
|
|
215 | (29) |
|
|
215 | (2) |
|
Business-to-Business Procurement at MRO.COM |
|
|
216 | (1) |
|
Managing Information for the Procurement Environment |
|
|
217 | (4) |
|
|
217 | (1) |
|
Business Needs Analysis for MRO.COM |
|
|
218 | (1) |
|
Identifying Business Processes |
|
|
218 | (1) |
|
|
219 | (1) |
|
|
220 | (1) |
|
|
220 | (1) |
|
Analyzing MRO.COM's Reporting Data Requirements |
|
|
221 | (1) |
|
Analyze the Purchasing Reporting Solution |
|
|
221 | (5) |
|
|
222 | (1) |
|
|
222 | (1) |
|
|
222 | (3) |
|
|
225 | (1) |
|
|
225 | (1) |
|
The Procurement Report Analysis at MRO.COM |
|
|
225 | (1) |
|
Present The Report Solution |
|
|
226 | (12) |
|
Creating the Procurement Info Structure |
|
|
226 | (3) |
|
Creating the Report Template |
|
|
229 | (5) |
|
Creating the Update Rules for the Infostructure |
|
|
234 | (2) |
|
Purchasing Report in Excel |
|
|
236 | (2) |
|
Publish the Report Solution |
|
|
238 | (6) |
|
|
238 | (2) |
|
|
240 | (1) |
|
|
241 | (3) |
Seciton 4 Financial Accounting |
|
244 | (82) |
|
Understanding R/3 Financial Accounting Information |
|
|
247 | (8) |
|
Typical Business Drivers in Financials |
|
|
248 | (1) |
|
Assessing R/3 Financial Information |
|
|
249 | (1) |
|
Understanding Financial Accounting Business Processes |
|
|
250 | (5) |
|
SAP R/3 Financial Accounting |
|
|
251 | (1) |
|
Consolidation Business Process Scenario |
|
|
251 | (1) |
|
|
251 | (1) |
|
Step and Simultaneous Consolidation |
|
|
252 | (1) |
|
|
252 | (1) |
|
|
253 | (1) |
|
|
253 | (2) |
|
Analyzing R/3 Financial Accounting Information |
|
|
255 | (12) |
|
Understanding Financial Business Objects |
|
|
255 | (7) |
|
|
256 | (1) |
|
Customer Account Business Object |
|
|
257 | (1) |
|
Credit Control Business Object |
|
|
258 | (1) |
|
|
259 | (1) |
|
Vendor (Accounts Payable) Business Object |
|
|
260 | (1) |
|
|
261 | (1) |
|
Understanding Financial Organizational Structures |
|
|
262 | (1) |
|
Organizational Entities in Financials |
|
|
262 | (1) |
|
Understanding Financials Performance Measures |
|
|
263 | (2) |
|
|
264 | (1) |
|
|
265 | (1) |
|
|
265 | (2) |
|
Understanding the R/3 Financial Information System |
|
|
267 | (12) |
|
Financial Accounting Information System |
|
|
267 | (1) |
|
Standard Analyses in The R/3 Financial Accounting Information System |
|
|
268 | (2) |
|
|
268 | (1) |
|
|
269 | (1) |
|
|
269 | (1) |
|
|
270 | (1) |
|
|
270 | (1) |
|
|
270 | (1) |
|
Characteristics, Key Figures, and Ratios |
|
|
270 | (3) |
|
Example: Financial Accounting Information System Reports |
|
|
273 | (6) |
|
|
273 | (1) |
|
Accounts Receivable (Open Items Report) |
|
|
274 | (1) |
|
Accounts Payable (Vendor Open Items) |
|
|
275 | (1) |
|
General Ledger (Account Balance) |
|
|
276 | (3) |
|
Financial Information Delivery |
|
|
279 | (16) |
|
Publishing with Microsoft Digital Dashboard |
|
|
280 | (4) |
|
Microsoft Digital Dashboard Overview |
|
|
281 | (1) |
|
Digital Dashboard Financial Reporting Scenario |
|
|
282 | (2) |
|
|
284 | (2) |
|
Role-Based Reporting with the Microsoft Digital Dashboard |
|
|
285 | (1) |
|
|
286 | (5) |
|
|
286 | (1) |
|
|
287 | (2) |
|
|
289 | (2) |
|
|
291 | (4) |
|
|
291 | (4) |
|
Business-to-Business Reporting for R/3 Financials |
|
|
295 | (31) |
|
|
295 | (2) |
|
Financial Consolidation at DASAUTO AG |
|
|
296 | (1) |
|
Managing Information for The Financials Analysis Environment |
|
|
297 | (7) |
|
The Situation at DASAUTO AG |
|
|
297 | (1) |
|
Business Needs Analysis for DASAUTO AG |
|
|
298 | (2) |
|
Identifying Business Processes |
|
|
300 | (2) |
|
|
302 | (1) |
|
|
302 | (1) |
|
Analyzing DASAUTO's Reporting Data Requirements |
|
|
303 | (1) |
|
Analyze the Financial Reporting Solution |
|
|
304 | (5) |
|
|
305 | (1) |
|
|
305 | (1) |
|
|
306 | (2) |
|
|
308 | (1) |
|
|
308 | (1) |
|
The Financial Report Analysis at DASAUTO AG |
|
|
308 | (1) |
|
Present the Report Solution |
|
|
309 | (11) |
|
Creating the Report Template |
|
|
309 | (4) |
|
|
313 | (7) |
|
Publish the Report Solution |
|
|
320 | (6) |
|
|
320 | (2) |
|
|
322 | (1) |
|
|
322 | (4) |
Section 5 eBusiness Solutions |
|
326 | (21) |
|
|
329 | (18) |
|
|
330 | (1) |
|
|
331 | (1) |
|
Commission Calculator (with ODBC) |
|
|
332 | (1) |
|
Consolidated Balance Sheet |
|
|
333 | (1) |
|
|
334 | (1) |
|
|
335 | (1) |
|
Direct Expenses (Consolidated) |
|
|
336 | (1) |
|
|
337 | (1) |
|
|
338 | (1) |
|
|
339 | (1) |
|
|
340 | (1) |
|
|
341 | (1) |
|
|
342 | (1) |
|
|
343 | (1) |
|
|
344 | (1) |
|
|
345 | (2) |
Index |
|
347 | (10) |
R/3 Reporting with ActiveSheets |
|
357 | |