Search help - Taking long time
We had a request to add a search help for Customer number in transactions FD02, FD03, VD02, VD03, XD02 and XD03. A search help to pull customer number depending on the Telephone number.
We have added a Elementary search help in Collective srch hlp DEBI.
We are joining KNA1 & KNVK tables. In KNVK we have TELF1 field.
and its working fine in all the transactions.
Now the problem is it is taking long time to bring back the Customer number when we input Telephone no.
Any suggestions will be greatly helpful.
Create a secondary index on TELF1 in table knvk.