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.