CONCEPTS OF INNER JOIN AND OUTER JOIN in SAP ABAP

-

CONCEPTS OF INNER JOIN AND OUTER JOIN:

I want to get the data from multiple tables than we have to go for joins. There are 2 types of joins available in SAP. 
They are…
1. Inner join.
2. Left outer join.

 It is very important to remember that whenever we want to join the tables it is mandatory that there should be at least one common field between them. Without a common field between the tables we can not join the tables. For taking the common field you should not consider MANDT field. So common field may be primary key field / other field.

 INNER JOIN - This is exactly like intersection / logical AND operator. Also this inner join will fetch the data from the tables if the record is available in all the tables that you are joining. So if it is not available in one of the tables, the data will not be fetched.

 LEFT OUTER JOIN : This is like union. But it is not exactly like union. Whenever left outer join is used in select query, it will fetch all the records from left side table & the common records from right side table.

So Inner join between table 1 & table 2, where column D in both tables in the join condition is set the same:

 Table 1:                         Table 2
 

                            \ /
                            \ /
                            \ /
                            \ /
Inner Join:
2. Left outer join between table 1 & table 2 where column D in both tables set the join condition:

      Table 1:                   Table 2:


                          \ /
                          \ /
                          \ /

 Left Outer Join:


Comments

Post a Comment

If you have any doubts let me know

Popular posts from this blog

EVENTS IN INTERACTIVE REPORTS OF SAP ABAP

-
INTERACTIVE REPORT AND ITS EVENTS: INTERACTIVE REPORT :  A report which can generate one basic & up to 20  interactive lists is called an interactive report. So first list is called basic list & next lists are called interactive lists. EVENTS IN INTERACTIVE REPORTS: 1. INITIALIZATION. 2. AT SELECTION-SCREEN. a. AT SELECTION-SCREEN ON <FIELD>. b. AT SELECTION-SCREEN OUTPUT. c. AT SELECTION-SCREEN ON VALUE-REQUEST FOR <FIELD>. 3. START-OF-SELECTION. 4. TOP-OF-PAGE. 5. END-OF-PAGE. 6. AT LINE-SELECTION. 7. AT USER-COMMAND. 8. TOP-OF-PAGE DURING LINE-SELECTION. INITIALIZATION  : It is the first event to be triggered. Also this event is triggered before  the selection screen is displayed. So this event is used to give default vales to selection screen  fields. AT SELECTION-SCREEN  : This event is triggered after giving input in selection screen  fields. So this event is used to handle the user actions on the sc...
Read more

Differences Between Classic & New BAdIs :

-
  Differences Between Classic & New BAdIs  : Classic & new BAdIs differ in a number of features that are important for migration : 1).BAdI object :     a). With classic BAdIs, a BAdI object is created by calling a factory method & referenced via a reference variable of the type of the BAdI interface.     b). With new BAdIs, a BAdI object is created via the ABAP statement  GET BADI  as a handle for the calls of BAdI methods & referenced via a reference variable of the type of the BAdI.So a BAdI object is an instance of an internal BAdI class which otherwise is invisible to the outside. 2).Passing comparison values for the filter :      a). With the classical BAdIs, the filter values are stored in a structure & passed with the call of the BAdI methods.      b). With the new BAdIs comparison values for the filters used to search for implementation are passed...
Read more

MAIN DIFFERENCE BETWEEN EXECUTABLE PROGRAM AND MODULE POOL PROGRAM in SAP ABAP :

-
MAIN DIFFERENCE BETWEEN EXECUTABLE/REPORT PROGRAM AND DIALOG/MODULE POOL PROGRAM : 1).Report or Executable programs: A report is a program that typically reads & analyses data in database tables without changing the database. 2).Dialog/Module pool programs: If your ABAP program demands a user input, dialog programming is used. User dialog is any form of interaction between the user & the program and could be any of the following such as entering the data, choosing a menu item, clicking or double clicking the entry. EXECUTABLE/REPORT PROGRAM MODULE-POOL /DIALOG PROGRAM 1).Executable program contain only two screen that is input as Selection screen and output as list.   1).Module pool programs contain many screen that are logically linked together. 2). Reports are standalone programs [that is we don't need to link our program to any screen or any transaction code]. 2).Module pool programs  are not standalone programs [that ...
Read more