2 Select statement into the same internal table

[Former Member]

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?

[Former Member]

You should use Appending corresponding fields of table.

[Former Member]

Hi

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

[Former Member]

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