SAP Query Reporting--Practical Guide

1. Auflage 2010
ISBN: 978-1-59229-365-0
Verlag: SAP PR

Buch, Englisch, 402 Seiten, Format (B × H): 184 mm x 240 mm, Gewicht: 894 g

Reihe: SAP PRESS: englisch

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

Autoren/Hrsg.

Kaleske, Stephan

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP
• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
• Mathematik | Informatik EDV | Informatik Angewandte Informatik Wirtschaftsinformatik

Inhaltsverzeichnis

... Preface ... 13 ... Introduction ... 17PART I ... Introduction to SAP Query ... 231 ... 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 ... 522 ... 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 ... 763 ... 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 ... 914 ... 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 ... 1145 ... 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 ... 135PART II ... SAP Query Functions ... 1376 ... 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 ... 1637 ... 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 ... 1898 ... Selection and Layout Variants ... 191 ... 8.1 ... Selection Screen ... 192 ... 8.2 ... Selection Variants ... 198 ... 8.3 ... Layout Variant ... 202 ... 8.4 ... Summary ... 2049 ... 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 ... 222PART III ... Designing User-Friendly Reports ... 22310 ... 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 ... 24811 ... 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 ... 27712 ... 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 ... 289PART IV ... Query Management ... 29113 ... 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 ... 30014 ... Data Retrieval and Function Modules ... 303 ... 14.1 ... Secondary Index ... 304 ... 14.2 ... Table View ... 307 ... 14.3 ... Function Module ... 314 ... 14.4 ... Summary ... 32915 ... 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 ... 343PART V ... Real-Life Examples ... 34516 ... 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

Über Autor(innen)

Kaleske, Stephan
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.