topic Re: delete records in Application Development and Automation Discussions

delete records

Former Member — Tue, 19 Feb 2008 09:20:06 GMT

i have a report with some fields..

i want to delete the records where few fields are coming with zero values,,,

how can i remove the entire record where the field has zero values

Re: delete records

Former Member — Tue, 19 Feb 2008 09:23:32 GMT

Hello Swetha,

If the records are availble in an internal table. YOu can delete the records based upon the condition before displaying.

Do like this:


  DELETE IT_TC01 WHERE WTG001 LE 0
                   AND MEG001 LE 0.
" Here from the table IT_TC01 records will be deleted will WTG001 or MEG001 is initial.

Hope this will solve ur issue.

Cheers,

Vasanth

Re: delete records

Former Member — Tue, 19 Feb 2008 09:24:09 GMT

Hi,

Using the statement DELETE.

DELETE itab WHERE <Logical expression>.

Rgds,

Bujji

Re: delete records

Former Member — Tue, 19 Feb 2008 09:24:48 GMT

Hi,

Try this...

Delete itab where f1 = 0 and f2 = 0 and f3 = 0.

or..

Loop at itab into istab.

if f1 = 0 and f2 = 0 and f3 = 0.

istab-flag = 'X'.

modify itab from istab index sy-tabix transporting flag.

endif.

delete itab where flag = 'X'.

Regards....

Re: delete records

vinod_vemuru2 — Tue, 19 Feb 2008 09:26:09 GMT

Hi,

Suppose ur internal table has 10 fields and u want to delete all the records for which either field1 or field2 is zero, Then do like this.

SORT itab BY field1 field2.

DELETE itab WHERE field1 EQ 0

OR field2 EQ 0.

If u want to delete only if both the fields are 0 then just give AND instead of OR.

SORT itab BY field1 field2.

DELETE itab WHERE field1 EQ 0

AND field2 EQ 0.

Thanks,

Vinod.