09-22-2008 11:07 AM
hi,
i have an itab of stucture
1 pqrs pqrs1 0010
1 pqrsx pqrs1 0010
1 pqrsx pqrs1 0020
i want my it1 of structure
1 pqrs pqrs1 0010
1 pqrsx pqrs1 0020
any pointer
09-22-2008 11:10 AM
hi,
it1[] = itab[].
sort it1.
delete adjacent duplicates from it1 comparing all fields.
Regards
MD
09-22-2008 11:10 AM
loop at itab into wa.
delete itab from wa comparing col1 = 1
col2 = pqrsx
col3 =pqrs1
col4 =0010
endloop.
09-22-2008 11:11 AM
>
> loop at itab into wa.
> delete itab from wa comparing col1 = 1
> col2 = pqrsx
> col3 =pqrs1
> col4 =0010
>
> endloop.
What is this brother?
09-22-2008 11:10 AM
1 pqrs pqrs1 0010"<<<<---first sort than Delete adjcent duplicate on this field(0010)
1 pqrsx pqrs1 0010
1 pqrsx pqrs1 0020
09-22-2008 11:10 AM
hi,
it1[] = itab[].
sort it1.
delete adjacent duplicates from it1 comparing all fields.
Regards
MD
09-22-2008 11:10 AM
hi,
first sort ur internal table based on ur fields descending.
then use delete adjacent duplicates comparing ur fields.
09-22-2008 11:13 AM
Hi Priya,
Your question is not very clear.
Do you want out of following two records, only the last one to be moced to to IT1 ?
1 pqrsx pqrs1 0010
1 pqrsx pqrs1 0020
LOOP AT itab.
AT END OF second_field.
APPEND itab TO it1.
ENDLOOP.
09-22-2008 11:18 AM