what are Joins? How many types are there?
Answer Posted / sudhakar1207
Joins are used to extract data from more than one DB table
which are logically related to each other.
So in order to join DB Tables they should have a common
field or attribute.
In ABAP, We have two types of Joins.
1) Inner Joins
2) Outer Joins ( Left Outer and Right Outer)
Inner Joins retrieve the records which matched with join
condition only.
While outer joins Retrieve the records which are matched
with Join Condition and Remaining records from the Parent Table.
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
Can a constructor be declared private? If yes then in which scenario?
What is the relationship existing between the various data elements? : abap data dictionary
What is the length of function code at user-command?
What is database view ? : sap abap data dictionary
Event handling in oops
In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?
What is open sql?
What are the functional areas? User groups? And how does abap/4 query work in relation to these?
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?
What is an “on request field” statement?
What are the two levels in defining a match code ?
What is roles and responsibilities of sap hr consultants? : sap abap hr