i have written one sql query. In tis query iwe written some condition. but we are getting the output only for 261 movement .
but i need the output both '201' or '261' movement type .
Plz check my query and tell me the solution.
IF DAYS IS NOT INITIAL.
WB2_V_MKPF_MSEG2-BUDAT = SY-DATUM - DAYS.
SELECT MATNR_I WERKS_I BWART_I BUDAT FROM WB2_V_MKPF_MSEG2 INTO CORRESPONDING FIELDS OF TABLE T_ITAB4
WHERE WERKS_I IN PLANT AND BWART_I IN ('201' , '261') AND BUDAT BETWEEN WB2_V_MKPF_MSEG2-BUDAT AND SY-DATUM.