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

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

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

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

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