Hi

[Former Member]

Hi,

I am writing The staement on Innerjoin. Iam getting the following error.

Incorrect expression "EKKO~AEDAT" in logical condition.

Also where we write the Innerjoin Statement is it after Select options or after start of Selection.

SELECT EKKO_{EKGRP EKKO}AEDAT EKKO_{EBELN EKKO}SUBMI EKKO_{BSART EKKO}KTWRT EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFB1_{MINDK ADRC}HOUSE_NUM1 ADRC_{STREET ADRC}PO_BOX ADR6_{SMTP_ADDR WYT3}LIFN2 INTO TABLE IT_TAB1

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK

EKKO~AEDAT IN SAEDAT

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

[Former Member]

Hi,

See the below query

SELECT EKKO_{EKGRP EKKO}AEDAT EKKO_{EBELN EKKO}SUBMI EKKO_{BSART EKKO}KTWRT EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFB1_{MINDK ADRC}HOUSE_NUM1 ADRC_{STREET ADRC}PO_BOX ADR6_{SMTP_ADDR WYT3}LIFN2 INTO TABLE IT_TAB1

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK

<b>and</b>

EKKO~AEDAT IN SAEDAT

<b>AND</b>

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

Thanks,CSR.

[Former Member]

Hi

AND is missing before EKKO~AEDAT

write this after start of selection

SELECT EKKO_{EKGRP EKKO}AEDAT EKKO_{EBELN EKKO}SUBMI EKKO_{BSART EKKO}KTWRT EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFB1_{MINDK ADRC}HOUSE_NUM1 ADRC_{STREET ADRC}PO_BOX ADR6_{SMTP_ADDR WYT3}LIFN2 INTO TABLE IT_TAB1

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK and

EKKO~AEDAT IN SAEDAT and

ekko~bstyp = 'A' and

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

<b>Reward points for useful Answers</b>

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[gopi_narendra]

SELECT EKKO~EKGRP EKKO~AEDAT EKKO~EBELN EKKO~SUBMI EKKO~BSART EKKO~KTWRT EKKO~LIFNR
LFA1~KTOKK LFA1~NAME1 LFB1~MINDK ADRC~HOUSE_NUM1 ADRC~STREET ADRC~PO_BOX ADR6~SMTP_ADDR WYT3~LIFN2 INTO TABLE IT_TAB1
FROM EKKO INNER JOIN LFA1 ON EKKO~LIFNR EQ LFA1~LIFNR
JOIN LFB1 ON LFA1~LIFNR EQ LFB1~LIFNR
JOIN WYT3 ON LFA1~LIFNR EQ WYT3~LIFNR
JOIN ADRC ON LFA1~ADRNR EQ ADRC~ADDRNUMBER
JOIN ADR6 ON ADRC~ADDRNUMBER EQ ADR6~ADDRNUMBER
WHERE LFB1~MINDK IN SMINDK
  AND EKKO~AEDAT IN SAEDAT " AND is missing
  AND EKKO~EKGRP IN SEKGRP " Correct this way
  AND EKKO~LIFNR IN SLIFNR.  " AND for all the where clauses

Regards

Gopi

[Former Member]

Hi...

you missed and in where condition..

WHERE LFB1~MINDK IN SMINDK <b>AND</b>

EKKO~AEDAT IN SAEDAT

regards,

Omkar.

[former_member196299]

Hi

You should write the inner join after the start-of-selection event .

Regards,

Ranjita

[former_member189059]

When using where option with more than one selection field criteria, use the AND keyword between the two (or OR keyword if applicable)

Whenever you see a statement like 'Incorrect expression', it is usually associated with the previous statement not being closed or continued properly

[Former Member]

Hi,

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK

<b>AND</b>

EKKO~AEDAT IN SAEDAT

<b>AND</b>

EKKO~EKGRP IN SEKGRP

<b>AND</b>

EKKO~LIFNR IN SLIFNR.

rEGARDS