select where condition

[Madhusudhan_MV]

SELECT * FROM /scwm/huhdr INTO TABLE (lt_tab) WHERE lgnum = _lgnum.
LOOP AT lt_tab INTO DATA(ls_tab).
  IF ls_tab-hu_guid_ext <> ls_tab-guid_hu_top.
    WRITE: ls_tab-huident.
  ENDIF.
ENDLOOP.

Hi friends,

Can I add IF ls_tab-hu_guid_ext <> ls_tab-guid_hu_top ( which is in the loop ) in select where condition ?

Thanks,

Madhu M V

[Dominik_Tylczynski · Accepted solution]

Hello @Madhusudhan_MV 

Here the select statement you can use:

SELECT * FROM /scwm/huhdr INTO TABLE @DATA(lt_tab)
  WHERE lgnum = @pa_lgnum
  AND hu_guid_ext <> /scwm/huhdr~guid_hu_top.

Best regards

Dominik Tylczynski

[Madhusudhan_MV · Accepted solution]

Thanks Dominik