topic 2 Select statement into the same internal table in Application Development and Automation Discussions

2 Select statement into the same internal table

Former Member — Mon, 23 Feb 2009 07:57:27 GMT

I have the following statement

SELECT addrnumber AS lfa1adrnr
             name1 AS hname1
             INTO CORRESPONDING FIELDS OF TABLE gt_adrc
             FROM adrc
             FOR ALL ENTRIES IN gt_lfa1
             WHERE addrnumber = gt_lfa1-adrnr.

Followed by another select statement:

SELECT addrnumber AS vbpaadrnr
             name1 AS iname1
             city1
             post_code1
             street
             INTO CORRESPONDING FIELDS OF TABLE gt_adrc
             FROM adrc
             FOR ALL ENTRIES IN gt_vbpa
             WHERE addrnumber = gt_vbpa-adrnr.

Why instead of creating 2 rows of data, it replaced the first row in gt_adrc internal table?

Re: 2 Select statement into the same internal table

Former Member — Mon, 23 Feb 2009 08:00:51 GMT

You should use Appending corresponding fields of table.

Re: 2 Select statement into the same internal table

Former Member — Mon, 23 Feb 2009 08:02:20 GMT

do this


SELECT addrnumber AS vbpaadrnr
             name1 AS iname1
             city1
             post_code1
             street
             APPENDING CORRESPONDING FIELDS OF TABLE gt_adrc
             FROM adrc
             FOR ALL ENTRIES IN gt_vbpa
             WHERE addrnumber = gt_vbpa-adrnr.

Pushpraj

Re: 2 Select statement into the same internal table

Former Member — Mon, 23 Feb 2009 08:05:00 GMT

Hi,

Change the code as follows:

********As it is

SELECT addrnumber AS lfa1adrnr

name1 AS hname1

INTO CORRESPONDING FIELDS OF TABLE gt_adrc

FROM adrc

FOR ALL ENTRIES IN gt_lfa1

WHERE addrnumber = gt_lfa1-adrnr.

Use APPENDING instead of INTO

SELECT addrnumber AS vbpaadrnr

name1 AS iname1

city1

post_code1

street

APPENDING CORRESPONDING FIELDS OF TABLE gt_adrc

FROM adrc

FOR ALL ENTRIES IN gt_vbpa

WHERE addrnumber = gt_vbpa-adrnr.

Regards,

Anil