topic Re: itab in Application Development and Automation Discussions

itab

Former Member — Mon, 22 Sep 2008 10:07:23 GMT

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

Re: itab

Former Member — Mon, 22 Sep 2008 10:10:10 GMT

loop at itab into wa.

delete itab from wa comparing col1 = 1

col2 = pqrsx

col3 =pqrs1

col4 =0010

endloop.

Re: itab

Former Member — Mon, 22 Sep 2008 10:10:29 GMT

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

Re: itab

Former Member — Mon, 22 Sep 2008 10:10:29 GMT

hi,

it1[] = itab[].

sort it1.

delete adjacent duplicates from it1 comparing all fields.

Regards

Re: itab

GauthamV — Mon, 22 Sep 2008 10:10:45 GMT

hi,

first sort ur internal table based on ur fields descending.

then use delete adjacent duplicates comparing ur fields.

Re: itab

Former Member — Mon, 22 Sep 2008 10:11:49 GMT


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

What is this brother?

Re: itab

Former Member — Mon, 22 Sep 2008 10:13:12 GMT

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.

Re: itab

Former Member — Mon, 22 Sep 2008 10:18:12 GMT

Hi Priya,

Use AT NEW statement .

Regards,

Sravanthi