topic Re: OPEN SQL error in Application Development and Automation Discussions

OPEN SQL error

former_member625844 — Tue, 22 Dec 2020 07:00:47 GMT

I wrote a SQL like below.

FIELD-SYMBOLS:
          <datarow> TYPE ANY,
          <datafield> TYPE ANY.
SELECT adrc~street FROM ekko left join lfa1 on ekko~lifnr = lfa1~lifnr   
left join adrc on lfa1~adrnr = adrc~addrnumber
INTO <datarow>.

And it has error 'If new OPEN SQL syntax used it must used throughtput, including using @ for host variable' I wonder what caused this error, because I tried other SQL clauses and it worked fine. Thx.

Re: OPEN SQL error

JamesG — Tue, 22 Dec 2020 07:12:19 GMT

FIELD-SYMBOLS:
          <datarow> TYPE ANY,
          <datafield> TYPE ANY.
SELECT adrc~street FROM ekko left join lfa1 on ekko~lifnr = lfa1~lifnr
left join adrc on lfa1~adrnr = adrc~addrnumber
INTO @<datarow>.
ENDSELECT.

it need host variable. host variable is your defined variable,it need @.

Re: OPEN SQL error

JamesG — Tue, 22 Dec 2020 07:14:07 GMT

FIELD-SYMBOLS:
          <datarow> TYPE ANY,
          <datafield> TYPE ANY.
SELECT adrc~street FROM ekko left join lfa1 on ekko~lifnr = lfa1~lifnr
left join adrc on lfa1~adrnr = adrc~addrnumber
INTO @<datarow>.
ENDSELECT.

in join table,need it.

Re: OPEN SQL error

former_member689077 — Tue, 22 Dec 2020 11:54:20 GMT

You need to mention @ before mentioning the internal table or work area

Re: OPEN SQL error

Sandra_Rossi — Tue, 22 Dec 2020 17:12:13 GMT

It's using the strict SQL syntax because of the table ADRC which is left-joined on the already left-joined table LFA1. I'm not sure why it's so bad, but the syntax with INNER JOIN is accepted and should do exactly what you want (+ I added ENDSELECT):

SELECT adrc~street
    FROM ekko
    LEFT JOIN lfa1 ON ekko~lifnr = lfa1~lifnr
    INNER JOIN adrc ON lfa1~adrnr = adrc~addrnumber
    INTO <datarow>.
ENDSELECT.