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
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
What are pool tables?
While sorting field groups we cannot use more than one key field. State true or false. : abap modularization
What is an rdbms?
Does sap handle multiple currencies?
Lock objects and what are parameters of ENQUEUE FM?
what will happen if called program is not executable ?
What do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary
What is an internal table?
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
what are the important fields while preparing sales order,inquiry?
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
Can a domain, assigned to a data element be changed? : abap data dictionary
What is generic area buffering in abap?
Where the payroll results are stored