Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

urgent

Former Member
0 Kudos

Hi all,

I want to see all purchage orders but not repeating.

Ex: take 5 purchage orders

1122580002

1122580002

1122580003

1122580003

1122580004

I want to c like

1122580002

1122580003

1122580004

which is not repeating.

can u please help me,

Thank you very much,

shashikanth.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can use

SORT ITAB WITH EBELN.

DELETE ADJACENT DUPLICATES COMPARING EBELN.

5 REPLIES 5

Former Member
0 Kudos

You can use

SORT ITAB WITH EBELN.

DELETE ADJACENT DUPLICATES COMPARING EBELN.

Former Member
0 Kudos

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,

PJ

0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.