How to Create Secondary Index on SAP Table?

To create a secondary index on SAP table, display the table in ABAP dictionary (SE11).

secondary-index-1

We shall create a secondary index on non-key field  i.e. Name. Click on “Indexes” button on application toolbar.

secondary-index-2

Select Yes in the popup window.

secondary-index-3

Enter index name and press continue.

secondary-index-4

Enter description for the index and index fields i.e. MANDT and NAME. Do not forget to enter MANDT as the first index field if it is a client dependent table. Save and activate the index.


2 Comments

  1. we have to activate and adjust the database after creation of this index.
    to do this goto -> utilites->active and adjust database. which is nothing but se14(db utility )

Leave a Reply

Your email address will not be published.


*