With drilldown reporting, SAP provides you with an interactive information system to let you evaluate the data collected in your application. This information system is capable of analyzing all the data according to any of the characteristics that describe the data. You can also use any key figures you wish to categorize your data. You can display a number of objects for a given key figure, or a number of key figures for a given object. In addition, the system lets you carry out any number of variance analyses (such as plan/actual comparisons, fiscal year comparisons, comparisons of different objects, and so on).
You can produce both simple, data-directed lists (basic reports) and complex, formatted lists in drilldown reporting (form reports).Drilldown report provides you with comfortable functions for navigating through your data. For example, you can jump to the next level of detail or the next report object on the same level, hide individual levels and switch between the detail and drilldown lists. It also provides a number of additional functions which let you process lists interactively (sorting, conditions, ranking lists, and so on). SAP Graphics, SAPmail and the Excel List Viewer are also integrated into drilldown reporting.The drilldown functions are divided into three groups which differ in the number of functions available. That way each user can choose the functional level most suited for his requirements.In addition to the online functions for displaying reports, drilldown reporting also provides functions which let you print reports. A number of formatting functions are available to let you determine the look of your printed reports (page breaks, headers and footers, underscores, and so on).The menus and the functions available directly on the drilldown report make it easy to use the information system. CA - Drilldown Reporting ................. 8 Introduction to Drilldown Reporting.............................
9 Functional Overview................... 10 Architecture of Drilldown Reporting...........................
11 Basic Concepts of Drilldown Reporting..................... 12 Basic Reports and Form Reports ...............................
14 Basic Report ............................ 17 Report using a Form................ 19 Report ... 23 Creating/Changing a Report....... 25 Functions for Defining Reports. 26 Choosing Key Figures .............. 29 Choosing Characteristics......... 30 Characteristic Values<0} ..... 31 Choose Hierarchy............... 33 Hierarchy Node .................. 34 Replacing Variables................. 35 Output Type............................. 37 Setting the Output Type ...... 39 Defining HTML Templates .. 41 Creating an HTML Template................................ 43 Creating an HTML Template: Special
Information................................ 44 Report Assignment .................. 46 Selecting Data Step by Step..... 47 Settings.................................... 48 Number Format .................. 49 Variables...................................... 50 Variables for Characteristic Values
........................... 52 Variables for Hierarchies and Hierarchy Nodes ........ 54 Variables for Texts................... 55 Variables for Formulas ............. 57 Defining Global Variables........ 58 User Exits: Global Variables..... 59 Example: Use of Variables ....... 60 Replacing Variables................. 61 Maintaining Variables .......... 63 Characteristic Hierarchies .......... 64 Entering and Using a Hierarchy Node....................... 67 Hierarchy Display .................... 69 Functions for Editing Hierarchies
.............................. 72 Currencies and Units of Measure ...............................
74 Example: Inverse Rates ........... 77 Overview: Report/Report Interface .............................
79 How to Use the Report/Report Interface ................... 81 Example: Report/Report Interface............................. 83 Report/Report Interface: Transformation of Selection
Data............................ 84 Forms.... 88 Overview: Forms......................... 89 Creating/Changing a Form.......... 90 Example: Creating a Form (CO-PA).......................... 92 Example: Creating a Form (EC-EIS/CO-PC) ............ 94 Example: Creating a Form (FI). 96 Defining Elements ...................... 98 General Data Selection............. 102 Drilldown List and Defining Percentage Shares...... 103 Form Settings............................ 104 Executing a Report ................... 106 Executing Reports with............. 107 Creating Variants and Variant Groups ..................... 108 Example of the Use of a Variant Group................... 110 Report Information ................... 111 Report and Cell Parameters... 112 Key Figure Information ........... 114 Report Texts .......................... 115 Writing Comments ................. 116 Highlight Comment........... 117 Display Document ................. 118 Maintain Header .................... 119 Maintain Footer...................... 120 Layout Display .......................... 121 Function Levels for Different Users..........................
122 How to Process Report Lists.... 123 Functions for Report Lists........ 124 Navigation ................................. 130 Report List ............................. 131 Drilldown List .................... 132 Choose next level............. 133 Other characteristic ........... 134 -> Next level ..................... 135 <- Go to previous level ...... 136 Period screen ................... 137 Detail List.......................... 138 Initial list (Report List)........ 139 Scrolling Functions for Report Lists.........................
140 First Column..................... 141 Previous Column.............. 142 Next Column..................... 143 Last Column ..................... 144 Previous Page .................. 145 Next Page......................... 146 Other Characteristic Value 147 Hierarchy ............................... 149 Expand ............................. 150 Expand to level................. 151 Expand all......................... 152 Collapse............................ 153 Set focus .......................... 154 Undo focus ....................... 155 Choose Hierarchy............. 156 Hierarchy Display .............. 157 Report/Report Interface......... 158 Hide Characteristic ................. 160 Sort Characteristics ................ 161 Attributes................................ 162 Line Items .............................. 163 Display Master Data ............... 164 Find string.............................. 165 Hotspots on the Report List .... 166 Example: Navigating Using Hotspots................. 168 Navigation in Graphical Reports..............................
177 Defining Display Conditions..... 179 Function Levels for Different Users .........................
180 Creating a Ranking List .......... 181 Create Condition.................... 183 Processing Conditions....... 184 Overview: Exception Reporting ...............................
185 Using Exceptions.............. 187 Create Exception.............. 189 Editing Exceptions....... 190 Analysis Functions................. 191 Functions Available on Report Lists ........................ 192 Number Format ..................... 193 Currency ................................ 194 Characteristic Display............ 195 Totals row .............................. 196 Undo totals row ................. 197 Totals rows... .................... 198 Format Display On/Off............ 199 Cumulative Display On/Off ..... 200 Zero Display On/Off............... 202 Column(s) On/Off .................. 203 Sort Columns......................... 204 Percentage/Absolute .............. 205 Maintain Footer...................... 206 Maintain Header .................... 207 Sort Ascending ...................... 208 Sort Descending .................... 209 Undo All Settings ................... 210 Form Settings ................... 211 Saving, Printing, Exporting, Sending, Graphics...... 212 Save..... 213 Freeze data ........................... 214 Save structure ....................... 215 Freezing Report Data in the Background Using Variants
............................. 216 Printing Reports........................ 217 Printing from the R/3 System . 219 Example: Mass Print Drilldown List.................... 222 Printing from Word for Windows.............................. 225 Printing Graphics.............. 227 Print Setup............................. 228 Printing Reports with Characteristic Hierarchies ..... 234 Printing in the Background Using Variants.............. 237 Setting the Print Parameters .. 239 Sample Printout ..................... 240 Print Settings ......................... 244 Print row by row................ 245 Print Preview .................... 246 Format Display On/Off ...... 247 Maintain Footer ................. 248 Maintain Header ................ 249 Page break ....................... 250 Mass print settings ............ 251 Optimal / set ..................... 252 Other settings... ................. 253 Column(s) On/Off .............. 254 Sort Columns.................... 255 Set to default .................... 256 Set column width.............. 257 SAP Title Page On/Off ...... 258 Maintain Title Page............ 259 Underscore....................... 260 Number format ................. 261 Exporting Reports .................... 262 Transferring Reports to XXL... 264 Transfer Page to XXL............. 266 Save as File........................... 267 Transfer to MS Word .............. 268 Graphic to Word On/Off .... 269 Copy to Report Portfolio ......... 270 Send .... 271 Graphics .................................... 272 Optimizing Performance ........... 278 Summarization Levels.............. 280 Example: Optimizing Performance ........................... 284 Reorganization and Conversion ............................... 285
Related 10 Reports Tutorials
Most readed SAP Tutorials
- WRITE - Output to a list ( SAP ABAP Keyword)
WRITE ( Output to a list ) is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details. - List of SAP HR TABLES and Infotypes tables
Detailed full list of tables and infotypes used in SAP HR module. - List of SAP MM Transaction codes
This documentation covers the details of SAP MM Transaction codes - SELECT-OPTIONS ( SAP ABAP Keyword)
SELECT-OPTIONS is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details. - FI Accounts Receivable and Accounts Payable | SAP FI PDF manual
The following topics are an introduction to the Accounts Receivable and Accounts Payable application components. - SAP MM Process Flow
The typical procurement cycle for a service or material consists of the following phases: - SELECT clause ( SAP ABAP Keyword)
SELECT clause is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details.
Latest Added SAP documents
- 9KE9 Transaction code
Details about SAP transaction code 9KE9 - 9KE8 Transaction code
Details about SAP transaction code 9KE8 - 9KE7 Transaction code
Details about SAP transaction code 9KE7 - 9KE6 Transaction code
Details about SAP transaction code 9KE6 - 9KE5 Transaction code
Details about SAP transaction code 9KE5 - 9KE4 Transaction code
Details about SAP transaction code 9KE4 - 9KE3 Transaction code
Details about SAP transaction code 9KE3 - 9KE2 Transaction code
Details about SAP transaction code 9KE2 - 9KE1 Transaction code
Details about SAP transaction code 9KE1 - 9KE0 Transaction code
Details about SAP transaction code 9KE0