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 subroutines? : abap modularization

628


How to eliminate duplicate entries in internal tables?

681


How do you process errors in session method ? : abap bdc

587


What are the basic objects of the data dictionary?

572


What is the use of lock objects?

575






What functions does a data dictionary perform ?

565


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

877


What is a transport?

626


What is an on”*-input filed” statement?

605


What is logo in sap script?

572


Can we define our own match code id's for sap matchcodes ?

592


Explain what are the different functions used in sap script?

550


How we format the data before writing a statement in the report?

512


In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr

569


What are the list of screen elements?

530