topic Re: Inner join in Application Development and Automation Discussions

Inner join

Former Member — Tue, 08 May 2007 07:29:25 GMT

I need to join MARA and MSEG as inner join on mara-matnr = mseg-matnr.

However matnr is not a key field in mseg.The query is shown below.

from mkpf AS a

inner join mseg as b

on a_{mandt = b}mandt

and a_{mblnr = b}mblnr

and a_{mjahr = b}mjahr

inner join mara as c

on c_{matnr = b}matnr

Is this query alright, specially c_{matnr = b}matnr. Thanks.

Re: Inner join

Former Member — Tue, 08 May 2007 07:30:30 GMT

I think it should work fine...

Regards,

Jayant

Re: Inner join

Former Member — Tue, 08 May 2007 07:30:32 GMT

Its fine

It works.

Reward points if useful

Regards

Anji

Re: Inner join

Former Member — Tue, 08 May 2007 07:32:12 GMT

Hi SV,

Refer this code :

SELECT a_{matnr a}mEINS A_{MTART D}MAKTx b_{werks c}lgort

c~labst INTO CORRESPONDING FIELDS OF TABLE IT_MATERIAL

FROM mara AS a

INNER JOIN MAKT AS D on a_{matnr = d}matnr

inner join marc AS b

ON a_{matnr = b}matnr

inner join MARD as c

ON B_{MATNR = C}MATNR AND B_{WERKS = C}WERKS

where A_{MATNR IN S_MATNR and b}werks in s_werks.

Reward points if helpful.

Regards,

Hemant

Re: Inner join

Former Member — Tue, 08 May 2007 07:33:01 GMT

Even if matnr is not a key field in MSEG

Re: Inner join

Former Member — Tue, 08 May 2007 07:36:15 GMT

It will work fine ...

for joins, it is not must to be a key field, but recommended...

Re: Inner join

Former Member — Tue, 08 May 2007 07:42:45 GMT

Yeah you can filter out even if it not a key field....

Regards,

Jayant..