inner join

[Former Member]

Hi it is necessary to use data base view for inner join?

[former_member632991]

Hi,

it is not necessary, you can use the tables.

Regards,

Sonika Ahuja

[Former Member]

No its not necessary to use database view for inner join.

For example:

select mkpf_{mblnr mkpf}mjahr mseg_{zeile mseg}bukrs mseg_{bwart MKPF}BUDAT MKPF_{CPUTM MSEG}MATNR MSEG_{WERKS MSEG}EBELN

MSEG_{EBELP MSEG}ERFMG

INTO TABLE ht_mkpfmseg

FROM MKPF INNER JOIN MSEG

ON mkpf_{mandt = mseg}mandt

AND MKPF_{MBLNR = MSEG}MBLNR

AND MKPF_{MJAHR = MSEG}MJAHR

where mkpf~budat > '20040721'.

I hope it helps.

Best Regards,

Vibha

<b>*Please mark all the helpful answers</b>

[Former Member]

Hi Padmam,

You can use views for joining. It is not mandatory that you should use views while joining.

But one point you should remember is;

<b><i>Database views</i> implement an <i>inner join</i>. The other view types implement an <i>outer join.</i></b>

Please refer the following link for more information,

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

<i><b>

Best Regards

Ali S</b></i>

[Former Member]

> But one point you should remember is;

> ]<i>Database views</i> implement an <i>inner

> join</i>. The other view types implement an <i>outer

> join.</i></b>

Just to be absolutely correct - there is a special view type "Projection View", where no join used at all

[Former Member]

Some more info:

DB views: inner join

Maintenance views: Outer join

Help views: Outer join

Projection view: Only fields of one table