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?
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
What is client in the sap system? : sap abap hr
On which even we can validate the input fields in module progams?
Difference between transparent tables and pooled tables? : abap hr
How to call transaction in session method without recording?
What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?
Is there any method apart from bdc for data upload to sap? : abap bdc
Static and instance variable and method with live example. Why and when to use
How to debug a script in abap?
B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.
What is the differrences between structure and table in data dictionary in abap? : abap hr
what is difference between set screen and call screen ?
What are the differences between domain and data element?
What is new enhancement framework?
What is the use of table maintenance allowed?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?