Is your Controlling – Profitability Analysis (CO-PA) system performance not meeting your business user’s expectations? Have you heard about the SAP CO-PA Accelerator for SAP HANA? Are you accountable to build the business case for adopting SAP HANA to take advantage of this exciting new in-memory technology? If you have answered yes to these questions, then read this fourth weblog of the CO-PA tools series and learn how the CO-PA Assessment Cycle Analysis Tools can be used to gather important statistical data about your CO-PA system.
Execute Actual Assessment – Analysis Tools
In a previous weblog on CO-PA tools I demonstrated use of transaction Might HANA Help? Use Transaction KEUD to View CO-PA Assessment Cycle Overview to identify the assessment cycles which contain segments that allocate costs to CO-PA using variable portion tracing factors. Variable portion allocation rules can be slow performing in ERP when data has to be retrieved from traditional databases. But with the CO-PA Accelerator the read time of the CO-PA tables can be greatly improved when reading from the SAP HANA in-memory database. So how do you separate and quantify the time CO-PA spends reading data verses writing new records? The answer is to use the analysis tools which are available when you execute an allocation (transactions KEU5 Actual Assessment and KEUB Plan Assessment).
Program SAPMKGA2 is assigned to transaction KEU5 and its purpose is to transfer cost center costs to Profitability Analysis through the execution of assessment cycles. CO-PA Assessments are notoriously a performance bottleneck in some CO-PA systems. Since CO-PA allocation is an area that can be greatly accelerated by use of SAP HANA let us look at the statistical information which is available from KEU5.
Start transaction KEU5 and click on the Settings button.
From the Settings pop up dialogue, select the “Flow Trace On” and “Runtime Analysis On” options then press F8 or click on the Copy Values icon to close the dialogue.
After executing the assessment the flow trace information is available from the menu Tools –> Technical Statistics.
Expand the Runtime Log folder where you can see statistics for the Database Selection time, as well as the Generated Line Items.
Keep in mind that the log above explains the runtime for the entire group of cycles and segments which were executed collectively. To view a more granular view of the individual cycles, use the Runtime Analysis tool.
From the initial screen of transaction KEU5 the Runtime Analysis is available from the menu Goto –> Runtime Analysis.
In the display of the Runtime Analysis you can get a history of cycle executions including the total runtime broken down by individual cycles.
The screen captures presented above are taken from a demo system and do not indicate a CO-PA performance issue. But many productive CO-PA systems do experience slow processing times with Assessments. If this is your situation and you want to estimate the potential time savings to your period end closing if you license SAP HANA, then you can use the KEU5 Analysis Tools to ascertain the exact amount of time the cycles take to read reference data. This read access time can be dramatically reduced using the CO-PA Accelerator and SAP HANA.