Create database index 4 for table COEP/COEJ -> see long text
Message type: E = Error
Message class: KE -
Message number: 538
Message text: Create database index 4 for table COEP/COEJ -> see long text
What causes this issue?
You want to use <DS:GLOS.summarization_level>summarization levels</> or
<ZH>summarization data</> in account-based Profitability Analysis
(CO-PA). To obtain good performance when updating these forms of
presummarized data, you need to store indexes in the database. These
indexes do not yet exist in the database.
Press "Enter" to proceed with your work.
Details
In account-based Profitability Analysis, actual line items are stored
in table COEP, while plan line items are stored in table COEJ. To
ensure good performance when accessing these tables to update the
summarization levels or summarization data, the system requires the
index 4 in the database.
These indexes are only required for CO-PA, and are therefore not
automatically created.
If you have large data volumes and do not create these indexes, you
might experience poor system performance, especially when calling up
plan data or executing a report that uses the most current data. You
may receive the message "Reading new line items..." for several
minutes, even if no new data has been entered.
How to fix this error?
The solution described here requires good familiarity with the ABAP
Workbench and with the standard transport tools. If necessary, consult
with your Basis system administrator or consultant.
In the ABAP Dictionary, change the index definition of index 4 for
table <ZH>COEP</> to create the index in the database.
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
Call up the ABAP Dictionary transaction (transaction<DS:TRAN.SE11>SE11</>).
Enter the table name <ZH>COEP</> and choose "Display".
Choose "Goto -> Indexes" and select index 4.
Switch to the change mode ("Index -> Display<->Change").
Set the option "Index in all database systems".
Activate the index ("Index -> Activate").
Activate index 4 for table <ZH>COEJ</> as in step 1.
Once you have created the indexes, this message will no longer appear.
Error message extract from SAP system. Copyright SAP SE.