topic Inner join Vs Outer join with ABAP code...? in Application Development and Automation Discussions

Inner join Vs Outer join with ABAP code...?

Former Member — Fri, 04 May 2007 12:24:59 GMT

Inner join Vs Outer join with ABAP code...?

Re: Inner join Vs Outer join with ABAP code...?

Former Member — Fri, 04 May 2007 12:33:04 GMT

Inner Join means, it will not select that recor at all, unless there is a matching entry in the second table.

suppose table VBAK INNER join table VBAP on VBAK_{VBELN = VBAP}VBELN.

In this case, if there are no entries in VBAP, the header entry also will not show up.

But in case of OUTER JOIN, even if there is no items, it will show the header entry(VBAK) with blank columns for fields from item table.(VBAP)

here is one sample for inner join.

SELECT A~EBELN

A~EKORG

A~EKGRP

A~BSART

A~LPONR

A~LOEKZ

A~LIFNR

A~RESWK

B~AEDAT

B~WERKS

B~MATNR

B~MENGE

B~EBELP

B~ELIKZ

B~PLIFZ

B~PSTYP

B~KNTTP

B~MATKL

B~ZZD_PLANT

FROM EKKO AS A INNER JOIN EKPO AS B

A_{EBELN = B}EBELN

INTO CORRESPONDING FIELDS OF TABLE T_DATA

FOR ALL ENTRIES IN T_EKET

WHERE

A~EBELN EQ T_EKET-EBELN AND

A~BSART EQ C_UBSTO AND

A~EKORG IN S_EKORG AND

A~EKGRP IN S_EKGRP AND

A~BSTYP EQ C_BSTYP AND

A~LOEKZ EQ SPACE AND " Order not deleted

A~RESWK IN S_RESWK AND

B~EBELN EQ T_EKET-EBELN AND

B~EBELP EQ T_EKET-EBELP AND

B~WERKS IN S_WERKS AND

B~MATNR IN S_MATNR AND

B~MATKL IN S_MATKL AND

B~LOEKZ EQ SPACE. " Line item not deleted

Re: Inner join Vs Outer join with ABAP code...?

Former Member — Fri, 04 May 2007 14:18:37 GMT

Hi,

Go through the link,

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm

Regards,

Azaz Ali.

Re: Inner join Vs Outer join with ABAP code...?

Former Member — Mon, 07 May 2007 05:16:25 GMT

Check this if is helpful.

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.

INNER JOIN

With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view.

OUTER JOIN

With an outer join, records are also selected for which there is no entry in some of the tables used in the view.

Regards

Dinesh