innerjoin

[Former Member]

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

[Former Member]

where a~matnr in mat_no.

[Former Member]

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 <b>a~matnr IN mat_no</b>.

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.

[Former Member]

Hi,

Spelling mistake in FIELDS.

GIve

INTO corresponding fields of table itab

Instead of

INTO CORRESPONDING <b>FILEDS</b> OF TABLE itab

Thanks,

Naren

[Former Member]

have corrected the spelling mistake.

now it gives has no closing ")"

[Former Member]

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.

[Former Member]

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

has no closing")".

[Former Member]

Hi,

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

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

INTO CORRESPONDING <b>FIELDS</b> 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 ) <b>)</b> "Give another )

WHERE <b>a~</b>matnr IN mat_no.

Thanks,

Naren

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

no good.

It says wrong expression....from clause.

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

[Former Member]

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

[ferry_lianto]

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

[Former Member]

thanks guys.