A Quick Look at How to Use "Frozen" Data, and Speed Up Your CO-PA Report Response Speeds in the Process!

  • by Tony Rogan, Consultant, SAP America
  • February 15, 2002
Typical CO-PA reports are much more complicated than average reports. Once you click on the "Execute" button, it's not uncommon to see a 500 percent slowdown while the system retrieves all the relevant data from the database, online. As you'll see in this article, you can greatly speed up the execution of your CO-PA reports: you can implement your CO-PA module to allow for both high data volumes and fast system response speeds for your end users by using "frozen" data rather than retrieving the real-time data.

I have assisted many clients with implementing their CO-PA modules in a way that allows both high data volumes and fast system response speeds for the end user to co-exist. When examining a particular CO-PA design point for its potential impact, I look for interactions in configuration, reporting, and posting data that would lead to performance degradations.

This article describes some lessons I have learned with the "Freeze Data" function, and offers guidance on how you can avoid some potential pitfalls when implementing this option.

What Is "Frozen" Data?

Most accounting reports in SAP R/3 are considered to be "real-time," meaning that your mouse-click on the "Execute" button leads the system to immediately go and retrieve all the data from the database that pertains to your particular request.

Tony Rogan

Tony Rogan is a certified FI/CO consultant at SAP with eight years of SAP consulting experience. He began his SAP career with a Big 5 consulting firm and over the years has worked in various industries, including utilities, non-profit, high-tech, consumer goods, and process manufacturing. Tony’s expertise lies in the Financial and Controlling modules, with emphasis on Cost Center Accounting, Profitability Analysis, Internal Orders, Profit Center Accounting, Special Purpose Ledger, Project Systems, and Product Costing. He also has experience working with Enterprise Consolidations, LIS, and Business Information Warehouse.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.