SAPTechno

Note 420493 - Collective note: Cost center assessment performance COPA

Header
Version / Date 3 / 2001-10-14
Priority Recommendations/additional info
Category Performance
Primary Component CO-PA Profitability Analysis
Secondary Components

Summary
Symptom

The runtime of the cost center assessment into the result (Transactions KEUB - Plan Assessment and KEU5 - Actual Assessment) is too long, it uses too many system resources and/or generates too many documents in CO-PA. There is a large number of notes that refer to the subject, but whose structure is not transparent and it takes a long time to study them.

Additional key words

KEU5, KEUB, ALLOCATION, cycle, segment, cycle run group, performance, runtime, lock, lockwait, deadlock, parallel

Cause and prerequisites

This note serves as an initial reference to optimize the situation described in the 'Symptom' section. For detailed information you still need to refer to the notes. We recommend to follow the structure specified in the 'Solution' section and to go through the notes in the specified order. You should start with Note 79758, then you should know which section of this note is especially interesting to you.
The validity of the results of an assessment into the result is not the purpose of this note (for example, no receiver/sender, incorrect values).

Solution

The referenced notes are assigned to the categories GENERAL, START, SELECTION and UPDATE.

In section GENERAL you find notes which help you understand the constellation and to carry out a suitable analysis. It gives general information on the avoidance of problems and the optimization of the set-up. Sometimes, the referenced notes contain more than the "CO-PA/Performance" so that only parts of these notes are relevant for the symptoms handled here.

In section START there are notes which describe the different options for planning and executing assessment cycles, including know problems. Key words: Job scheduling, parallel processing, cycle run groups, locking problems

Section SELECTION handles the different aspects of importing values from the database, no matter whether these are fixed values stored in the segment definition, transaction data of the sender side or transaction data for the determination of the receiver tracing factors. You should make sure to read Note 420081.
Key words: Selection by segment, summarization Level, CE4xxxx

Section UPDATE contains notes referring to the creation and posting of documents and the log function of the assessment in the involved applications. Key words: Local update, lock, CE4xxxx, document summarization, log

    1. GENERAL
      a) GENERAL ANALYSIS

79758 ALLOCATION: search cause of performance problems
416507 ALLOCATION: Troubleshooting guide

      b) GENERAL HINTS

79224 Allocations: Performance problems solution 1
206690 Overview Note: CO Assessments - Performance Related

    2. START

70094 ALLOCATION: Lock problem during background processing
92243 Cost center assessment into CO-PA: errors GA532/4
130350 ALLOCATION: Info for collective execution of cycles
396626 ALLOCATION: Transaction access takes too long

    3. SELECTION

      a) FIXED VALUE SELECTION

203711 ALLOCATION: Poor performance fixed percentages
319913 ALLOCATION: Poor performance w/fixed percentages

      b) SELECTION BY SEGMENT

122104 Performance: database selection by segment
126375 Allocations: selection by segment, performance
148365 Correction for performance: DB selection by segment
159266 Performance: database selection by segment
421569 ALLOCATION: Performance at segment-wise database selection

      c) SUMMARIZATION LEVEL SELECTION

63071 KEU5/KEUB: Selection of reference base
83204 Usage strategy for summarization levels
323308 Reading current data performance
359516 Reading current data from cost center assessment
415210 Performance analysis in the Profitability Analysis
420081 Configuration analysis of cost center assessment CO-PA

      d) OBJECT LEVEL SELECTION

140880 Long access times to table CE4xxxx
363890 Long runtimes when selecting CO-PA data

    4. UPDATE

      a) UPDATING CO-PA DOCUMENT

140880 Long access times to table CE4xxxx
363890 Long runtimes when selecting CO-PA data
393635 information: Information: Selection of tracing factors for assessment
415923 ALLOCATION: Summrztn of COPA line itms for selctn by segmnt

      b) UPDATING POSTING

25071 Parallel update programs block each other
43375 Allocation: local update background processing
116335 High number of update requests

      c) UPDATING LOG

388091 Assessment is not completed

Related Notes
766827Composite SAP note: Performance SCM 4.0
553626FAQ Note Profitability Analysis (CO-PA)
421569ALLOCATION: Performance at segment-wise database selection
420081Configuration analysis of cost center assessment CO-PA
416507ALLOCATION: Troubleshooting guide
415923ALLOCATION: Summrztn of COPA line itms for selctn by segmnt
396626ALLOCATION: Transaction access takes too long
393635Information: Selection of tracing factors for assessment
388091Assessment is not completed
363890Long runtimes with update and selection