Making Microsoft Excel Pivot Tables Using SAP Report Data


One of the best options in SAP reporting is the ability to have your SAP data automatically converted to an Excel pivot table report. A pivot table report allows you to slice and dice your data and analyze it multiple ways, without having to use a database or code logic. As Microsoft likes to say, using a pivot table can help you see the big picture by summarizing and analyzing your data in a simple table format.

You have the option of downloading any relevant report to a pivot table via any basic report output screen in SAP. That is, the ability to download to Excel pivot tables is not specific to a particular SAP reporting tool; it can be done via any of them, including custom ABAP reports.

You have multiple options for how to get your SAP data into Excel, each of which varies depending on your installation version of SAP R/3 and your installation version of Excel. Because there are multiple options for different versions, the menu path and buttons vary for each. A popular way to do so is to click the Excel button on your Report Output toolbar (see Figure 21.14). Microsoft Excel launches, displaying your SAP report in a Microsoft Excel worksheet that has multiple tabs, one of which is labeled Pivot (see Figure 21.15). Working with your SAP report data in a pivot table gives you additional options in analyzing your report output. To learn more, visit www.support.microsoft.com and search for "PivotTable reports 101."

Figure 21.14. This sample SAP report contains data from the SAP Flight Scheduling Test system.


Figure 21.15. When a report is converted to a pivot table in Excel, the column headings change to drop-down boxes to make it easier to work with the data.





SAP Query Reporting
SAP Query Reporting
ISBN: 0672329026
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net