SAP Note 21544 - Index recommendations for material matchcodes

Symptom:

Matchcode objects: MAT1, MAT2.
The matchcode IDs for material number and product group are, with one exception (matchcode ID K for material number), shipped as transparent matchcodes in the standard version.
As a result, when these matchcode IDs are used, a suitable index of the corresponding database tables should be defined in order to minimize runtime and CPU load during the matchcode search. Such indexes increase the system load when materials are defined or changed.
For this reason, the corresponding indexes are not shipped for all matchcode IDs in standard. This note describes how you can define suitable indexes for the matchcode IDs used in your system.

Cause and prerequisites

See above

Solution

Choose Tools -> ABAP/4 Workbench -> Development -> ABAP/4 Dictionary
In the "Object name" field, enter the table for which you want to define a new index and choose "Change". Then choose
"Goto -> Indexes ..." and enter any new index ID in the subsequent popup window, then enter the short description and the index fields in the subsequent screen. Then choose the function "Index -> Activate".

Indexes that are not part of the standard system must have the following structure:

• Matchcode IDs for material:

Short description I Tab. I Index fields
-------------------------------------I------I------------------------
A: Material for old material number I MARA I MANDT BISMT
As of Release 3.1G, this index for matchcode ID A is shipped
with the standard system.
C: Mat. copied from CAT system I MARA I MANDT CADKZ
As of Release 3.1G, this index for matchcode ID C is no longer
required.
E: Competitive product for competit. I MARA I MANDT KUNNR
H: Sales mat. for gen. product hier. I MARA I MANDT PRDHA
I: Material for vendor mat. number I EINA I MANDT IDNLF
P: Material for product hierarchy I MVKE I MANDT VKORG VTWEG PRODH
L: Material for material group I MARA I MANDT MATKL
Matchcode ID L is new for Release 3.0D

• Matchcode IDs for product group
  

W: Product groups for plant I MARC I MANDT WERKS
As of Release 3.0, you can dactivate any matchcode IDs that you do not use in your system. These matchcode IDs then no longer appear in the 'Search help selection' dialog box.
To deactivate matchcode IDs, call Transaction SE11. On the initial screen, enter object name MAT1 or MAT2, select the 'Matchcode objects' radiobutton and choose 'Change'. Then choose the 'MC IDs' button. You see a dialog box, in which you select the IDs you want to deactivate. Choose the function 'Matchcode ID -> Deactivate'. Finally, save and generate the changed matchcode object.

Additional key words

M_MAT1, M_MAT2, Performance, Index