internal tables

Former Member — Thu, 14 Jun 2007 08:52:24 GMT

what is the use of select for all entries in an internal

table?

Re: internal tables

Former Member — Thu, 14 Jun 2007 09:01:57 GMT

good

Outer join can be created using this addition to the where clause in a select statement. It speeds up the performance tremendously, but the cons of using this variation are listed below

Duplicates are automatically removed from the resulting data set. Hence care should be taken that the unique key of the detail line items should be given in the select statement.

If the table on which the For All Entries IN clause is based is empty, all rows are selected into the destination table. Hence it is advisable to check before-hand that the first table is not empty.

If the table on which the For All Entries IN clause is based is very large, the performance will go down instead of improving. Hence attempt should be made to keep the table size to a moderate level.

Not Recommended

Loop at int_cntry.

Select single * from zfligh into int_fligh

where cntry = int_cntry-cntry.

Append int_fligh.

Endloop.

Recommended

Select * from zfligh appending table int_fligh

For all entries in int_cntry

Where cntry = int_cntry-cntry.

thanks

mrutyun^

Re: internal tables

Former Member — Thu, 14 Jun 2007 09:20:15 GMT

it's very good example i think. ^^

Re: internal tables

Former Member — Fri, 15 Jun 2007 10:13:05 GMT

To all gurus helping me out. As iam new to this field.

Thanks&Regards

Suri

topic internal tables in Application Development and Automation Discussions

internal tables

Re: internal tables

Re: internal tables

Re: internal tables