Skip to Content
0
Former Member
Jun 26, 2009 at 07:34 AM

Wild card character search in the select query of inner join

203 Views

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.