topic Re: select from intrenal table in Application Development and Automation Discussions

select from intrenal table

Former Member — Mon, 27 Aug 2007 17:40:26 GMT

hi all

i heard that i can do select from internal table with

select a1

from (itab)

into....

Regards

Re: select from intrenal table

RichHeilman — Mon, 27 Aug 2007 17:41:47 GMT

You heard wrong, that can not be done, you can only use the SELECT statement against database tables. In your to read an internal table, you must use the LOOP AT syntax or the READ TABLE syntax.

Regards,

Rich Heilman

Re: select from intrenal table

Former Member — Mon, 27 Aug 2007 17:44:38 GMT

o.k. thankes

i wont to buield table in se 11 to insert the data from itab to that i can do that select from there

how i declare it ?

Regards

Re: select from intrenal table

Former Member — Mon, 27 Aug 2007 17:48:38 GMT

Hi,

You can insert data from Internal to Z table.

Declare the internal with fields of Z table.

Get the tables from related tables. And use insert statement to insert data into z table.

Thanks,

Sriram Ponna.

Re: select from intrenal table

RichHeilman — Mon, 27 Aug 2007 17:49:12 GMT

Are you asking how to build a table in SE11? or are you asking how to declare the internal table which could insert data into the "Z" database table?

If the latter, you can simply declare it like this.

data: itab type table of ztab.
data: wa like line of itab.

wa-fld1 = 'ABC'.
wa-fld2 = 'DEF'.
append wa to itab.

wa-fld1 = 'GHI'.
wa-fld2 = 'JKL'.
append wa to itab.

* Now insert into the database table.
insert ztab from table itab.

Regards,

RIch Heilman

Re: select from intrenal table

Former Member — Mon, 27 Aug 2007 17:51:16 GMT

i ask how to buield table in se11 that i can do insert from itab to it.

size and class

Regards

Re: select from intrenal table

Former Member — Mon, 27 Aug 2007 17:57:09 GMT

Hi antonio rodrigo,

use INSERT, follow a example:

INSERT INTO (TABLE) VALUES (INTERNAL TABLE).

IF SY-SUBRC = 0.

*Message if OK.

MESSAGE I398(00) WITH 'OK'.

ELSE.

*Message if error.

MESSAGE e398(00) WITH 'Error'.

ENDIF.

You can add too using the transation 'SM30'.

You need to create a "Table Maintanance Generator" at Menu "Utilities" into Maintance Table('SE11').

Regards,

Allan Cristian

Message was edited by:

Allan Cristian

Re: select from intrenal table

abapdeveloper20 — Tue, 28 Aug 2007 11:10:15 GMT

Hi..

1 . Create a table(for Eg : ZQCWHSTOCK) in SE11.

2. In your program

DATA : STOCKINT TYPE STANDARD TABLE OF ZQCWHSTOCK

INITIAL SIZE 0 WITH HEADER LINE.

SELECT * FROM ZQCWHSTOCK INTO CORRESPONDING FIELDS OF TABLE STOCKINT.

INSERT ZQCWHSTOCK FROM TABLE STOCKINT.

Regards,

Lakshmiraj

Reward points if helpful