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.