https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795125#M2024568 <P>Hi all ABAP expert</P> <P>I have an OPEN SQL statement, but met failed. the error message is: "@" is not allowed here.</P> <P>Could anyone advise look below statement? Thanks a lot.</P> <P>SELECT SINGLE A~MATNR, A~MJAHR, A~CPUDT_MKPF, A~CPUTM_MKPF, A~MBLNR, A~ZEILE, A~LIFNR<BR /> FROM MSEG AS A<BR /> WHERE A~MATNR = @WB_QMNON100-MATNR<BR /> AND A~WERKS = @GS_WERKS<BR /> AND A~BWART = @GS_BWART<BR /> AND EXISTS<BR /> ( SELECT B~MATNR, B~MBLNR, B~ZEILE, B~LIFNR, MAX( B~MJAHR ), MAX( B~CPUDT_MKPF ) , MAX( B~CPUTM_MKPF )<BR /> FROM MSEG AS B<BR /> WHERE B~MATNR = A~MATNR<BR /> AND B~MBLNR = A~MBLNR AND B~ZEILE = A~ZEILE<BR /> AND B~LIFNR = A~LIFNR<BR /> AND B~MJAHR = A~MJAHR<BR /> AND B~CPUDT_MKPF = A~CPUDT_MKPF<BR /> AND B~CPUTM_MKPF = A~CPUTM_MKPF<BR /> GROUP BY B~MATNR, B~MBLNR, B~ZEILE, B~LIFNR )<BR /> INTO CORRESPONDING FIELDS OF TABLE @IT_MSEG.</P> Thu, 21 Sep 2023 09:52:37 GMT 128903 2023-09-21T09:52:37Z https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795125#M2024568 <P>Hi all ABAP expert</P> <P>I have an OPEN SQL statement, but met failed. the error message is: "@" is not allowed here.</P> <P>Could anyone advise look below statement? Thanks a lot.</P> <P>SELECT SINGLE A~MATNR, A~MJAHR, A~CPUDT_MKPF, A~CPUTM_MKPF, A~MBLNR, A~ZEILE, A~LIFNR<BR /> FROM MSEG AS A<BR /> WHERE A~MATNR = @WB_QMNON100-MATNR<BR /> AND A~WERKS = @GS_WERKS<BR /> AND A~BWART = @GS_BWART<BR /> AND EXISTS<BR /> ( SELECT B~MATNR, B~MBLNR, B~ZEILE, B~LIFNR, MAX( B~MJAHR ), MAX( B~CPUDT_MKPF ) , MAX( B~CPUTM_MKPF )<BR /> FROM MSEG AS B<BR /> WHERE B~MATNR = A~MATNR<BR /> AND B~MBLNR = A~MBLNR AND B~ZEILE = A~ZEILE<BR /> AND B~LIFNR = A~LIFNR<BR /> AND B~MJAHR = A~MJAHR<BR /> AND B~CPUDT_MKPF = A~CPUDT_MKPF<BR /> AND B~CPUTM_MKPF = A~CPUTM_MKPF<BR /> GROUP BY B~MATNR, B~MBLNR, B~ZEILE, B~LIFNR )<BR /> INTO CORRESPONDING FIELDS OF TABLE @IT_MSEG.</P> Thu, 21 Sep 2023 09:52:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795125#M2024568 128903 2023-09-21T09:52:37Z https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795126#M2024569 <P>Sorry, I got it. </P><P>It did not need "SINGLE" , Thanks. </P> Thu, 21 Sep 2023 09:58:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795126#M2024569 128903 2023-09-21T09:58:25Z https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795127#M2024570 <P>Sorry, I got it. </P><P>It did not need "SINGLE" , Thanks. </P> Thu, 21 Sep 2023 09:58:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-s-wrong-with-the-abap-open-sql/m-p/12795127#M2024570 128903 2023-09-21T09:58:25Z