Skip to Content
0
Former Member
Feb 23, 2009 at 07:57 AM

2 Select statement into the same internal table

1443 Views

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?