topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Wed, 03 Jan 2007 12:09:23 GMT

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

Re: inner join

former_member632991 — Wed, 03 Jan 2007 12:11:51 GMT

Hi,

it is not necessary, you can use the tables.

Regards,

Sonika Ahuja

Re: inner join

Former Member — Wed, 03 Jan 2007 12:17:12 GMT

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

*Please mark all the helpful answers

Re: inner join

Former Member — Wed, 03 Jan 2007 12:18:53 GMT

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;

Database views implement an inner join. The other view types implement an outer join.

Please refer the following link for more information,

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

Best Regards

Ali S

Re: inner join

Former Member — Wed, 03 Jan 2007 19:19:46 GMT

> But one point you should remember is;

> ]Database views implement an inner

> join. The other view types implement an outer

> join.

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

Re: inner join

Former Member — Thu, 04 Jan 2007 03:39:42 GMT

Some more info:

DB views: inner join

Maintenance views: Outer join

Help views: Outer join

Projection view: Only fields of one table