Difference between inner join and outer join in abap
Answer / >>>accenture>>&
Resulting set for inner join
The inner join joins the columns of every selected line on
the left- hand side with the columns of all lines on the
right-hand side that jointly fulfil the join_cond
condition. A line in the resulting set is created for every
such line on the right-hand side. The content of the column
on the left-hand side may be duplicated in this case. If
none of the lines on the right-hand side fulfils the
join_cond condition, no line is created in the resulting
set.
Resulting set for outer join
The outer join basically creates the same resulting set as
the inner join, with the difference that at least one line
is created in the resulting set for every selected line on
the left-hand side, even if no line on the right-hand side
fulfils the join_cond condition. The columns on the right-
hand side that do not fulfil the join_cond condition are
filled with null values.
Is This Answer Correct ? | 9 Yes | 9 No |
What is locking ?
looking for sap abap training with real time project, call @ 9972123004
1.The three ways in which we can write in top-of-page? 2.While creating function module what other things are created? 3.what is parameter id? 4.difference between synchronous and asynchronous methods? 5.Types of function modules? 6.conversion routine? 7.check table and value table difference? 8.text table? 9.types of cardinality 10.Whic is better joining or for all entries?
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
tell me some of FI/CO tables
Persistent class
After transferring of data from flat file to application server i found that it is showing wrong data .Say i had currency in flat file as 1000.00 USD. After transferring i found it is showing as 100.000 in the application server. How will you handle this case?
can you create a script with out a main window?
6 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc
which type of problems we generally face in reports and BDC in real time?
What is the difference between end-of-page and end-of- selection?
what is ment by buffering?