Kaleske - SAP Query Reporting--Practical Guide

SAP Query Reporting--Practical Guide

Medium: Buch

ISBN: 978-1-59229-365-0

Verlag: SAP PR

Erscheinungstermin: 30.11.2010

67,50 € 63,08 € (zzgl. MwSt.)

Nicht mehr lieferbar

This book shows how to deploy the SAP Query tool to create reports and extend the standard reporting capabilities of an ERP system. This book uses many concrete, practical examples and solutions specifically geared toward accurate, efficient, and cost effective reporting.

The book covers the main SAP database tables so the reader can start creating targeted queries. In this way, the reader learns how to selectively query information from the SAP modules, i.e. SD (orders, sales, credit limit, accounts receivable), MM (stocks, creditors), PP (contracts, jobs), FI (open items, payment and DUNDAT) etc.

Readers learn from step-by-step instruction. The main features of the SAP Query tool are covered (e.g., drill-down functionality, rankings, statistics, traffic symbols, calculated fields of information, MS Office integration shown).

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

Produkteigenschaften

Artikelnummer: 9781592293650
Medium: Buch
ISBN: 978-1-59229-365-0
Verlag: SAP PR
Erscheinungstermin: 30.11.2010
Sprache(n): Englisch
Auflage: 1. Auflage 2010
Serie: SAP PRESS: englisch
Produktform: Gebunden
Gewicht: 894 g
Seiten: 402
Format (B x H x T): 184 x 240 x 32 mm
Ausgabetyp: Kein, Unbekannt

Themen

Autoren

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

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

SAP Query Reporting--Practical Guide

Beschreibung

Autoren/Hrsg.

Inhalt

Produkteigenschaften

Themen

Verlagspartner

Produktsortiment

Fachzeitschriften

Veranstaltungen

Site Breadcrumb

SAP Query Reporting--Practical Guide

Beschreibung

Autoren/Hrsg.

Inhalt

Produkteigenschaften

Themen