what is the use of FOR ALL ENTRIES in an internal table?

Answer Posted / sriram

Actually It is used instead of inner join because when we want to join morn than 3 tables using inner join it will put a heavy load on the database server. instead of taking heavy load on DB server we will use for all entries ...
USED to retrieve the matched Records from the Different DB Tables..
Syntax :
select * from DBTABLE1 into table ITAB1
if itab1 is not initial
select * from DBTABLE2 into table itab2
where condition.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of secondary indexes?

540


What will exactly the hide statement do?

569


What is the difference between skip and reserve?

598


What are the different types of work process?

581


How can you access the function code from menu painter?

630






when u prefer lsmw?

617


What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr

540


What are advantages and disadvantages of logical data base

1751


What are the abap/4 commands that link to a layout set?

852


Where do you find info on new developments in SAP?

1560


What is the difference between a pool table and a transparent table and how they are stored at the database level?

576


what is diff between ECC 5.0 AND ECC 6.0

2848


What are different data types in abap/4?

550


What is the function module to popup contents in the internal table?

550


Do we create table fields with out data elements and domains?

622