topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 18 Oct 2007 08:40:12 GMT

please tell me how we can do this in the select query.

select matnr mtart from mara into itab_mara

where matnr = p_matnr

and mtart must be having some value. ie if it is not having any data in that field it should not fetch that record.

so please tell me how to code my above select statement.

I think we should not use like this.....

select matnr mtart from mara into itab_mara

where matnr = p_matnr

and mtart ne space. " it is not recommended i think

Re: select statement

Former Member — Thu, 18 Oct 2007 10:41:16 GMT

select matnr mtart from mara into itb_mara where matnr = p_matnr.

if itb-mtart is not initial.

delete itb_mara.

endif.

endselect.

u can use the above or the one u mentioned. It will suffice I think...

Re: select statement

Former Member — Thu, 18 Oct 2007 13:31:16 GMT

So long as the NE doesn't interfere with the index (and yours doesn't) you should be OK.

Rob

Re: select statement

Former Member — Thu, 18 Oct 2007 13:40:03 GMT

Hi Shiva,

try this.

select matnr mtart from mara into itb_mara where matnr = p_matnr and

mtart ne ' '.

Reward if useful.

Regards,

Chitra

Re: select statement

Former Member — Fri, 19 Oct 2007 07:20:52 GMT

select matnr mtart from mara into itab_mara

where matnr = p_matnr .

if itab_mara[] is not initial.

Loop at itab_mara.

if itab_mara-mtart is initial.

delete itab_mara.

endif.

endloop.

endif.

Re: select statement

Former Member — Sun, 21 Oct 2007 03:35:33 GMT

Hi Shiva,

Your Select statement should only bring back one record.

WHERE MATNR = P_MATNR.

I will assume that your p_matnr is a range table and that it should read

where matnr in p_matnr.

Generally, you want to avoid negatives in your WHERE clause, so in your case you can write it: AND MTART > SPACE.

Hope this helps.

Filler