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: 

hi Prerequestion of using for all entries

Former Member
0 Kudos

Hi ,

What is the prerequestion of using For All Entries. Could you answer to me.

Thanks & Regards

Raghava

1 ACCEPTED SOLUTION

Simha_
Employee
Employee
0 Kudos

Hi,

1. First check that first Int Table(ITAB) is not Initial.

2. Select all the Key fields of the Table from which you are fetching data(DB Table).

3. Use for all entries.. and equate the key/same fields in both tables:

If not ITAB[] is initial.

Select f1 f2... from <DB Tabale>

into (int table) for all entries in ITAB

where f1 = <f1> and F2 = <f2>.

endif.

Cheers,

Simha.

3 REPLIES 3

Simha_
Employee
Employee
0 Kudos

Hi,

1. First check that first Int Table(ITAB) is not Initial.

2. Select all the Key fields of the Table from which you are fetching data(DB Table).

3. Use for all entries.. and equate the key/same fields in both tables:

If not ITAB[] is initial.

Select f1 f2... from <DB Tabale>

into (int table) for all entries in ITAB

where f1 = <f1> and F2 = <f2>.

endif.

Cheers,

Simha.

Former Member
0 Kudos

hi,

one more is prerequestion of using the STANDARD INTERNAL TABLE, HASHED , SORTED INTERNAL TABLES.

Please give the answer

Thanks

Raghava

Former Member
0 Kudos

Hi,

1.First check whether the internal table which to be used in FOR ALL ENTRIES is initial or not.IF it is not initial ,then use the table.Otherwise it will go for an infinite loop.

2.Sort the internal table.

Go through this

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.

Regards,

Padmam.