Skip to Content
0
Former Member
Nov 03, 2005 at 09:12 PM

capturing missing info. in dbtable vs internal table

21 Views

i have an internal table with few thousand entries depending on which i'm selection data from database table.

my internal table contains 'number' field.

im selecting data from database from db table as follows.

SELECT number field1 field2...FROM dbtable into....

for all entries in itab WHERE

NUMBER = ITAB-NUMBER.

this works fine. but i need to capture the 'numbers' that doen't exits in database. i dont want to open an SELECT...ENDSELECT or anyo ther loop. is there any other way to do this.

thanks,

kranthi.