How To Fix MC076 - El índice & en la tabla & aún no existe en la base de datos.

SAP Error Message - Details

• Message type: E = Error

• Message class: MC - Aggregate: views, matchcodes, lock objects

• Message number: 076

• Message text: El índice & en la tabla & aún no existe en la base de datos.

¿Qué causa este problema?

When a transparent matchcode ID (update type = 'I') is activated, there
is a check whether a "suitable" database index exists for this
matchcode ID. Such a database index is generally necessary in order to
support the matchcode search in a selection which is typical for this
matchcode. If no corresponding database index exists, there could be
considerable performance problems during matchcode selection.
The system assumes that the first field in the matchcode definition
(the first field after the client field for client-specific matchcodes)
is the relevant search field for this matchcode, i.e. that the end user
limits this field during the matchcode search by entering a selection
value. An index which contains the relevant matchcode search field as
the first field (possibly after a client field) is therefore considered
to be a "suitable" database index.

Respuesta del sistema

The system has now found that a "suitable" index as described above is
defined in the table of the ABAP/4 Dictionary specified in the message,
but a corresponding index was not yet created in the database.

¿Cómo arreglar este error?

Create the required index on the database using the database utility of
the ABAP/4 Dictionary (e.g. by calling the transaction SE14).

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