topic Re: Search help - Taking long time in Application Development and Automation Discussions

Search help - Taking long time

Former Member — Thu, 04 May 2006 21:15:20 GMT

Hi,

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.

Thanks.

Re: Search help - Taking long time

Former Member — Thu, 04 May 2006 21:47:08 GMT

In the IMG (transaction SPRO):


Financial Accounting
->Accounts receivable and Accounts payable
  ->Customer Accounts
    ->Master Records
      ->Matchcodes

There are two items. Check the documentation on them.

Rob

Re: Search help - Taking long time

Former Member — Thu, 04 May 2006 21:53:05 GMT

Create a secondary index on TELF1 in table knvk.

Thanks,

Vamshi

Re: Search help - Taking long time

Former Member — Mon, 08 May 2006 16:09:47 GMT

Hi Vamshi,

your suggestion worked. we have created Secondary Index on TELF1 in KNVK table.

Thank you.