Extension Index 

 

With an extension index you can create an additional index for a table in a system other than the original system of the table. Indexes are used to speed up searches in tables.

When an extension index is created, the relevant table remains unchanged. An extension index is an enhancement of the standard. Extension indexes are automatically copied over during upgrades and no modification adjustment takes place.

 

To create an extension index, proceed as follows:

 

...

       1.      On the ABAP Dictionary initial screen, enter the name of the table for which the additional index is to be created.

       2.      Choose Indexes.

       3.      In the subsequent dialog box, choose Create ® Create Extension Index.

       4.      Enter the required data (see Indexes).

       5.      Save and activate the extension index. Assign a package and a transport request for the extension index.

 

You can create an index as a table repair if this index is delivered in the next release of the SAP standard. In all other cases, you should create an extension index.