Solution : https://service.sap.com/sap/support/notes/35288 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the need for technical documentation and optimization strategies for the CO-PA system, particularly concerning performance issues with table CE4xxxx during data posting. Root causes can be traced to the use of indexes in segment number identification when processing documents in Profitability Analysis. Optimal system performance requires efficient identification through selective use of secondary indexes which contain restrictive characteristics of the segment table. A preliminary release of related documentation will be included in the Release 3.0D CD, potentially applying to various releases as clarified in the documentation. Additionally, the information provides guidance on constructing selective indexes to support quick segment number determination and minimize the system load, especially under heavy posting scenarios or when managing hierarchical data levels.
Key words :
account-based profitability analysisa similar problem arises, kndnr customer numberartnr product numberfkart record type, reporting ke30 ke31 ke32 ke33, table space psapce3d primary index ce3xxxx0, additional field takes disk space, table space psapce4d indexes ce4xxxxn, hierarchical levelsthe secondary index proposed, table space psapce4i table ce3xxxx, system automatically transfers billing documents, segment levelthe segment level -- ce3xxxx --
Related Notes :
| 544241 | INFO:Customizing Monitor new fnc 'Report Overview'. |
| 535284 | IDOC interface IST_EBS_TOI_COPA, CO-PA problems |
| 524590 | Characteristic derivation w/ realignments as of Release 4.0 |
| 443404 | Performance: CE4xxxx tables on SQL server |
| 441178 | Performance during update of IS-U into CO-PA |
| 363890 | Long runtimes with update and selection |
| 206690 | Overview Note: CO Assessments - Performance Related |
| 195471 | SAP Banking performance |
| 140880 | Long access times to table CE4xxxx |
| 83204 | Usage strategy for summarization levels |
| 74486 | INFO: Overview of consulting notes for CO-PA |
| 72110 | KE11: Long processing times / timeout |
| 33836 | Index structure for the object table in CO-PA |
| 31184 | Physical distribution of CO-PA data |