topic select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 16 Jan 2008 12:11:46 GMT

hi

my requirement is i have to exculde the Z2 and Z5 in mstae field. is the follwing select query is correct,

please tell me how to use mstae ne z2 and z5 in one statement insted of using in following manner.

select matnr

mstae

from mara

into table gt_mara

where matnr EQ ms_matnr

and mstae ne 'Z2'

and mstae ne 'z5'.

Re: select statement

Former Member — Wed, 16 Jan 2008 12:15:56 GMT

avoid using negative selects for performance reasons....

so proceed this way....

select matnr

mstae

from mara

into table gt_mara

where matnr EQ ms_matnr.

if sy-subrc = 0.

delete gt_mara where mstae = 'Z2' or mstae = 'Z5'.

endif.

Regards

Vasu

Re: select statement

piyush_mathur — Wed, 16 Jan 2008 12:17:42 GMT

HI Hemal.

Please refer below piece of code

select matnr

mstae

from mara

into table gt_mara

where matnr EQ ms_matnr

and mstae not in ( 'Z2', 'z5').

Piyush

Reward points, if helpfull