Issue/Solution: COPA Performance Improvement using Summarization Levels

Issue:
Very long processing time or frequent TIME_OUT errors while execution of COPA reports (KE30) or assessment cycles.

Solution:

1. Activate CO-PA log (T-Code KEDZ, Program: RKE_PROT_EVALUATE)

Purpose:
Any COPA report/cycle execution or data access from COPA tables would be recorded in the log after this activation. This allows SAP to analyze the CO-PA usage pattern /access information based on which automated summarization levels could be created to improve COPA performance.

Execution Steps:
Execute t-code KEDZ

• Enter the Operating Concern (PI02) and click “Activate” (Ctrl+F1)

2. Collect CO-PA log data for a few weeks or months. (T-Code KE30, KEU2, etc)
This will be done automatically by the system when COPA reports or assessment cycles are executed.
For quick resolution in reports with poor performance, you may choose to execute all COPA reports /cycles, for which performance improvement is required to update the log data.

3. Create Summarization levels proposal (T-Code: KEDVP, Program: RKETRERU)

Purpose:
In this step, the system would read the access log information as recorded in step 2 and present a proposal to create summarization levels according to the database access patterns identified in the COPA log.

Execution steps:
Execute t-code KEDVP

• Enter Operating Concern
• Select COPA Type (Costing Based /Account Based)
• Select the type of proposal to be created
  -Enhancement: Existing summarization levels are taken into account during optimization, and only additional summarization levels are proposed
  - Replacement: With this type of proposal, all existing summarization levels are ignored. The proposed summarization levels replace the existing levels. Even replacement proposal does not delete any existing summarization levels. However existing levels can be manually deleted using T-Code KEDV
• Select the period (select maximum period for which log data is available) for which logged COPA transaction data should be considered to create the proposal.
• Click “Create Levels” button to accept the summarization level proposal displayed

Note: The analysis can take quite a long time. If the program aborts during dialog processing, due to run time being exceeded, restart the program in background processing. To display the result when the program has completed, choose Display last proposal.

4. Build Summarization levels (T-Code: KEDU)

Purpose: Large volume of data available in COPA tables is organized into various summarization levels using this transaction, which allows for quick data access at the summary levels for various reports and cycle executions instead of the high time and system consuming process of direct data retrieval from COPA tables.

Execution Steps
Execute t-code KEDU

• Enter Operating Concern
• Choose type of Profitability analysis (Costing/Account)
• Select “Build new Levels”
• Execute in background mode only using menu option Program > Execute in Background (F9)
• Click “Immediate”
• Click “Save”

5. Wait for the summarization level build process to complete (T-Code: SM37)

Status of the background job scheduled in step 4 can be using t-code SM37 with job name “RKETRER


6. Schedule a Daily Background Job to refresh summarization level data (T-Code: KEDU/SM36)

Purpose: The summarization levels created above would hold only the data available in COPA tables as on 30 minutes before the build process. To update the summary tables with the latest transaction data, summarization level refresh process needs to be executed daily.

Execution Steps:
Execute t-code KEDU

• Enter Operating Concern
• Choose type of Profitability analysis (Costing/Account)
• Select “Refresh”
• Save as a variant “COPA Summarization Refresh”

Execute t-code SM36

• Click “Job Wizard” button
• Click Continue
• Enter a descriptive job name (example: COPA summarization refresh) and priority, leave the target server blank and click “continue”
• Select “ABAP Program Step” and click “Continue”
• Enter ABAP program name as “RKETRERU” and choose variant “COPA Summarization Refresh” and click “Continue”
• Do not select add additional steps and click “Continue”
• Select option “Date/Time” and click “Continue”
• Enter a scheduled start date and time (non- business hour) , Check “Periodic” and click “Continue”
• Select “Daily” and click “Continue”
• Click “Complete”

Notes:

- Report for which performance improvement is sought must be configured to use the summarization levels in the report option field for presummarized data
- Population of initial summarization level , could be a very time consuming job and hence it may require to be executed into multiple parts with different executions for different summarization levels.
- Do not execute t-code KEDV while trying to execute a background job for summarization level population using KEDU.