topic Re: Doubt in Inner Join in Application Development and Automation Discussions

Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 09:40:45 GMT

Hi all,

In a report program i have used a inner join. I am getting error in the where condition. Here I have furnished part of my code for ur reference.

Tables : mara, makt, mard.

data : begin of itab occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

lgort like mard-lgort,

labst like mard-labst,

end of itab.

parameters : mat like mara-matnr.

start-of-selection.

select mara_{matnr makt}maktx mard_{lgort mard}labst into corresponding fields of iab from mara inner join maktx on mara_{matnr = makt}matnr inner join mard on makt_{matnr = mard}matnr where matnr eq mat.

in the where condition I am getting the following error message.

matnr has two meanings in data dictionary.

Please help me in sort out this problem and also tell me more abt inner joins.

Re: Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 09:43:36 GMT

You would need to qualify the matnr in the where condition.

So basically use mara~matnr = mat.

Regards

Anurag

Re: Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 09:46:42 GMT

Arun,

While addressing the inner join its always a better practice to name your dbtables with alias name.

In your abovesaid the ABAP Processor is not sure which material number you are trying for a where condition. Hence use alias name for every table else code the following :

where mara~matnr = mat.

Hope this will solve your problem.

Reward if convinced.

Regards

Re: Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 09:54:44 GMT

hi Arun ,

See the code below . It will be useful for U .

SELECT A~LIFNR

B~BUKRS

C~EKORG

A~KTOKK

A~NAME1

A~STRAS

A~ORT01

A~REGIO

A~PFORT

A~PSTLZ

A~PSTL2

A~TELF1

INTO TABLE ITAB

FROM LFA1 AS A JOIN LFB1 AS B ON A_{LIFNR = B}LIFNR

JOIN LFM1 AS C ON A_{LIFNR = C}LIFNR

WHERE A~LIFNR IN S_LIFNR AND

B~BUKRS IN S_BUKRS AND

C~EKORG IN S_EKORG AND

A~KTOKK IN S_KTOKK.

Re: Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 10:17:18 GMT

hi do like this :;

select mara~matnr

makt~maktx

mard~lgort

mard~labst

into corresponding fields of iab

from <b>mara inner join makt</b>

on mara_{matnr = makt}matnr inner join mard on makt_{matnr = mard}matnr

<b>where matnr = mat.</b>

Regards

Ashok P

Re: Doubt in Inner Join

Former Member — Mon, 07 Aug 2006 10:29:32 GMT

hi Arun,

Do this way..

select a~matnr 
       b~maktx 
       c~lgort 
       c~labst 
  into corresponding fields of iab from mara  as a 
  inner join maktx as b 
  on a~matnr = b~matnr 
  inner join mard as c 
  on b~matnr = c~matnr 
  where matnr eq mat.

Regards,

Santosh

Re: Doubt in Inner Join

Former Member — Fri, 11 Aug 2006 05:34:36 GMT

Hello Arun,

Try like this,

select a~matnr

b~maktx

c~lgort

c~labst

into corresponding fields of tabe itab from

( mara as a inner join makt as b

on a_{matnr = b}matnr

inner join mard as c

on a_{matnr = c}matnr )

where matnr eq mat.

Reward if useful.

Vasanth

Re: Doubt in Inner Join

Former Member — Fri, 11 Aug 2006 05:41:19 GMT

Hi Arun try this...

select mara~matnr

makt~maktx

mard~lgort

mard~labst

into corresponding fields of itab

from mara inner join makt

on mara_{matnr = makt}matnr

inner join mard

on makt_{matnr = mard}matnr

where mara~matnr eq mat.

Re: Doubt in Inner Join

former_member184495 — Fri, 11 Aug 2006 06:45:26 GMT

hi,

you have used 'where matnr eq mat'

instead use 'where mara~matnr eq mat'.

cheers,

Aditya.

Re: Doubt in Inner Join

Former Member — Tue, 13 Mar 2007 15:52:11 GMT

how many join conditions used in table