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.