Finding unmatched

[Former Member]

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  

[nabheetscn]

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

[naveen_inuganti2]

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

[Former Member]

Hi Mohan,

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

Regards,

Ankit