Table of Contents

Open all
Close all
Preface
13
Introduction
17
PART I Introduction to SAP Query
23
1 Introduction to SAP ERP Reporting
25
1.1 ABAP Report Generators
26
1.2 Query Reporting Tools
28
1.3 Comparing Analysis Tools: SAP Query and SAP NetWeaver BW
33
1.4 Cumulated Analyses with Multilevel Hierarchies
34
1.4.1 Summarization Hierarchies
35
1.4.2 Report Painter
36
1.4.3 Drilldown Reporting
40
1.5 Using Standard Reports
44
1.5.1 SAP Area Menus
44
1.5.2 Finding a Report in the SAP Menu
47
1.5.3 Searching the Menu for Standard Reports
49
1.5.4 Important Standard Transactions
50
1.6 Summary
52
2 Overview of SAP Tables and Table Links
53
2.1 Data Browser
53
2.2 Table Determination Options
58
2.2.1 F1 Help
58
2.2.2 Table Trace
64
2.2.3 Archiving Object
66
2.2.4 Where-Used List
68
2.3 Table Links
72
2.3.1 Customer Master
72
2.3.2 Sales Document
73
2.4 Summary
76
3 QuickViewer
77
3.1 QuickViewer Overview
77
3.2 Sample Data for Table TSTCT
78
3.3 QuickViewer Initial Screen
80
3.4 Steps for Creating a QuickViewer Report
82
3.4.1 Defining a QuickView Name and Description
82
3.4.2 Selecting a Data Source
84
3.4.3 Selecting Selection Fields and Layout Fields
85
3.5 Layout Mode
89
3.6 Summary
91
4 Overview of SAP Query
93
4.1 Fundamentals
94
4.2 Query Areas
96
4.3 User Group
99
4.4 InfoSet
103
4.5 SAP Query
109
4.6 Summary
114
5 Query Utilities
115
5.1 Overview of Query Utilities
116
5.2 Overview of Query Objects
119
5.3 Query Objects
121
5.3.1 Overview of User Groups
121
5.3.2 Query Overview
123
5.3.3 Directory Lists
123
5.4 Calling Query Object Descriptions
124
5.4.1 User Group Description
124
5.4.2 InfoSet Description
125
5.4.3 Query Description
128
5.5 Editing Functions for Query Objects
130
5.5.1 Copy Function
131
5.5.2 Trash Folder
133
5.5.3 Query Transport
134
5.6 Summary
135
PART II SAP Query Functions
137
6 InfoSet in Detail
139
6.1 Data Sources
141
6.2 Automatic Text Recognition
143
6.3 Table Join
145
6.4 Field Groups
149
6.5 Individual Additional Fields
153
6.6 Selection
160
6.7 Summary
163
7 SAP Query in Detail
165
7.1 Fundamentals
165
7.2 Initial Screen
168
7.2.1 Changing User Group
168
7.2.2 Converting QuickView into a Query
169
7.2.3 Additional Functions on the Initial Screen
171
7.2.4 Additional Editing Options
174
7.3 Query Creation Screen
176
7.3.1 Query Title and Formatting
177
7.3.2 Output Format
179
7.4 Field Name
179
7.4.1 Changing the Column Header of Query Fields
181
7.4.2 Local Fields
182
7.4.3 Selection Fields
186
7.5 Basic List
187
7.6 Additional Functions
188
7.7 Summary
189
8 Selection and Layout Variants
191
8.1 Selection Screen
192
8.2 Selection Variants
198
8.3 Layout Variant
202
8.4 Summary
204
9 Traffic Light Icons, Drilldown, Graphics, and ABC Analyses
205
9.1 Symbols
206
9.2 Icons
211
9.3 Drilldown Options
215
9.4 Using Graphics and the ABC Analysis
219
9.5 Summary
222
PART III Designing User-Friendly Reports
223
10 Summarized Data Output with Statistics and Ranked Lists
225
10.1 Example: Open Item List
226
10.2 Basic List Without a Graphical Query Painter
230
10.3 Statistics
239
10.4 Ranked List
246
10.5 Summary
248
11 ABAP Fundamentals in the InfoSet
249
11.1 ABAP Dictionary
249
11.2 Individual Data Objects in the InfoSet
254
11.2.1 Data Fields
255
11.2.2 System Fields
260
11.3 Helpful ABAP Code
262
11.3.1 Sample Code on the Editor Screen
262
11.3.2 IF Statement
265
11.3.3 SELECT Loop
268
11.3.4 SELECT SINGLE Statement
272
11.3.5 Other Helpful ABAP Commands
275
11.4 Using Your Own Code in the InfoSet
276
11.5 Summary
277
12 Integration with Microsoft Excel
279
12.1 Data Browser
279
12.2 Excel Inplace in SAP List Viewer
282
12.3 Microsoft Excel Integration for Other Query Output Formats
287
12.4 Summary
289
PART IV Query Management
291
13 Transport System
293
13.1 Transport Dataset
294
13.2 Transport Tool
295
13.2.1 Transport Tool in the Standard Area
295
13.2.2 Transport Tool in the Global Query Area
296
13.3 Transport Options
297
13.4 Additional SAP Notes
299
13.5 Summary
300
14 Data Retrieval and Function Modules
303
14.1 Secondary Index
304
14.2 Table View
307
14.3 Function Module
314
14.3.1 Function Module for Converting the Time Dimension in the InfoSet
314
14.3.2 Function Module for Displaying Texts
320
14.4 Summary
329
15 Authorizations and Transaction Creation
331
15.1 Transactions in the Query Environment
331
15.2 User Groups
333
15.3 Authorization Objects
333
15.3.1 Authorization Groups
335
15.3.2 Authorization Object S_QUERY
336
15.4 Integrating Query Transactions into a User Role
337
15.5 Notes on Authorization Assignment
341
15.5.1 SAP Notes
342
15.5.2 Authorization Objects for Administrators and Developers
342
15.6 Summary
343
PART V Real-Life Examples
345
16 Real-Life Examples
347
16.1 Procedure When Creating Reports
347
16.1.1 Brainstorming Workshop
347
16.1.2 Specifying Reports
349
16.2 Sales Evaluation
351
16.3 Financial Accounting Analysis — Open Items
359
16.4 Production Planning — Measuring Productivity
366
16.5 Summary
376
Appendices
377
A Important SAP Tables
377
A.1 General
377
A.2 Sales and Distribution
378
A.3 Production
380
A.4 Materials Management
381
A.5 Financial Accounting and Controlling
384
B The Author
391
Index
393