Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

delete

Former Member
0 Likes
527

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
507

Yes, it will work .

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

Regards,

Ravi

2 REPLIES 2
Read only

Former Member
0 Likes
508

Yes, it will work .

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

Regards,

Ravi

Read only

Former Member
0 Likes
507

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