Skip to Content
0
Former Member
Mar 20, 2009 at 08:40 AM

Joining internal tables

19 Views

Hi all,

I have an internal table it_ekpo with the following data :

EBELN EBELP MATNR MENGE

5000000023 0001 test 5

I have another internal table it_ekbe with the following data :

EBELN EBELP BELNR BUZEI DMBTR

5000000023 00001 4900002212 0001 804.04

5000000023 00001 4900002213 0001 804.04

My requirement is to club these 2 internal tables and get a single ALV Internal table as output to generate ALV report.

I tried to modify the it_ekpo by transporting BELNR and DMBTR to it_ekpo. Since there is no differentiator to separate the two records, I am getting a single record output, instead of two records as follows :

EBELN EBELP MATNR MENGE BELNR

5000000023 0001 test 5 4900002213

BUZEI BUDAT MENGE_GI DMBTR

0001 20090317 1.000 804.04

I tried to use sy-tabix also and could not succeed.

I need your guidance in solving this problem.

Thanks in advance.

Rgds

Murali