topic Re: Hi in Application Development and Automation Discussions

Hi

Former Member — Tue, 31 Jul 2007 06:49:48 GMT

Hi,

I am getting the error that u cannot use Internal table as a work area. Plz tell why it is getting like that.

&----

*& Module Pool ZMP_TAB3

&----

PROGRAM ZMP_TAB3.

TABLES:

VBAK,

VBAP.

DATA:

IT_VBAP TYPE TABLE OF VBAP.

&----

*& Module USER_COMMAND_9001 INPUT

&----

text

----

MODULE USER_COMMAND_9001 INPUT.

CASE SY-UCOMM.

WHEN 'EXIT'.

LEAVE PROGRAM.

WHEN SPACE.

SELECT * FROM VBAP INTO IT_VBAP WHERE VBELN EQ VBAK-VBELN.

ENDCASE.

ENDMODULE. " USER_COMMAND_9001 INPUT

Re: Hi

Former Member — Tue, 31 Jul 2007 06:53:11 GMT

Hi,

PROGRAM ZMP_TAB3.

TABLES:

VBAK,

VBAP.

DATA:

IT_VBAP like VBAP.

&----

*& Module USER_COMMAND_9001 INPUT

&----

text

----

MODULE USER_COMMAND_9001 INPUT.

CASE SY-UCOMM.

WHEN 'EXIT'.

LEAVE PROGRAM.

WHEN SPACE.

SELECT * FROM VBAP INTO IT_VBAP WHERE VBELN EQ VBAK-VBELN.

endselect.

endcase.endmodule.

regards

Nicole

Re: Hi

Former Member — Tue, 31 Jul 2007 06:55:02 GMT

Hi Ram,

Check the code in bold.

&----

*& Module Pool ZMP_TAB3

&----

PROGRAM ZMP_TAB3.

TABLES:

VBAK,

VBAP.

DATA:

IT_VBAP TYPE TABLE OF VBAP OCCURS 0 WITH HEADER LINE.

&----

*& Module USER_COMMAND_9001 INPUT

&----

text

----

MODULE USER_COMMAND_9001 INPUT.

CASE SY-UCOMM.

WHEN 'EXIT'.

LEAVE PROGRAM.

WHEN SPACE.

SELECT * FROM VBAP INTO TABLE IT_VBAP WHERE VBELN EQ VBAK-VBELN.

ENDCASE.

ENDMODULE. " USER_COMMAND_9001 INPUT

Thanks,

Vinay

Re: Hi

Former Member — Tue, 31 Jul 2007 06:55:08 GMT

Hi Ram

When you declare table with Tables statement it just provides work area and you cant use that directly for declaring internal table, better to declare with types statement and use it

Regards

sandhya

Re: Hi

Former Member — Tue, 31 Jul 2007 06:55:16 GMT

hi,

Use either way ..

SELECT * FROM VBAP INTO TABLE IT_VBAP WHERE VBELN EQ VBAK-VBELN.

SELECT * FROM VBAP INTO  IT_VBAP WHERE VBELN EQ VBAK-VBELN.
APPEND  IT_VBAP
CLEAR  IT_VBAP.
ENDSELECT.

Re: Hi

Former Member — Tue, 31 Jul 2007 06:55:16 GMT

Change select stmt like

SELECT * FROM VBAP INTO TABLE IT_VBAP WHERE VBELN EQ VBAK-VBELN.

Re: Hi

gopi_narendra — Tue, 31 Jul 2007 06:55:26 GMT

The reason for the error is the table KEYWORD .

Please see few more corrections in my reply to your other thread


SELECT * FROM VBAP 
         INTO table IT_VBAP " table keyword
         WHERE VBELN EQ VBAK-VBELN.

Regards

Gopi

Re: Hi

Former Member — Tue, 31 Jul 2007 06:57:18 GMT

hi,

TABLES:

VBAK,

VBAP.

DATA:

IT_VBAP like VBAP.

&----

*& Module USER_COMMAND_9001 INPUT

&----

text

----

MODULE USER_COMMAND_9001 INPUT.

CASE SY-UCOMM.

WHEN 'EXIT'.

LEAVE PROGRAM.

WHEN SPACE.

SELECT * FROM VBAP INTO IT_VBAP WHERE VBELN EQ VBAK-VBELN.

endselect.

ENDCASE.

ENDMODULE. " USER_COMMAND_9001 INPUT

REWARDS POINT

Re: Hi

former_member189059 — Tue, 31 Jul 2007 06:58:18 GMT

You have 2 options

1. use

SELECT * FROM VBAP INTO TABLE IT_VBAP WHERE VBELN EQ VBAK-VBELN.

2. declare a work area of the same type and use the code you used before specifying the work area

then append that work area to the table and end it with the ENDSELECT statement

Re: Hi

Former Member — Tue, 31 Jul 2007 06:59:11 GMT

hi,

Table of creates only work area for u so change that internal table declaration as

Data: it_vbap like standard table of vbap.

try it now.

SELECT * FROM VBAP INTO IT_VBAP WHERE VBELN EQ VBAK-VBELN.

if helpful reward some points.

with regards,

Suresh Aluri.