topic Re: regarding inner join in Application Development and Automation Discussions

regarding inner join

Former Member — Fri, 30 Mar 2007 05:48:35 GMT

hi experts,

**this statement is showing the error:

error::the column name 'MATNR' has two meaning.abap/4open sql statement.:

*selection screen

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME title text-001.

PARAMETERS: s_werks like mseg-werks obligatory,

date like mkpf-budat.

select-options:matnr for mard-matnr no intervals.

SELECTION-SCREEN END OF BLOCK B1.

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard inner join mseg on mard~matnr =

mseg~matnr where matnr in matnr and werks = s_werks

PLZ help me to rectifie the error.

thnx in advance.

Message was edited by:

ravi gupta

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:50:29 GMT

Change in where condition. see below changes.

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard inner join mseg on mard~matnr =

mseg~matnr

where mard_{matnr in matnr and mard}werks = s_werks

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:51:05 GMT

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard inner join mseg on mard~matnr =

mseg_{matnr where mard}matnr in matnr and mseg~werks = s_werks

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:51:09 GMT

hI..

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard inner join mseg on mard~matnr =

mseg~matnr where matnr in matnr and werks = s_werks

"where matnr " you need to specify which matnr..i mean..from which table..whether MSEG or MARD..

Message was edited by:

Rammohan Nagam

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:51:50 GMT

Hi,

the error is bcoz the Matnr field is defined in both the tables mseg and mard.

In the statement 'where matnr in matnr and werks = s_werks' u need to specify

MARD_{MATNR or MSEG}MATNR as per the need.

This will solve ur issue.

Regards,

Himanshu

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:54:15 GMT

Hi Ravi ,

The Error was the column name 'MATNR' has two meaning.abap/4open sql statement.: because you have <b>mseg_{matnr mard}matnr</b> so you need to specify which matnr has to be kept in where condition

select-options:matnr for mard-matnr no intervals.

SELECTION-SCREEN END OF BLOCK B1.

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard inner join mseg on mard~matnr =

mseg_{matnr where (<b>mard}matnr or mseg~matnr</b>) (you have to select any one of them )in matnr and werks = s_werks

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:55:17 GMT

Hi,

Write like this

select mard_{matnr mard}werks mard_{lgort mard}labst mard_{insme mard}speme

mseg~lifnr into corresponding

fields of table itab_final from mard innerjoin mseg

on mard_{matnr = mseg}matnr

where mard~matnr in s_matnr and

mard~werks = s_werks and

mseg~budat = s_date.

better take date as Select options and give in S+date in where condnreward if useful

regards,

Anji

Re: regarding inner join

Former Member — Fri, 30 Mar 2007 05:59:16 GMT

Hi Ravi,

Your select statement is wrong.The correct statement is.....

select mard~matnr

mard~werks

mard~lgort

mard~labst

mard~insme

mard~speme

mseg~lifnr

into corresponding fields of table itab_final

from mard inner join mseg

on mard_{matnr = mseg}matnr

where mard_{matnr in matnr and mard}werks = s_werks.

Thanks,

Ramana