You are previewing SAP Query Reporting.
O'Reilly logo
SAP Query Reporting

Book Description

SAP Query Reporting is everything an SAP user needs to know to create your own reports in SAP using Query tools, no programming required! Designed as a hands-on learning aid, you will be able to follow along and perform each new skill learned on your own SAP system. The book's tutorial style, step-by-step instruction will teach you everything you need to know to use the SAP Query tools, including its configuration, advanced usage, and integration to Microsoft. Additionally the book gives best business practice recommendations for the technology and internal business use of the tools. Learn to:

  • Understand query security, table reads, and table joins

  • Perform basic and advanced calculations

  • Incorporate pictures and graphics into reports

  • Configure shortcuts and tran codes, schedule jobs and email PDFs

  • Utilize SAP Reporting with Microsoft Office applications

  • Table of Contents

    1. Cover Page
    2. Title Page
    3. Copyright Page
    4. Contents at a Glance
    5. Table of Contents
    6. About the Author
    7. Dedication
    8. Acknowledgments
    9. Chapter 1. Getting Started with the SAP R/3 Query Reporting Tools
    10. Chapter 2. One-Time Configuration for Query Tool Use
    11. Chapter 3. Creating Basic Reports with the SAP Query Tool
    12. Chapter 4. The Fundamentals of Reporting with the SAP Query Tool
    13. Chapter 5. Basics of Using Reporting Selection Screens
    14. Chapter 6. Using Reporting Selection Screens: Advanced Skills
    15. Chapter 7. Creating Advanced Reports with the SAP Query Tool
    16. Chapter 8. Creating Extract Files and Interfaces with the SAP Query Tool
    17. Chapter 9. Creating Basic Calculated Fields with the SAP Query Tool
    18. Chapter 10. Creating Advanced Calculated Fields with the SAP Query Tool
    19. Chapter 11. Inserting Pictures and Graphics in SAP Queries
    20. Chapter 12. Creating Simple Statistics Lists with the SAP Query Tool
    21. Chapter 13. Creating Advanced Statistics Lists with the SAP Query Tool
    22. Chapter 14. Creating Ranked Lists with the SAP Query Tool
    23. Chapter 15. HR and Payroll Reporting Options in the HCM Module
    24. Chapter 16. Special Considerations for Configuring HR and Payroll Reporting in the HCM Module
    25. Chapter 17. Special Considerations for HR and Payroll Reporting in the HCM Module
    26. Chapter 18. Security Concepts in SAP R/3 Query-Based Reporting Tools
    27. Chapter 19. Creating Basic Reports with the InfoSet (Ad Hoc) Query Tool
    28. Chapter 20. Creating QuickViews by Using QuickViewer
    29. Chapter 21. SAP Reporting with Microsoft Excel
    30. Chapter 22. SAP Query Reporting with Microsoft Word and Outlook
    31. Chapter 23. SAP Reporting with Microsoft Access
    32. Appendix A. Quick Reference Guide
    33. Index