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
Provides step-by-step content for using the SAP Query Tool
Covers relevant content for all ERP components (SD, MM, PP, FI, CO, etc.)
Includes 100 ready-to-use Queries
Stephan Kaleske
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.
SAP Query Tool Reporting Business Intelligence ERP SAP FI SAP Financials SAP R/3 report painter sap handbooks