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.