SAP Press - SAP Query Reporting - Practical Guide

主页 » SAP电子书 » ABAP开发/Basis

作者 SAP 2010年出版 分类:sap 1394

SAP Press - SAP Query Reporting - Practical Guide 官方出品,英文原版,可编辑带导航非影印版!

Contents
Preface ......................................................................................... 13
Introduction ................................................................................. 17
PART I Introduction to SAP Query
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 Defning 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
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 Traffc 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
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
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
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

Query SAP Press 英文原版
喜欢这本书,投资4成为我的天使投资人吧,么么哒

如遇任何问题请联系客服微信ficodk!

下载链接:

上一本

《Kill SAP FICO》from SAP刀客

下一本

SAP Press - SAP Interactive Forms by Adobe (2nd)