topic Re: error: you cannot create an internal table as work area in Application Development and Automation Discussions

error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 12:50:11 GMT

Hi, My code is as follows and when i perform a check it gives the above mentioned error in the select statement.

TYPES: BEGIN OF t_vbrk,

vbeln TYPE vbrk-vbeln,

vtweg TYPE vbrk-vtweg,

END OF t_vbrk.

DATA vbrktab TYPE TABLE OF t_vbrk.

SELECT vbeln

vtweg

FROM vbrk

INTO vbrktab

FOR ALL ENTRIES IN xxcvb

WHERE vbeln = xxcvb-vbeln.

INSERT TABLE vbrktab.

ENDSELECT.

where xxcvb is another internal table with some key values.

Re: error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 12:51:20 GMT

TYPES: BEGIN OF t_vbrk,

vbeln TYPE vbrk-vbeln,

vtweg TYPE vbrk-vtweg,

END OF t_vbrk.

DATA vbrktab TYPE TABLE OF t_vbrk.

SELECT vbeln

vtweg

FROM vbrk

INTO TABLE vbrktab

FOR ALL ENTRIES IN xxcvb

WHERE vbeln = xxcvb-vbeln.

INSERT TABLE vbrktab.

ENDSELECT.

regards

Kannaiah

Re: error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 12:53:47 GMT

Hi,

Check the below code

DATA vbrktab TYPE TABLE OF t_vbrk,

wa_vbrktab type t_vbrk.

SELECT vbeln

vtweg

FROM vbrk

INTO wa_vbrktab

FOR ALL ENTRIES IN xxcvb

WHERE vbeln = xxcvb-vbeln.

Append wa_vbrktab to vbrktab.

ENDSELECT.

Rgds,

Bujji

Re: error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 13:12:58 GMT

thanks kannaiah, but now i am getting another error following that.

it says "specified type has no structure and therefore no component called" , "VBELN"

what can it mean ? again it is pointing to the same SELECT statement.

Re: error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 13:16:04 GMT

thanks Bujji, i tried urs too. but as i told Kannaigh, i am getting the error "specified type has no structure and therefore no component called" , "VBELN"

Re: error: you cannot create an internal table as work area

Former Member — Fri, 30 May 2008 13:20:37 GMT

I don't know how you've defined XXCVB, but u should write:

TYPES: BEGIN OF T_VBRK,
         VBELN TYPE VBRK-VBELN,
         VTWEG TYPE VBRK-VTWEG,
       END OF T_VBRK.

DATA: VBRKTAB    TYPE TABLE OF T_VBRK,
      WA_VBRKTAB TYPE T_VBRK.


SELECT VBELN VTWEG FROM VBRK INTO TABLE VBRKTAB
  FOR ALL ENTRIES IN XXCVB
     WHERE VBELN = XXCVB-VBELN.

LOOP AT VBRKTAB INTO WA_VBRKTAB.
ENDLOOP.

Max