Skip to Content
0
Former Member
May 14, 2010 at 01:38 AM

Select with too many where conditions not working fine....equal to and not

174 Views

Hi Everyone,

I am getting rows into internal table lt_mseg even if this where condition like this werks NE gs_t001w-werks in below code

is true. It looks like it's not excluding if not equal to gs_t001w-werks. Is anything wrong in below code? please help me...

SELECT * INTO TABLE gt_t005 FROM t005 WHERE xegld = 'X'.

SELECT * FROM t001w INTO TABLE gt_t001w FOR ALL ENTRIES IN gt_t005

WHERE ( land1 = gt_t005-land1 OR land1 = 'NO' ) AND vkorg NE 'LDE'.

SELECT * FROM mkpf INTO TABLE gt_mkpf

WHERE budat IN p_oextdt AND vgart = 'WL'.

LOOP AT gt_mkpf INTO gs_mkpf.

  • CHECK gt_t001w[] IS NOT INITIAL.

SELECT * FROM mseg APPENDING TABLE lt_mseg

FOR ALL ENTRIES IN gt_t001w

WHERE mblnr = gs_mkpf-mblnr

AND mjahr = gs_mkpf-mjahr

AND bwart NE '641'

AND xauto = ' '

AND werks NE gs_t001w-werks

AND kunnr = gt_t001w-kunnr.

ENDLOOP.