Skip to Content
0
Former Member
Nov 14, 2005 at 10:46 PM

Search program

25 Views

Hello All,

I have written a new ALV GRID program to search the vendor by name from PAYR table. It can search based on the title or name1 or name2 or name3 or name4 fields of the table. But it is not retrieving some entries. For example if I give the search “VICTOR” it is missing the entry with “VICTOR WILLIAMS”. But it retrieved an entry with

“VICTOR COMPEAN”. I am not sure why it is behaving like this. It displays the final list in ALV GRID FORMAT.

My piece of code:

DATA:

i_src like table of wa_src,

l_str1(20) type C.

PARAMETERS: l_string(20) type C.

START-OF-SELECTION.

concatenate '%' l_string '%' into l_str1.

Select * from PAYR INTO table I_src where

ZANRE LIKE l_str1 OR

ZNME1 LIKE l_str1 OR

ZNME2 LIKE l_str1 OR

ZNME3 LIKE l_str1 OR

ZNME4 LIKE l_str1.

call screen '0100'.

Thanks for the great help,

Sobhan.