Create database index 3 for table &2 -> see long text

Message type: E = Error

Message class: KE -

Message number: 539

Message text: Create database index 3 for table &2 -> see long text



What causes this issue?

You tried to
select line items according to the current structure (taking any
realignments into account) from or
archive line items from
table &V2& for costing-based CO-PA.
To ensure good performance, the system requires a special index in the
database.
This index does not exist. You can still execute the function without
the index, but you should expect longer runtimes if the data volume is
large.


Additional Information
Index 3 is required in the database for table &V2& in order to ensure
good performance.
For operating concerns that were defined before Release 4.5A, this
index exists in the ABAP Dictionary but not in the database. This was
meant to save time during the upgrade.


How to fix this error?

Create index 3 in the database by changing its definition for table
&V2& in the ABAP Workbench.
This requires you to have good knowledge of the ABAP Workbench and the
transport tools. If necessary, contact your Basis administrator.
RESET N1
Call up the ABAP Dictionary transaction (transaction
<DS:TRAN.SE11>SE11</>).
Enter table name &V2& and press "Display".
Choose "Goto -> Indexes" and select index 3.
Switch to change mode ("Index -> Display<->Change").
Activate the option "Index on all database systems".
Activate the index ("Index -> Activate").
Once you have created the index in the database, this message will no
longer appear.

Error message extract from SAP system. Copyright SAP SE.