How To Fix KE538 - Créer index de base de données 4 sur table COEP/COEJ -> voir texte descr.

SAP Error Message - Details

• Message type: E = Error

• Message class: KE -

• Message number: 538

• Message text: Créer index de base de données 4 sur table COEP/COEJ -> voir texte descr.

Quelle est la cause de ce problème?

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.

Comment corriger cette erreur?

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.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

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.

Extrait du message d'erreur du système SAP. Copyright SAP SE.