pls tell me how to include the wild card search for the below query
SELECT ASORTL AMCOD1 A~KUNNR INTO TABLE GT_CUSTOMER
FROM ( KNA1 AS A INNER JOIN KNVV AS B
ON AKUNNR = BKUNNR )
WHERE ASORTL IN SORTL AND BVKORG IN VKORG
AND APSTLZ IN PSTLZ AND AMCOD3 IN ORT01
AND A~MCOD1 IN NAME1
AND A~KUNNR IN KUNNR
AND B~VKORG NE ''.
the above data get populted as shown below.
IF CUSTOMER_FROM IS NOT INITIAL AND CUSTOMER_TO IS NOT INITIAL.
KUNNR-SIGN = 'I'.
KUNNR-OPTION = 'BT'.
KUNNR-LOW = CUSTOMER_FROM.
KUNNR-HIGH = CUSTOMER_TO.
APPEND KUNNR.
ELSEIF CUSTOMER_FROM IS NOT INITIAL.
KUNNR-SIGN = 'I'.
KUNNR-OPTION = 'EQ'.
KUNNR-LOW = CUSTOMER_FROM.
APPEND KUNNR.
ELSEIF CUSTOMER_TO IS NOT INITIAL.
KUNNR-SIGN = 'I'.
KUNNR-OPTION = 'EQ'.
KUNNR-LOW = CUSTOMER_TO.
APPEND KUNNR.
ENDIF.
IF CITY_FROM IS NOT INITIAL AND CITY_TO IS NOT INITIAL.
ORT01-SIGN = 'I'.
ORT01-OPTION = 'BT'.
ORT01-LOW = CITY_FROM.
ORT01-HIGH = CITY_TO.
APPEND ORT01.
ELSEIF CITY_FROM IS NOT INITIAL.
ORT01-SIGN = 'I'.
ORT01-OPTION = 'EQ'.
ORT01-LOW = CITY_FROM.
APPEND ORT01.
ELSEIF CITY_TO IS NOT INITIAL.
ORT01-SIGN = 'I'.
ORT01-OPTION = 'EQ'.
ORT01-LOW = CITY_TO.
APPEND ORT01.
ENDIF.
IF NAME IS NOT INITIAL.
NAME1-SIGN = 'I'.
NAME1-OPTION = 'EQ'.
NAME1-LOW = NAME.
APPEND NAME1.
ENDIF.