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
Explain what is sap script? What is the purpose of sap script?
How can we use multiple transactions by using bdc_insert? : abap bdc
What are the data classes in abap?
How you attach search help to data element? : sap abap data dictionary
What are logical databases?
What is the length of function code at user-command?
What is the difference between a substructure and an append structure? : abap data dictionary
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?
Did you create any joins?
How to call other programs?
How many main windows will be there in a page window?
Explain the client concept of sap.
Can a domain, assigned to a data element be changed? : abap data dictionary
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What is dialog module?