topic select statment - fill internal table in Application Development and Automation Discussions

select statment - fill internal table

Former Member — Mon, 12 Feb 2007 09:47:41 GMT

Hi,

I have following situation:


TYPES: BEGIN OF q_data,
         i_lqua LIKE lqua,
         v_xxx(20) type c,
       END OF q_data.

DATA: a_data TYPE STANDARD TABLE OF q_data.

Now I would write a select statment and fill the table a_data.


select lqua~matnr lqua~werks... from lqua inner join mch1 into (i_lqua-matnr, i_lqua-werks.....)...

Is it possible to write a statement without writing the whole structure (all the names of columns) of lqua in the SQL-statement (lqua_{matnr lqua}werks lqua~........)?

Thanks

Michael

Re: select statment - fill internal table

Former Member — Mon, 12 Feb 2007 09:53:30 GMT

1. you can write that but i think you have to write that in SELECT ...ENDSELECT.

select lqua_{matnr lqua}werks... from lqua inner join mch1 into (i_lqua-matnr, i_lqua-werks.....

append i_lqua.

endselect.

2. OR you can use INTO CORRESPONDING FIELDS OF TABLE

select lqua_{matnr lqua}werks... from lqua inner join mch1 into corresponding fields of table i_lqua.

Re: select statment - fill internal table

Former Member — Mon, 12 Feb 2007 09:53:41 GMT

You could use Select * as the first field in your table is of type lqua.

Re: select statment - fill internal table

Former Member — Mon, 12 Feb 2007 10:08:26 GMT

no in innerjoin you can not do that because if you use * instead of column name then system will be confuse on the common fields between two tables so you have to do like that only.

but 1 thing instead of lqua every time you can use a, b or any alias for that table.

select a_{f1 a}f2 into corresponding fields of table itab from dbtab as a inner join dbtab1 as b on a_{f1 = b}f1.

regards

shiba dutta