Skip to Content
0
Former Member
Oct 19, 2005 at 03:30 PM

Creating Internal table from Multiple tables

122 Views

Hi ,

I,m trying to create an internal table from 5 databse tables namely

PA0001-PERNR, PA0002-NACHN, VORNA, PA0009-BANKN, PA0002-PERID, PA0000-STAT2, PA0006-STRAS,PSTLZ,LAND1 (when the PA0006-SUBTY is 1)

Condition for this is that this internal table should contain all the records that are present in the PPOIX table for which I wrote the following code

SELECT * FROM PPOIX

INTO wa_ppoix.

APPEND wa_ppoix TO it_ppoix.

ENDSELECT.

DELETE ADJACENT DUPLICATES FROM it_ppoix comparing PERNR.

Now I want to build a internal table for all the unique values fetched in it_ppoix

my structure looks as below

BEGIN OF rere_KuLe,

reId type PA0001-PERNR,

reTy(1) type c,

reNav1 type PA0002-NACHN,

reNav2 type PA0002-VORNA,

bnkAcNo type PA0009-BANKN,

enhNr type PA0002-PERID,

status type PA0000-STAT2,

crCn(20) type c,

add1 type PA0006-STRAS,

add2 type PA0006-PSTLZ,

add3 type PA0006-LAND1,

date(8) type c,

date1(8) type c,

END OF rere_KuLe.

can someone please help on the same or give me an general approach on achieving the same.

Thanks for your help in advance.

Thanks,

Advait.