topic Re: Compare two tables to delete specific rows in Application Development and Automation Discussions

Compare two tables to delete specific rows

former_member656551 — Wed, 13 Jul 2022 09:32:09 GMT

Hello experts,

i want to delete rows from a z table when it matches rows from an internal table at a speficic row count.

so basicallly this

"delete from ztab where ztab-column = itab[ row_count ]-column."

exept it doesn't work.

If that makes any sense.

Thank you.

venkateswaran_k — Wed, 13 Jul 2022 09:55:48 GMT

LOOP AT itab into wa_itab.
DELETE FROM ZTAB WHERE COL1 = WA_ITAB-COL1.
ENDLOOP.

Sandra_Rossi — Thu, 14 Jul 2022 07:16:22 GMT

data(column) = itab[ row_count ]-column.
delete from ztab where column = column.

or with Host Expression (rewritten as minimal reproducible example):

DATA itab TYPE TABLE OF sflight.
DATA(row_count) = 1.
DELETE FROM sflight WHERE carrid = @( itab[ row_count ]-carrid ).