Inner join

[Former Member]

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.

[Former Member]

I think it should work fine...

Regards,

Jayant

[Former Member]

Even if matnr is not a key field in MSEG

[Former Member]

Hi

Its fine

It works.

Reward points if useful

Regards

Anji

[Former Member]

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

[Former Member]

It will work fine ...

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

[Former Member]

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

Regards,

Jayant..