Search results SE16n(KNA1) different from search results XD03

[Former Member]

Dear

I am having the problem that when searching for a certain customer via XD03, I get different results than when I use the exact same search term in SE16n using table KNA1.

Concrete:

There are 16 customers in customer with the word "BOURGOGNE" in their name.

1) Searching for the name *BOURGOGNE* via SE16n (Table KNA1, field NAME1) returns 16 results.

==> Correct

2) Searching for the name *BOURGOGNE* via the search function in XD03 returns 6 results.

==> For no apparent reason, several customers are left out

3) Searching for the name *BOURGO* via the search function in XD03 returns 15 results.

==> Even weirder, when using a less specific search term. The search returns more results but still not all customers. (one missing)

Questions:

1) Is this something, one of you have already encountered?

2) How does the search function in XD03 operate? Does it use table KNA1? Does it use different table(s)? Are there search settings which could explain this behavior?

Thanks for your help.

Kind regards

Floris

[former_member223981]

Hi Floris,

I checked this on my system. The only place I could see a search field for "Name" in XD03 was in the "Customers by address attributes" tab. In here, the system is searching from table ADRC (Addresses (Business Address Services)). Technically, this happens at the following code:

Function ADDR_SEARCH_V2

************************************

  IF up_to_rows IS INITIAL.                                 "*408i

    SELECT * FROM adrc INTO TABLE xadrc WHERE (l_where_clause).

  ELSE.                                                     "*408i

    SELECT * FROM adrc UP TO up_to_rows ROWS                "*408i

                       INTO TABLE xadrc WHERE (l_where_clause)."*408i

  ENDIF.                                                    "*408i

************************************

So I guess you should check table ADRC and see if only 6 entries show up. If only 6 entries show up, then I think this means you have not maintained an address for all the entries in KNA1.

Hope this helps.