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 differences between primary and secondary indexes?

623


How are BAPI different from normal function modules?

1728


What are the other modules integrated with om? : sap abap hr

550


What is the tcode for sapscript forms?

662


Explain the different types of mode (run code) in call transaction method?

576






What do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary

559


What are ranges?

600


What is the difference between the exits created in M.M and S&D?

1624


Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.

1978


What is the major difference between pool tables and transparent tables?

523


How to define selection screen?

604


I need some information regarding Vcentric Test pattern ? with questions.

1696


how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

3423


State the system field for the current date?

641


What abap statement will trigger list generation?

629