‎2007 Jun 12 2:20 AM
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
‎2007 Jun 12 2:22 AM
Yes, it will work .
DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.
Regards,
Ravi
‎2007 Jun 12 2:22 AM
Yes, it will work .
DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.
Regards,
Ravi
‎2007 Jun 12 2:24 AM
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