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

How do you take care of performance issues in your ABAP programs?

873


hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

2735


What are the classifications of the sap abap data classes?

832


What is the difference between abap and hr abap? : abap hr

828


What is ps structure? : abap hr

1020


Polymorphism real time scenario

1209


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?

1126


Why is pretty printer user in abap?

862


any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?

2239


What are the steps in creating screen ?

1729


What are the types of windows in sap script?

811


What are the check tables?

754


what is the t-code to link technical and functional operation?

2171


Can we access static attribute from instance method

1209


Workbench request are client dependent or client independent

770