Skip to Content
0
Former Member
Oct 18, 2007 at 08:40 AM

select statement

10 Views

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