SAPHub

How to Create Secondary Index on SAP Table?

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

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

Select Yes in the popup window.

Enter index name and press continue.

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.