topic Re: urgent in Application Development and Automation Discussions

urgent

Former Member — Wed, 21 Sep 2005 09:04:07 GMT

Hi all,

I want to see all purchage orders but not repeating.

Ex: take 5 purchage orders

1122580002

1122580003

1122580004

I want to c like

1122580002

1122580003

1122580004

which is not repeating.

can u please help me,

Thank you very much,

shashikanth.

Re: urgent

Former Member — Wed, 21 Sep 2005 09:07:28 GMT

You can use

SORT ITAB WITH EBELN.

DELETE ADJACENT DUPLICATES COMPARING EBELN.

Re: urgent

Former Member — Wed, 21 Sep 2005 09:12:17 GMT

u can either use sort ...and then delete adjacent duplicates....

u can also use AT NEW and AT END OF while looping on your internal table if u dont want to lose information by deleting table. Do take note of the restrictions with these control break extracts.

rgds,

Re: urgent

Former Member — Wed, 21 Sep 2005 09:22:26 GMT

hi sasi,

create an internal table with the field ebeln as the first field.

populate the internal table with the purchase order numbers.

sort the internal table.

within loop use AT NEW EBELN.

ok.good luck.

Re: urgent

Former Member — Fri, 23 Sep 2005 15:18:31 GMT

if your are two specfic of column position then you can try with on change of

loop at itab.

on change of <field>

endon.

endloop.

try this i hope this will also do.

Re: urgent

Former Member — Sat, 24 Sep 2005 17:23:52 GMT

Hi,

You can do like this also.

create a internal table <itab>.

select * from ekko into table itab.

loop at itab.

at new ebeln.

write : / itab-ebeln.

endat.

endloop.

Regards,

Sriram.