SAP Query Reporting

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

CONTENTS:

About the Author vii

Dedication vii

Acknowledgments vii

Chapter 1: Getting Started with the SAP R/3 Query Reporting Tools 1

Chapter 2: One-Time Configuration for Query Tool Use 11

Chapter 3: Creating Basic Reports with the SAP Query Tool 23

Chapter 4: The Fundamentals of Reporting with the SAP Query Tool 41

Chapter 5: Basics of Using Reporting Selection Screens 55

Chapter 6: Using Reporting Selection Screens: Advanced Skills 71

Chapter 7: Creating Advanced Reports with the SAP Query Tool 85

Chapter 8: Creating Extract Files and Interfaces with the SAP Query Tool 107

Chapter 9: Creating Basic Calculated Fields with the SAP Query Tool 119

Chapter 10: Creating Advanced Calculated Fields with the SAP Query Tool 133

Chapter 11: Inserting Pictures and Graphics in SAP Queries 143

Chapter 12: Creating Simple Statistics Lists with the SAP Query Tool 157

Chapter 13: Creating Advanced Statistics Lists with the SAP Query Tool 169

Chapter 14: Creating Ranked Lists with the SAP Query Tool 179

Chapter 15: HR and Payroll Reporting Options in the HCM Module 187

Chapter 16: Special Considerations for Configuring HR and Payroll Reportingin the HCM Module 199

Chapter 17: Special Considerations for HR and Payroll Reporting in theHCM Module 211

Chapter 18: Security Concepts in SAP R/3 Query-Based Reporting Tools 225

Chapter 19: Creating Basic Reports with the InfoSet (Ad Hoc) Query Tool 231

Chapter 20: Creating QuickViews by Using QuickViewer 243

Chapter 21: SAP Reporting with Microsoft Excel 255

Chapter 22: SAP Query Reporting with Microsoft Word and Outlook 269

Chapter 23: SAP Reporting with Microsoft Access 285

Appendix: Quick Reference Guide 299

Index 317