topic Re: delete in Application Development and Automation Discussions

delete

Former Member — Tue, 12 Jun 2007 01:20:38 GMT

Hi all,

may i know if this delete statement can delete the records in table

where the processed = 'X'?

let say 4 records where processed = 'X', can 4 records be deleted with this statement instead of using loop.

DATA: it_report TYPE STANDARD TABLE OF linex,

wa_report TYPE linex. " Working area

DELETE it_report WHERE processed = 'X'.

thanks

Former Member — Tue, 12 Jun 2007 01:22:53 GMT

Yes, it will work .

DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.

Regards,

Ravi

Former Member — Tue, 12 Jun 2007 01:24:51 GMT

you need to specify like this :

i have one internal table

data i_makt like makt occurs 0 with header line.

start-of-selection.

select * from makt into table i_makt

where condition.

delete makt from <b>table i_makt</b> where cond.

Message was edited by:

Seshu Maramreddy