How To Fix KE538 - Crear índice de base datos 4 en la tabla COEP/COEJ -> ver txt.explicativo

SAP Error Message - Details

• Message type: E = Error

• Message class: KE -

• Message number: 538

• Message text: Crear índice de base datos 4 en la tabla COEP/COEJ -> ver txt.explicativo

¿Qué causa este problema?

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.

¿Cómo arreglar este 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.

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

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.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.