topic Re: Question regarding: select * into corresponding fields in Application Development and Automation Discussions

Question regarding: select * into corresponding fields

Former Member — Tue, 07 Apr 2009 02:09:07 GMT

Hi,

My question is about this select statement "select * from A into CORRESPONDING FIELDS of Table B". When ABAP executes this statement, would abap select all fields from table A and assign value to table B or would it select only some fields in table A which is existed in table B ?

Thanks,

Pavin

Re: Question regarding: select * into corresponding fields

former_member156446 — Tue, 07 Apr 2009 02:11:11 GMT

select all fields from table A and assign corresponding value to table B

Re: Question regarding: select * into corresponding fields

Former Member — Tue, 07 Apr 2009 02:24:23 GMT

Hi,

In this whether A and B have same fields, i mean... both are of same structure..?

If yes, select query will select all the fields and assign to the table B with the same field name..

If no, means, if A and B are of different structures, then you should not use INTO CORRESPONDING.. though u use it, it will fetch nothing... For this kind of examples you must give the exact field names..like:

SELECT fld1 fld2

FROM tab_a

INTO CORRESPONDIONG FIELDS OF TABLE tab_b.

Hope this explains..