itab

[Former Member]

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

[Former Member]

hi,

first sort ur internal table based on ur fields descending.

then use delete adjacent duplicates comparing ur fields.

[Former Member]

loop at itab into wa.

delete itab from wa comparing col1 = 1

col2 = pqrsx

col3 =pqrs1

col4 =0010

endloop.

[Former Member]

>

> loop at itab into wa.
> delete itab from wa comparing col1 = 1 
> col2 = pqrsx 
> col3 =pqrs1 
> col4 =0010
> 
> endloop.

What is this brother?

[Former Member]

1 pqrs pqrs1 0010"<<<<---first sort than Delete adjcent duplicate on this field(0010) 
1 pqrsx pqrs1 0010
1 pqrsx pqrs1 0020

[Former Member]

hi,

it1[] = itab[].

sort it1.

delete adjacent duplicates from it1 comparing all fields.

Regards

MD

[GauthamV]

hi,

first sort ur internal table based on ur fields descending.

then use delete adjacent duplicates comparing ur fields.

[Former Member]

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.

[Former Member]

Hi Priya,

Use AT NEW statement .

Regards,

Sravanthi