topic Re: Finding unmatched in Application Development and Automation Discussions

Finding unmatched

Former Member — Mon, 16 Dec 2013 12:28:57 GMT

Hi All

My requirment is I have an internal table with 8 records and custom database table with 13 records.All the 8 internal table records are also present in database table.I need to delete remaining 5 unmatched records in datbase table.How to proceed?

Thanks

Vamsi

Re: Finding unmatched

nabheetscn — Mon, 16 Dec 2013 12:52:22 GMT

simply fetch data from database table in LT_DATABASE

For each record in LT_DATABASE do a read on your internal table if found delete it from LT_DATABASE.

In the end you will get records to delete

Re: Finding unmatched

naveen_inuganti2 — Mon, 16 Dec 2013 12:53:20 GMT

Select your db table data to one internal table(ITAB2) and while doing that apply filter (NOT IN) based on your internal table data.

Then,

DELETE DB TABLE FROM TABLE ITAB2.

Regards,

Naveen

Re: Finding unmatched

Former Member — Mon, 16 Dec 2013 13:06:57 GMT

Hi Mohan,

Collect ur data into internal table then check which is not there just delete that record..

Regards,

Ankit