SAP Query Reporting Practical Guide
With over 100 ready-to-use queries
(Sprache: Englisch)
In this book, you'll learn how to utilize SAP Query for your business analysis needs in SAP FI, SAP SD, SAP MM, and more. The most essential SAP database tables are presented, enabling you to extract specific information from SAP ERP. Numerous screenshots,...
Leider schon ausverkauft
versandkostenfrei
Buch
69.95 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
- Ratenzahlung möglich
Produktdetails
Produktinformationen zu „SAP Query Reporting Practical Guide “
Klappentext zu „SAP Query Reporting Practical Guide “
In this book, you'll learn how to utilize SAP Query for your business analysis needs in SAP FI, SAP SD, SAP MM, and more. 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).1. 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.
2. All Major Query Features
Discover everything you need to know about selection and layout variants, drilldown functions,
icons, ABC analyses, and much more.
3. Designing User-Friendly Reports
Master challenging reporting requirements, including ABAP coding. Utilize ranked lists and statistics, Microsoft Excel integration, and much more.
4. 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.
5. Immediately Usable Queries for Download
The special feature of this book is 100 immediately usable queries, available on the publisher's Web site for download.
Highlights:
SAP Tables and Table Links
QuickViewer, SAP Query, Query Utilities
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
Inhaltsverzeichnis zu „SAP Query Reporting Practical Guide “
... 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.5 ... Using Standard Reports ... 44
... 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.3 ... Table Links ... 72
... 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.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.4 ... Calling Query Object Descriptions ... 124
... 5.5 ... Editing Functions for Query Objects ... 130
... 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.3 ... Query Creation
... mehr
Screen ... 176
... 7.4 ... Field Name ... 179
... 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.3 ... Helpful ABAP Code ... 262
... 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.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.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.4 ... Integrating Query Transactions into a User Role ... 337
... 15.5 ... Notes on Authorization Assignment ... 341
... 15.6 ... Summary ... 343
PART V ... Real-Life Examples ... 345
16 ... Real-Life Examples ... 347
... 16.1 ... Procedure When Creating Reports ... 347
... 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
... B ... The Author ... 391
Index ... 393
... 7.4 ... Field Name ... 179
... 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.3 ... Helpful ABAP Code ... 262
... 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.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.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.4 ... Integrating Query Transactions into a User Role ... 337
... 15.5 ... Notes on Authorization Assignment ... 341
... 15.6 ... Summary ... 343
PART V ... Real-Life Examples ... 345
16 ... Real-Life Examples ... 347
... 16.1 ... Procedure When Creating Reports ... 347
... 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
... B ... The Author ... 391
Index ... 393
... weniger
Autoren-Porträt von Stephan Kaleske
Kaleske, StephanSince 1994, Stephan Kaleske has worked as a project manager and SAP consultant for customers in the areas of mechanical engineering, plant engineering and construction, automotive, and services.
Bibliographische Angaben
- Autor: Stephan Kaleske
- 2010, 402 Seiten, Maße: 18,4 x 24 cm, Gebunden, Englisch
- Verlag: SAP Press
- ISBN-10: 1592293654
- ISBN-13: 9781592293650
- Erscheinungsdatum: 26.01.2011
Sprache:
Englisch
Kommentar zu "SAP Query Reporting Practical Guide"
0 Gebrauchte Artikel zu „SAP Query Reporting Practical Guide“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "SAP Query Reporting Practical Guide".
Kommentar verfassen