The following sql stmt is giving syntax error

[Former Member]

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

[former_member195383]

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

[Former Member]

sorry i had fixed it by own

[ThomasZloch]

>WHERE A~CARRID EQ CARRID

>AND A~CONNID EQ CONNID.

add "A~" as above.

[venkatasriram_mygapula]

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.

[Former Member]

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