which of the following is more efficient when we are
retrieving data from more tables.
select statement using innerjoins or select statement using
for all entries?
- 9 Answers
- 10615 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prats
For Key Field Inner Join is most appropriate if all keys
are matched. For example: EKKO-EKPO based on EBELN. It
reduces the network traffic for selecting data from both
the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?
how do you transport lsmw data from one system to another?
How memory management happens for internal tables and work areas in abap?
How to debug a sapscript?
What is is a match code? : abap data dictionary
wat are the process that can be executed & tracked in a workflow?
what is the difference between Blocked ALV and interactive ALV?
Concepts of OO ABAP and why we are using it?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
What are the different kinds of lock modes?
What is the BAPI_CUSTMATINFO_GETDETAILM used for? what is the input and output of this bapi.
Explain different types of attributes of function module?
Which type of tables used this buffer?
What is help view?
What is a collect statement?
