topic Re: Delete data from 1st table based on the 2nd table in Application Development and Automation Discussions

Delete data from 1st table based on the 2nd table

Former Member — Mon, 21 Dec 2009 14:12:40 GMT

Hi experts,

I have a requirement in which I need to delete the data of 1st table based on the data from the 2nd table.

Its like:

1st internal table has the following entries:

GT_T001W

MTES

Z001

Z002

Z003

Z004

Z005

ZREF

ZTST

2nd internal table has the following entries:

Gt_mard

14 M004 000000000000276001 1000 9987.990

15 M002 000000000000276003 1000 6.000

16 M004 000000000000276003 1000 3.600

17 Z003 000000009800000635 1001 100.000-

Now I want that in GT_MARD, all the entries except the common one (Z003) should be deleted.

How do I do this?

Thanks,

Ajay.

Former Member — Mon, 21 Dec 2009 14:16:05 GMT

Loop at GT_T001W .

Read table Gt_mard with key MTES = gt_t001w-mtes.

If sy-subrc = 0.

delete gt_mard index sy-tabix.

endif.

Endloop.

Try this .. this will work.

Regards,

Raghu.

Former Member — Wed, 03 Mar 2010 17:49:17 GMT

The above code will not work properly.

Your check for subrc is ok But if it is true, then it deletes the entries which is common to both the tables which is not the requirement.

PLease clarify

Jerry