topic Re: capturing missing info. in dbtable vs internal table in Application Development and Automation Discussions

capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:12:22 GMT

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.

Re: capturing missing info. in dbtable vs internal table

RichHeilman — Thu, 03 Nov 2005 21:16:34 GMT

You could probably use a subquery here. You would add this subquery to the first select statement, the one that fill ITAB.

http://help.sap.com/saphelp_46c/helpdata/en/dc/dc7614099b11d295320000e8353423/frameset.htm

Regards,

Rich Heilman

Re: capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:19:58 GMT

Hi kranthi,

Probably you can populate those numbers into a range as a exluding(Not include) option and do the select using IN option

Cheers,

Satya

Re: capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:26:14 GMT

Do you mean that you want to know the numbers that are in your file that are not in the database?

Rob

Re: capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:41:41 GMT

Rob,

yes,with out querying on the db(another time apart from fetching data ) and with out a loop or select..endselect.

Thanks,

kranthi.

Re: capturing missing info. in dbtable vs internal table

former_member10945 — Thu, 03 Nov 2005 21:44:00 GMT

Delete the internal table where the numbers field is in the dataset returned by your select statement.

Re: capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:48:00 GMT

Hi, you can try this.

loop at itab.

r_number-sign = 'E'.

r_number-option = 'EQ'.

r_number-low = itab-number.

append r_number.

endloop.

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

WHERE

NUMBER in R_NUMBER.

Since we use exluding option it will fetch only those are not in the r_number.

Cheers,

Satya

Re: capturing missing info. in dbtable vs internal table

Former Member — Thu, 03 Nov 2005 21:54:55 GMT

Copy the table that was returned from the database select to another table (itab2[] = itab1[]).

Sorry - I meant say - copy the original table used in the where clause to another internal table. **

loop at the original table and create a range table from it (using 'I' and 'EQ'). I think you do have to use a loop here.

and use the table returned from the select in the range.**

delete itab2 where not number in range table.

delete itab2 where number in range table **

Rob

Message was edited by: Rob Burbank