SAP Query Reporting—Practical Guide

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.

* ... Preface ... 13 * ... Introduction ... 17 * PART I ... Introduction to SAP Query ... 23 * 1 ... Introduction to SAP ERP Reporting ... 25 * 1.1 ... ABAP Report Generators ... 26 * 1.2 ... Query Reporting Tools ... 28 * 1.3 ... Comparing Analysis Tools: SAP Query and SAP NetWeaver BW ... 33 * 1.4 ... Cumulated Analyses with Multilevel Hierarchies ... 34 * 1.4.1 ... Summarization Hierarchies ... 35 * 1.4.2 ... Report Painter ... 36 * 1.4.3 ... Drilldown Reporting ... 40 * 1.5 ... Using Standard Reports ... 44 * 1.5.1 ... SAP Area Menus ... 44 * 1.5.2 ... Finding a Report in the SAP Menu ... 47 * 1.5.3 ... Searching the Menu for Standard Reports ... 49 * 1.5.4 ... Important Standard Transactions ... 50 * 1.6 ... Summary ... 52 * 2 ... Overview of SAP Tables and Table Links ... 53 * 2.1 ... Data Browser ... 53 * 2.2 ... Table Determination Options ... 58 * 2.2.1 ... F1 Help ... 58 * 2.2.2 ... Table Trace ... 64 * 2.2.3 ... Archiving Object ... 66 * 2.2.4 ... Where-Used List ... 68 * 2.3 ... Table Links ... 72 * 2.3.1 ... Customer Master ... 72 * 2.3.2 ... Sales Document ... 73 * 2.4 ... Summary ... 76 * 3 ... QuickViewer ... 77 * 3.1 ... QuickViewer Overview ... 77 * 3.2 ... Sample Data for Table TSTCT ... 78 * 3.3 ... QuickViewer Initial Screen ... 80 * 3.4 ... Steps for Creating a QuickViewer Report ... 82 * 3.4.1 ... Defining a QuickView Name and Description ... 82 * 3.4.2 ... Selecting a Data Source ... 84 * 3.4.3 ... Selecting Selection Fields and Layout Fields ... 85 * 3.5 ... Layout Mode ... 89 * 3.6 ... Summary ... 91 * 4 ... Overview of SAP Query ... 93 * 4.1 ... Fundamentals ... 94 * 4.2 ... Query Areas ... 96 * 4.3 ... User Group ... 99 * 4.4 ... InfoSet ... 103 * 4.5 ... SAP Query ... 109 * 4.6 ... Summary ... 114 * 5 ... Query Utilities ... 115 * 5.1 ... Overview of Query Utilities ... 116 * 5.2 ... Overview of Query Objects ... 119 * 5.3 ... Query Objects ... 121 * 5.3.1 ... Overview of User Groups ... 121 * 5.3.2 ... Query Overview ... 123 * 5.3.3 ... Directory Lists ... 123 * 5.4 ... Calling Query Object Descriptions ... 124 * 5.4.1 ... User Group Description ... 124 * 5.4.2 ... InfoSet Description ... 125 * 5.4.3 ... Query Description ... 128 * 5.5 ... Editing Functions for Query Objects ... 130 * 5.5.1 ... Copy Function ... 131 * 5.5.2 ... Trash Folder ... 133 * 5.5.3 ... Query Transport ... 134 * 5.6 ... Summary ... 135 * PART II ... SAP Query Functions ... 137 * 6 ... InfoSet in Detail ... 139 * 6.1 ... Data Sources ... 141 * 6.2 ... Automatic Text Recognition ... 143 * 6.3 ... Table Join ... 145 * 6.4 ... Field Groups ... 149 * 6.5 ... Individual Additional Fields ... 153 * 6.6 ... Selection ... 160 * 6.7 ... Summary ... 163 * 7 ... SAP Query in Detail ... 165 * 7.1 ... Fundamentals ... 165 * 7.2 ... Initial Screen ... 168 * 7.2.1 ... Changing User Group ... 168 * 7.2.2 ... Converting QuickView into a Query ... 169 * 7.2.3 ... Additional Functions on the Initial Screen ... 171 * 7.2.4 ... Additional Editing Options ... 174 * 7.3 ... Query Creation Screen ... 176 * 7.3.1 ... Query Title and Formatting ... 177 * 7.3.2 ... Output Format ... 179 * 7.4 ... Field Name ... 179 * 7.4.1 ... Changing the Column Header of Query Fields ... 181 * 7.4.2 ... Local Fields ... 182 * 7.4.3 ... Selection Fields ... 186 * 7.5 ... Basic List ... 187 * 7.6 ... Additional Functions ... 188 * 7.7 ... Summary ... 189 * 8 ... Selection and Layout Variants ... 191 * 8.1 ... Selection Screen ... 192 * 8.2 ... Selection Variants ... 198 * 8.3 ... Layout Variant ... 202 * 8.4 ... Summary ... 204 * 9 ... Traffic Light Icons, Drilldown, Graphics, and ABC Analyses ... 205 * 9.1 ... Symbols ... 206 * 9.2 ... Icons ... 211 * 9.3 ... Drilldown Options ... 215 * 9.4 ... Using Graphics and the ABC Analysis ... 219 * 9.5 ... Summary ... 222 * PART III ... Designing User-Friendly Reports ... 223 * 10 ... Summarized Data Output with Statistics and Ranked Lists ... 225 * 10.1 ... Example: Open Item List ... 226 * 10.2 ... Basic List Without a Graphical Query Painter ... 230 * 10.3 ... Statistics ... 239 * 10.4 ... Ranked List ... 246 * 10.5 ... Summary ... 248 * 11 ... ABAP Fundamentals in the InfoSet ... 249 * 11.1 ... ABAP Dictionary ... 249 * 11.2 ... Individual Data Objects in the InfoSet ... 254 * 11.2.1 ... Data Fields ... 255 * 11.2.2 ... System Fields ... 260 * 11.3 ... Helpful ABAP Code ... 262 * 11.3.1 ... Sample Code on the Editor Screen ... 262 * 11.3.2 ... IF Statement ... 265 * 11.3.3 ... SELECT Loop ... 268 * 11.3.4 ... SELECT SINGLE Statement ... 272 * 11.3.5 ... Other Helpful ABAP Commands ... 275 * 11.4 ... Using Your Own Code in the InfoSet ... 276 * 11.5 ... Summary ... 277 * 12 ... Integration with Microsoft Excel ... 279 * 12.1 ... Data Browser ... 279 * 12.2 ... Excel Inplace in SAP List Viewer ... 282 * 12.3 ... Microsoft Excel Integration for Other Query Output Formats ... 287 * 12.4 ... Summary ... 289 * PART IV ... Query Management ... 291 * 13 ... Transport System ... 293 * 13.1 ... Transport Dataset ... 294 * 13.2 ... Transport Tool ... 295 * 13.2.1 ... Transport Tool in the Standard Area ... 295 * 13.2.2 ... Transport Tool in the Global Query Area ... 296 * 13.3 ... Transport Options ... 297 * 13.4 ... Additional SAP Notes ... 299 * 13.5 ... Summary ... 300 * 14 ... Data Retrieval and Function Modules ... 303 * 14.1 ... Secondary Index ... 304 * 14.2 ... Table View ... 307 * 14.3 ... Function Module ... 314 * 14.3.1 ... Function Module for Converting the Time Dimension in the InfoSet ... 314 * 14.3.2 ... Function Module for Displaying Texts ... 320 * 14.4 ... Summary ... 329 * 15 ... Authorizations and Transaction Creation ... 331 * 15.1 ... Transactions in the Query Environment ... 331 * 15.2 ... User Groups ... 333 * 15.3 ... Authorization Objects ... 333 * 15.3.1 ... Authorization Groups ... 335 * 15.3.2 ... Authorization Object S_QUERY ... 336 * 15.4 ... Integrating Query Transactions into a User Role ... 337 * 15.5 ... Notes on Authorization Assignment ... 341 * 15.5.1 ... SAP Notes ... 342 * 15.5.2 ... Authorization Objects for Administrators and Developers ... 342 * 15.6 ... Summary ... 343 * PART V ... Real-Life Examples ... 345 * 16 ... Real-Life Examples ... 347 * 16.1 ... Procedure When Creating Reports ... 347 * 16.1.1 ... Brainstorming Workshop ... 347 * 16.1.2 ... Specifying Reports ... 349 * 16.2 ... Sales Evaluation ... 351 * 16.3 ... Financial Accounting Analysis Open Items ... 359 * 16.4 ... Production Planning Measuring Productivity ... 366 * 16.5 ... Summary ... 376 * ... Appendices ... 377 * A ... Important SAP Tables ... 377 * A.1 ... General ... 377 * A.2 ... Sales and Distribution ... 378 * A.3 ... Production ... 380 * A.4 ... Materials Management ... 381 * A.5 ... Financial Accounting and Controlling ... 384 * B ... The Author ... 391 * ... Index ... 393