topic Re: Regarding sql query in Application Development and Automation Discussions

Regarding sql query

Former Member — Tue, 03 Nov 2009 06:22:47 GMT

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

Re: Regarding sql query

Former Member — Tue, 03 Nov 2009 06:27:18 GMT

Hi Sachin,

Just check whether all rest of the conditions are satisfying for Movement type '201'.

Because all the Where conditions are with 'AND' so all the conditions should be satisfied together.

Regards,

Nitin.

Re: Regarding sql query

former_member222860 — Tue, 03 Nov 2009 06:32:35 GMT

Check in SE16, if you have data for the given condition of the SELECT statement

Re: Regarding sql query

raviprakash — Tue, 03 Nov 2009 06:42:15 GMT

Your Query:-

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.

Do following check:-

In se11, open table WB2_V_MKPF_MSEG2, in BWART_I provide 201 and 261. Check whether your imput for plant and budat is same or not.

Re: Regarding sql query

Former Member — Tue, 03 Nov 2009 06:57:23 GMT

Hi,

Your query for movement types is correct.

Other where conditions are not getting satisfied.Just remove other where conditions and check if its working fine only for movement types where conditions.It will work fine.

Regards,

Subhashini