FOR ALL ENTRIES

[Former Member]

What are the prerequisites to be checked before we apply 'for all entries concept'?

[Former Member]

Hi,

When ur using the for all entries we can follow the two conditions.

1. Sort the driver table

2. Check the driver table is empty or not.

Thanks,

Anitha

[Former Member]

for which table you are using for all entries that should not be empty.

suppose imara contain matnr field. now i am fetching the data into imarc for all entries in imara.

if not imara[] is initial.

select matnr werks into table imarc from marc for all entries in imara where matnr = imara-matnr.

endif.

regards

shiba dutta

[Former Member]

Hi Raju,

Check ths link,

https://forums.sdn.sap.com/click.jspa?searchID=2941917&messageID=3464879

Thanks.

[Former Member]

hi,

for which table you are using for all entries that should not be empty.

if helpful reward some points.

with regards,

suresh.

[Former Member]

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.

Reward points if it is helpful.

Regards,

Sangeetha.a

[Former Member]

hi

good

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.

thanks

mrutyun^

[Former Member]

hi mrutyunjaya,

thanks for the answer.

regards

raju