SAP Query Reporting

Series
Sams
Author
Danielle Signorile Larocca  
Publisher
Sams Publishing
Cover
Softcover
Edition
1
Language
English
Total pages
336
Pub.-date
July 2006
ISBN13
9780672329029
ISBN
0672329026
Related Titles


Product detail

Product Price CHF Available  
9780672329029
SAP Query Reporting
55.90 approx. 7-9 days

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

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

Back Cover

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

Author

Danielle Larocca Signorile, an independent executive SAP consultant, has written a handful of books on SAP technologies. Danielle is a featured speaker at many SAP conferences throughout the United States. Her articles have been published in multiple trade magazines, including SAP Professional Journal, SAP Insider, and SAP HR Expert, a publication on which she served as an advisor and columnist for the “Ask the Expert” section. Danielle has also been interviewed for HR Executive Magazine. She earned a bachelor of science degree in psychology and holds certificates and certifications for many areas of SAP, including Human Resources, ABAP Programming, and Basis Technologies. Danielle is an ABAP programmer as well as an expert on SAP query-based reporting and the Human Capital Management module. Danielle has documented and instructed people on multiple computer languages and applications, including ABAP, Visual Basic, Electronic Data Interchange (EDI), Oracle, PeopleSoft, and SAP. Danielle is also an avid technical and leisure reader. She is currently working for the 12th-largest employer in the world, Compass Group, as vice president of HR Information Systems for the Americas Division.

 

Danielle is originally from Massapequa, Long Island, New York. She and her husband James and their chocolate Labrador retriever, Casey, live in Weddington, North Carolina. They can be reached at jcsdl@prodigy.net.