topic Re: The following sql stmt is giving syntax error in Application Development and Automation Discussions

The following sql stmt is giving syntax error

Former Member — Mon, 07 Jul 2008 09:30:09 GMT

Dear abap experts,

The following sql stmt is givin me the followin error.

Incorrect expression " A~CURRENCY" in WHERE condition.

the sql stmt is

SELECT A_{FLDATE A}PRICE A_{CURRENCY B}COUNTRYFR B_{CITYFROM B}AIRPFROM B_{COUNTRYTO B}CITYTO B~AIRPTO

FROM SFLIGHT AS A INNER JOIN

SPFLI AS B

INTO CORRESPONDING FIELDS OF ITAB_ALV

ON A_{CARRID = B}CARRID

WHERE CARRID EQ CARRID

AND CONNID EQ CONNID.

kindly tell me the error.

Edited by: Ansuman Parhi on Jul 7, 2008 11:30 AM

Re: The following sql stmt is giving syntax error

former_member195383 — Mon, 07 Jul 2008 09:32:16 GMT

SELECT A_{FLDATE A}PRICE A_{CURRENCY B}COUNTRYFR B_{CITYFROM B}AIRPFROM B_{COUNTRYTO B}CITYTO B~AIRPTO

INTO CORRESPONDING FIELDS OF ITAB_ALV

FROM SFLIGHT AS A INNER JOIN

SPFLI AS B

ON A_{CARRID = B}CARRID

WHERE CARRID EQ CARRID

AND CONNID EQ CONNID.

try above

Edited by: Rudra Prasanna Mohapatra on Jul 7, 2008 11:33 AM

Re: The following sql stmt is giving syntax error

Former Member — Mon, 07 Jul 2008 09:34:07 GMT

sorry i had fixed it by own

Re: The following sql stmt is giving syntax error

ThomasZloch — Mon, 07 Jul 2008 09:34:58 GMT

>WHERE A~CARRID EQ CARRID

>AND A~CONNID EQ CONNID.

add "A~" as above.

Re: The following sql stmt is giving syntax error

venkatasriram_mygapula — Mon, 07 Jul 2008 09:35:13 GMT

Hi,

SELECT A_{FLDATE A}PRICE A_{CURRENCY B}COUNTRYFR B_{CITYFROM B}AIRPFROM B_{COUNTRYTO B}CITYTO B~AIRPTO

FROM SFLIGHT AS A INNER JOIN

SPFLI AS B

INTO CORRESPONDING FIELDS OF ITAB_ALV

ON A_{CARRID = B}CARRID

WHERE CARRID EQ CARRID

AND CONNID EQ CONNID.

above ur code.

in the where condition exactly mention carrid and connid for belongs to which table. mean check it elow code.

WHERE A_{CARRID = CARRID(PARAMETER NAME) AND A}CONNID = CONNID(PARAMETER NAME).

REGARDS.

sriarm.

Re: The following sql stmt is giving syntax error

Former Member — Mon, 07 Jul 2008 09:37:40 GMT

Hi,

try this

SELECT A_{FLDATE A}PRICE A_{CURRENCY B}COUNTRYFR B_{CITYFROM B}AIRPFROM B_{COUNTRYTO B}CITYTO B~AIRPTO

INTO CORRESPONDING FIELDS OF ITAB_ALV

FROM SFLIGHT AS A INNER JOIN

SPFLI AS B

ON A_{CARRID = B}CARRID

WHERE A~CARRID EQ CARRID

AND A~CONNID EQ CONNID.

In WHERE Condition You have to Mention Carrid or Connid From Which Table.Metion the alias.

Regards,

Sujit