Skip to Content
author's profile photo Former Member
Former Member

The following sql stmt is giving syntax error

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 AFLDATE APRICE ACURRENCY BCOUNTRYFR BCITYFROM BAIRPFROM BCOUNTRYTO BCITYTO B~AIRPTO

FROM SFLIGHT AS A INNER JOIN

SPFLI AS B

INTO CORRESPONDING FIELDS OF ITAB_ALV

ON ACARRID = BCARRID

WHERE CARRID EQ CARRID

AND CONNID EQ CONNID.

kindly tell me the error.

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jul 07, 2008 at 09:34 AM

    >WHERE A~CARRID EQ CARRID

    >AND A~CONNID EQ CONNID.

    add "A~" as above.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2008 at 09:32 AM

    SELECT AFLDATE APRICE ACURRENCY BCOUNTRYFR BCITYFROM BAIRPFROM BCOUNTRYTO BCITYTO B~AIRPTO

    INTO CORRESPONDING FIELDS OF ITAB_ALV

    FROM SFLIGHT AS A INNER JOIN

    SPFLI AS B

    ON ACARRID = BCARRID

    WHERE CARRID EQ CARRID

    AND CONNID EQ CONNID.

    try above

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 09:34 AM

    sorry i had fixed it by own

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2008 at 09:35 AM

    Hi,

    SELECT AFLDATE APRICE ACURRENCY BCOUNTRYFR BCITYFROM BAIRPFROM BCOUNTRYTO BCITYTO B~AIRPTO

    FROM SFLIGHT AS A INNER JOIN

    SPFLI AS B

    INTO CORRESPONDING FIELDS OF ITAB_ALV

    ON ACARRID = BCARRID

    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 ACARRID = CARRID(PARAMETER NAME) AND ACONNID = CONNID(PARAMETER NAME).

    REGARDS.

    sriarm.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 09:37 AM

    Hi,

    try this

    SELECT AFLDATE APRICE ACURRENCY BCOUNTRYFR BCITYFROM BAIRPFROM BCOUNTRYTO BCITYTO B~AIRPTO

    INTO CORRESPONDING FIELDS OF ITAB_ALV

    FROM SFLIGHT AS A INNER JOIN

    SPFLI AS B

    ON ACARRID = BCARRID

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.