Skip to Content
0
Former Member
Nov 03, 2009 at 06:22 AM

Regarding sql query

16 Views

Hi Guriji,s

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.

ENDIF.

Thanks