topic Doubt in select statement in Application Development and Automation Discussions

Doubt in select statement

Former Member — Sat, 04 Aug 2007 14:32:08 GMT

hi guys ,

i am writing a select statement like

select ebeln into fp_records from eket for all entries in fpi_getrecords where

(menge - wemng) gt 0.

how to subtract two fields in the where condition.

Re: Doubt in select statement

Former Member — Sat, 04 Aug 2007 14:40:33 GMT

Hi,

You cannot use this kind of natation in the select statement.

Rather

select ebeln menge wemng into fp_records from eket for all entries in fpi_getrecrods where condition.

if sy-subrc eq 0.

loop at fp_records.

if fp_records-menge - fp_records-wemng le 0.

delete fp_records index sy-tabix.

endif.

endloop.

endif.

Thanks,

mahesh

Re: Doubt in select statement

former_member189059 — Mon, 06 Aug 2007 04:58:48 GMT

make a workarea

data: fp_records_wa like line of fp_records.

select ebeln menge wemng from eket into corresponding fields of fp_records_wa for all entries in fpi_getrecords.

if fp_records_wa-menge - fp_records_wa-wemng gt 0.
 append fp_records_wa to fp_records.
endif.

endselect.