Skip to Content
0
Former Member
Nov 06, 2012 at 04:04 AM

Advice on creating secondary index on custom table

205 Views

Hi Experts,

I have created a custom table to store data of a custom web application and wanted to know if on what fields should i create secondary index on ?

I am thinking to create 3 separate index on text1 , text2 and text3.

Please suggest.

The table has key field as order no. which is generated using custom number range.

On my screen i am giving user option to search based on following fields:

Order created by

created on

status of order

order text 1 (60 char )

order text 2 (60 char )

order text3 (60 char )

and user can use any of the above fields to search.

My selection works as follows:

First select :

if order text1 is not initial.

created by

created on

status (domain values maintained)

order text1

into itab

endif.

if order text2 is not initial.

appending to itab

endif.

if order text3 is not initial

appending to itab

endif.