New Announcements and Updates




SAP Query Reporting — Practical Guide

Image 1
Click to enlarge
Price:
Starting From $59.99
Product Code:
H3167
Average Rating:
( 5 product reviews )
Availability:
In stock!
Format:
Quantity:

Write your own product review

Product Details

ISBN:
978-1-59229-365-0
Author:
Stephan Kaleske
Type:
Hardcover, 396 pages
Year:
2010

Product Description and Table of Contents

• A step-by-step guide to using SAP Query
• Coverage from basic principles to expert know-how
• Suited for all SAP ERP components

In this book, you'll learn how to utilize SAP Query for your business analysis needs. The most essential SAP database tables are presented, enabling you to extract specific information from SAP ERP. Numerous screenshots, detailed instructions, and comprehensive real-life examples guide you through all steps of report creation. The book is based on SAP ERP 6.0, but it is also ideally suited for users of older releases (e.g., R/3 4.6C).

Basic Principles of Query Reporting
Learn about the relationships between QuickViewer, user groups, the InfoSet, and SAP Query. This book explains how to localize tables and which query utilities support you in your work.

All Major Query Features
Discover everything you need to know about selection and layout variants, drilldown functions, icons, ABC analyses, and much more.

Designing User-Friendly Reports
Master challenging reporting requirements, including ABAP coding. Utilize ranked lists and statistics, Microsoft Excel integration, and much more.

Query Administration
How do you transport queries? How do you improve performance? What do you need to consider with regard to authorizations? Here, you find the answers to these questions and others.

Plus, Immediately Usable Queries for Download!

Highlights

· Fundamentals
 -  SAP Tables and Table Links
 -  QuickViewer, SAP Query, Query Utilities
· Query Functions
 -  InfoSet and SAP Query in Detail
 -  Selection and Layout Variants
 - Traffic Light Icons, Drilldown, Graphics, and ABC Analyses
· Designing User-Friendly Queries
 -  Statistics and Ranked Lists
 -  ABAP Fundamentals
 -  Integration with Microsoft Excel
· Query Management
 -  Transport System
 -  Data Retrieval and Function Modules
 -  Authorizations and Transaction Creation
· Real-Life Examples

The Authors

Dr. Jörg Thomas Dickersbach is the head of the product management department at Wassermann AG. Dr. Gerhard Keller is shareholder and partner of Bonpago GmbH and works in the discrete manufacturing and financial services area.

Table of Contents

  • ... 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


Additional Resource(s)


Download: Bonus download for readers of this book

Product Reviews


Showing reviews 1-4 of 5 | Next

  1. Perfect book on SAP Query

    Posted by Ronald on Feb 21st, 2013

    Extensively covered and good step by step practice book for SAP Query, beneficial for both consultants and business users.

  2. Concise guide to SAP Query

    Posted by IBP on Jan 4th, 2013

    To all SAP Consultants, this book is definitely recommended for its full coverage of understanding Query. In our job, we always encounter users with numerous requests where you know are combination of many different SAP tables and this book provided many examples which could be used. I really love the ebook trail version but eventually still find the print version always handy. A great companion.

  3. Extremely useful book.

    Posted by "SAP fan from Sweden" on Dec 12th, 2012

    I have been using SQVI for some time and wanted to go one more step and try the more advanced standard Query SQ01.
    I didn't wanted to continue my "try and error" way of working, so I decided to purchase this book.

    I don't regret it !

    This book is very useful, easy to understand and with a lot of real life examples.

    A problem I had with a SQVI billing report I created was that it was giving me positive values even though there was a credit document in the list.
    This was easily solved by an example in the book by just adding a simple ABAP code in the InfoSet. (and I'm not an ABAP'er so I can tell you that the book is very easy to follow)

    If you are just a bit interested in the SAP Query reporting and have access to SQ01, SQ02 and SQ03 in your business, I can just say: Purchase the book today... I can almost promise you will have difficulties to put it down. :0)

    I have purchased several books from SAP Press, and this is so far the best one I have read.
    (regardless of subject area)

  4. Practical book

    Posted by A SAP fan on Nov 24th, 2012

    SAP Query is powerful tool for functional consultants and end-users. The implementation time of SAP Query is much shorter compared with ABAP reports and BI. This book talks about all aspects of SAP Query, and comes with many useful sample queries.

Showing reviews 1-4 of 5 | Next

Write your own product review
If you have purchased this book you can share your experience with others!
review guidelines

Recently Viewed