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 This book shows you how to deploy the SAP Query tool to create reports and extend the standard reporting capabilities of an ERP system. With many concrete, practical examples and solutions specifically geared toward accurate, efficient, and cost effective reporting, the author leaves no stone unturned. Coverage includes the main SAP database tables so that you can start creating targeted queries immediately and discover how best 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. In addition, step-by-step instruction complements details on the main features of the SAP Query tool (e.g., drill-down functionality, rankings, statistics, traffic symbols, calculated fields of information, MS Office integration shown). Introduction to SAP ERP reporting Overview of SAP tables and table links Quickviewer Overview of SAP query Query utilities Infoset in detail SAP query in detail Selection and layout variants Traffic light icons, drilldown, graphics, and ABC analyses Summarized data output with statistics and ranked lists ABAP fundamentals in the infoset Integration with microsoft Excel Transport system Data retrieval and function modules Authorizations and transaction creation Real-life examples Important SAP tables.
