Application Development 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: 

Finding unmatched

Former Member
0 Kudos

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  

1 ACCEPTED SOLUTION

nabheetscn
Active Contributor
0 Kudos

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

3 REPLIES 3

nabheetscn
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Hi Mohan,

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

Regards,

Ankit