Search help - Taking long time

[Former Member]

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.

[Former Member]

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

[Former Member]

Create a secondary index on TELF1 in table knvk.

Thanks,

Vamshi

[Former Member]

Hi Vamshi,

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

Thank you.