topic Re: innerjoin in Application Development and Automation Discussions

innerjoin

Former Member — Thu, 10 May 2007 17:30:24 GMT

hi,

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FILEDS OF TABLE itab

FROM ( ( mara AS a

INNERJOIN marc AS c ON a_{matnr = c}matnr )

INNERJOIN mard AS d ON c_{matnr = d}matnr )

WHERE matnr IN mat_no.

is there a mistake in the above stmt. it is giving me a syntac error as field corresponding is unknown.

plz help

Re: innerjoin

Former Member — Thu, 10 May 2007 17:33:31 GMT

where a~matnr in mat_no.

Re: innerjoin

Former Member — Thu, 10 May 2007 17:34:18 GMT

hi alchemi,

try to go thro this code.

u have to use a~matnr in mat_no.

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FILEDS OF TABLE itab

FROM ( ( mara AS a

INNER JOIN marc AS c ON a_{matnr = c}matnr )

INNER JOIN mard AS d ON c_{matnr = d}matnr )

WHERE a~matnr IN mat_no.

u have to declare the internal table with the field names which u are using in the inner join.

Regards...

Arun.

Reward points if useful.

Re: innerjoin

Former Member — Thu, 10 May 2007 17:34:34 GMT

Hi,

Spelling mistake in FIELDS.

GIve

INTO corresponding fields of table itab

Instead of

INTO CORRESPONDING FILEDS OF TABLE itab

Thanks,

Naren

Re: innerjoin

Former Member — Thu, 10 May 2007 17:39:51 GMT

have corrected the spelling mistake.

now it gives has no closing ")"

Re: innerjoin

Former Member — Thu, 10 May 2007 17:41:59 GMT

Hi,

Check the modified SQL..Changes marked in bold..

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( mara AS a

INNERJOIN marc AS c ON a_{matnr = c}matnr )

INNERJOIN mard AS d ON c_{matnr = d}matnr ) ) "Give another )

WHERE a~matnr IN mat_no.

Thanks,

Naren

Re: innerjoin

Former Member — Thu, 10 May 2007 17:42:50 GMT

Give it in one more braces

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FILEDS OF TABLE itab

FROM( ( ( mara AS a

INNERJOIN marc AS c ON a_{matnr = c}matnr )

INNERJOIN mard AS d ON c_{matnr = d}matnr ))

WHERE a~matnr IN mat_no.

Regards,

Laxmi

Re: innerjoin

Former Member — Thu, 10 May 2007 17:50:52 GMT

try this code

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FIElDS OF TABLE itab

FROM mara AS a

INNER JOIN marc AS c ON a_{matnr = c}matnr

INNER JOIN mard AS d ON c_{matnr = d}matnr

WHERE a~matnr in mat_no.

Re: innerjoin

Former Member — Thu, 10 May 2007 17:59:58 GMT

i tried all those suggested above. It is still giving me same error...

has no closing")".

Re: innerjoin

Former Member — Thu, 10 May 2007 18:09:57 GMT

Hi,

Try this..

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FIELDS OF TABLE itab

FROM mara AS a

INNER JOIN marc AS c ON a_{matnr = c}matnr

INNER JOIN mard AS d ON c_{matnr = d}matnr

WHERE a~matnr IN mat_no.

Thanks,

Naren

Re: innerjoin

Former Member — Thu, 10 May 2007 18:12:13 GMT

no good.

It says wrong expression....from clause.

am i the only one getting this...or it happens always with innerjoins?

Re: innerjoin

Former Member — Thu, 10 May 2007 18:13:38 GMT

Hi,

What??I tried this and it generated the code..

SELECT a_{matnr a}ersda a_{aenam c}werks c_{pstat d}lfmon

INTO CORRESPONDING FIELDS OF TABLE itab

FROM mara AS a

INNER JOIN marc AS c ON a_{matnr = c}matnr

INNER JOIN mard AS d ON c_{matnr = d}matnr

WHERE a~matnr IN mat_no.

Thanks,

Naren

Re: innerjoin

ferry_lianto — Thu, 10 May 2007 18:15:30 GMT

Hi,

Please try this.


SELECT A~MATNR A~ERSDA A~AENAM C~WERKS C~PSTAT D~LFMON
INTO CORRESPONDING FIELDS OF TABLE ITAB
FROM ( ( MARA AS A
INNER JOIN MARC AS C ON A~MATNR = C~MATNR
INNER JOIN MARD AS D ON C~MATNR = D~MATNR ) )
WHERE A~MATNR IN MAT_NO.

Regards,

Ferry Lianto

Re: innerjoin

Former Member — Thu, 10 May 2007 18:17:41 GMT

thanks guys.