topic Re: Error with select stmt. in Application Development and Automation Discussions

Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:07:33 GMT

Hi All,

I am getting this error , can you please tell me what I am doing wrong with the select stmt.

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

Incorrect nesting: Before the statement "ENDIF", the structure

introduced by "SELECT" must be concluded by "ENDSELECT". -

Thanks

Veni.

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:15:39 GMT

There are many solutions. You coan creat an internal table with the structure of FKDAT, NETWR AND KZWI1, and place the statement lik this

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK

INTO TABLE INTERNAL_TABLE AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

Or there is only one field with those characteristics

SELECT SINGLE A_{FKDAT A}NETWR B~KZWI1

FROM VBRK

INTO TABLE INTERNAL_TABLE AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

Give points if this helps u.

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:19:02 GMT

Hello Veni,

All you need to do is add an endselect after the sleect.

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

ENDSELECT.

I hope this helps.

Thanks,

Kalyan

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:19:43 GMT

Hi,

IOUT is my internal table, it has lot of fields, thats why I wanted to send the values to specific fields of the table.

Thanks

Veni.

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:23:43 GMT

Hi,

Try this..

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO CORRESPONDING FIELDS OF TABLE IOUT

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR

Thanks,

Naren

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:25:14 GMT

Hi Veni,

Please check this help

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/frameset.htm

Thanks!

Lakshmikandh

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:25:39 GMT

Try:


SELECT a~fkdat a~netwr b~kzwi1
  FROM vbrk AS a
    INNER JOIN vbrp AS b ON
      a~vbeln = b~vbeln
  INTO CORRESPONDING FIELDS OF TABLE iout
  WHERE b~vbeln = iout-vbelv
    AND b~posnr = isdoc-posnr.

Rob

Message was edited by:

Rob Burbank

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:25:46 GMT

Hello Veni,

Please let me know what is the structure of IOUT.

Thanks,

Kalyan

Re: Error with select stmt.

former_member186741 — Tue, 14 Nov 2006 23:30:27 GMT

Rafael, Naren and Rob have all come up with good solutions.....but do you really have the doc number in IOUT-VBELV? There may not be a problem with it but it is unusual to use the same field as the source and target in a select.

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON

A_{VBELN = B}VBELN

INTO (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:50:40 GMT

Hi All,

I tried INTO CORRESPONDING FIELDS OF IOUT

but with this also same error is comming. I am sending part of code.

Please help me.

Thanks

Veni.


TABLES: VBAK, VBAP, KNA1, VBRK, VBRP, VBFA.

DATA: BEGIN OF ISDOC OCCURS 0,
        VBELN LIKE VBAK-VBELN,
        POSNR LIKE VBAP-POSNR,
        KUNNR LIKE VBAK-KUNNR,
        ERDAT LIKE VBAK-ERDAT,
        BSTNK LIKE VBAK-BSTNK,
        MATNR LIKE VBAP-MATNR,
        ARKTX LIKE VBAP-ARKTX.
DATA: END OF ISDOC.

DATA: BEGIN OF IOUT OCCURS 0,
        VBELN LIKE VBAK-VBELN,
        POSNR LIKE VBAP-POSNR,
        KUNNR LIKE VBAK-KUNNR,
        NAME1 LIKE KNA1-NAME1,
        ERDAT LIKE VBAK-ERDAT,
        BSTNK LIKE VBAK-BSTNK,        
        MATNR LIKE VBAP-MATNR,
        ARKTX LIKE VBAP-ARKTX,
        VBELV LIKE VBRP-VBELN,
        FKDAT LIKE VBRK-FKDAT,
        NETWR LIKE VBRK-NETWR,
        KZWI1 LIKE VBRP-KZWI1.
DATA: END OF IOUT.

FORM getdata.

  SELECT A~VBELN B~POSNR A~KUNNR A~ERDAT A~BSTNK B~MATNR B~ARKTX
         FROM VBAK AS A INNER JOIN VBAP AS B ON A~VBELN = B~VBELN
         INTO TABLE ISDOC
         WHERE A~AUART IN SAUART
         AND A~ERDAT IN SERDAT
         AND A~KUNNR IN SKUNNR.
         
               
           SORT ISDOC BY VBELN POSNR.

  LOOP AT ISDOC.

    MOVE-CORRESPONDING ISDOC TO IOUT.

    CLEAR: KNA1.

    SELECT SINGLE * FROM KNA1 WHERE KUNNR = ISDOC-KUNNR.

    IF SY-SUBRC = 0.

      MOVE KNA1-NAME1 TO IOUT-NAME1.

    ENDIF.

    SELECT VBELN INTO IOUT-VBELV FROM VBFA WHERE VBELV = ISDOC-VBELN
                                           AND   POSNV = ISDOC-POSNR
                                           AND   VBTYP_N = 'O'.

      IF SY-SUBRC = 0.

        SELECT A~FKDAT A~NETWR B~KZWI1
               FROM VBRK AS A INNER JOIN VBRP AS B ON A~VBELN = B~VBELN
               INTO CORRESPONDING FIELDS OF IOUT
*               (IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)
                     WHERE B~VBELN = IOUT-VBELV
                     AND   B~POSNR = ISDOC-POSNR.
                     
                     
          APPEND IOUT.
          CLEAR IOUT.
        ENDIF.

      ENDLOOP.
    ENDFORM.                    " getdata

Re: Error with select stmt.

Former Member — Tue, 14 Nov 2006 23:58:44 GMT

Put after

APPEND IOUT.

CLEAR IOUT.

ENDSELECT.

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:08:40 GMT

Hi Rafael,

I did not understand what to put after append and clear.

Thanks

Veni.

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:14:49 GMT

Hi,

use select single

SELECT SINGLE A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON A_{VBELN = B}VBELN

INTO CORRESPONDING FIELDS OF IOUT

(IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

Thanks,

Naren

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:16:49 GMT

Ja, sorry, i think i didn't saw it again.

APPEND IOUT.

ENDSELECT.

When it finish append de internal table go to the next register that finds in the select statement.

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:41:09 GMT

Hi naren,

Select single is also not working. Again same error.

Thanks

Veni.

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:41:27 GMT

hi veni

add single in below select statement.

SELECT SINGLE VBELN INTO IOUT-VBELV FROM VBFA WHERE

VBELV = ISDOC-VBELN

AND POSNV = ISDOC-POSNR

AND VBTYP_N = 'O'.

IF SY-SUBRC = 0.

SELECT A_{FKDAT A}NETWR B~KZWI1

FROM VBRK AS A INNER JOIN VBRP AS B ON A_{VBELN = B}VBELN

INTO CORRESPONDING FIELDS OF IOUT

(IOUT-FKDAT, IOUT-NETWR, IOUT-KZWI1)

WHERE B~VBELN = IOUT-VBELV

AND B~POSNR = ISDOC-POSNR.

APPEND IOUT.

CLEAR IOUT.

ENDIF.

ENDLOOP.

ENDFORM.

Regards

Usman

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 00:50:15 GMT

Thank you Usman.

My error solved.

Thank you all for your help.

Veni.

Re: Error with select stmt.

Former Member — Wed, 15 Nov 2006 15:53:34 GMT

Hi,

Change the VBFA Sql to select single..

SELECT SINGLE VBELN INTO IOUT-VBELV FROM VBFA WHERE VBELV = ISDOC-VBELN

AND POSNV = ISDOC-POSNR

AND VBTYP_N = 'O'.

Thanks,

Naren