How To Fix KE538 - Bitte Datenbankindex 4 auf Tabelle COEP/COEJ anlegen -> siehe Langtext

SAP Error Message - Details

• Message type: E = Error

• Message class: KE -

• Message number: 538

• Message text: Bitte Datenbankindex 4 auf Tabelle COEP/COEJ anlegen -> siehe Langtext

Was verursacht dieses Problem?

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.

Wie behebe ich diesen Fehler?

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.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

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.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE